summaryrefslogtreecommitdiff
Side-by-side diff
Diffstat (more/less context) (show whitespace changes)
-rw-r--r--noncore/apps/opie-sheet/Excel.cpp83
-rw-r--r--noncore/apps/opie-sheet/Excel.h47
-rw-r--r--noncore/apps/opie-sheet/cellformat.cpp42
-rw-r--r--noncore/apps/opie-sheet/cellformat.h42
-rw-r--r--noncore/apps/opie-sheet/finddlg.cpp42
-rw-r--r--noncore/apps/opie-sheet/finddlg.h39
-rw-r--r--noncore/apps/opie-sheet/main.cpp35
-rw-r--r--noncore/apps/opie-sheet/mainwindow.cpp43
-rw-r--r--noncore/apps/opie-sheet/mainwindow.h43
-rw-r--r--noncore/apps/opie-sheet/numberdlg.cpp38
-rw-r--r--noncore/apps/opie-sheet/numberdlg.h36
-rw-r--r--noncore/apps/opie-sheet/opie-sheet.pro19
-rw-r--r--noncore/apps/opie-sheet/sheet.cpp122
-rw-r--r--noncore/apps/opie-sheet/sheet.h36
-rw-r--r--noncore/apps/opie-sheet/sortdlg.cpp42
-rw-r--r--noncore/apps/opie-sheet/sortdlg.h39
-rw-r--r--noncore/apps/opie-sheet/textdlg.cpp38
-rw-r--r--noncore/apps/opie-sheet/textdlg.h36
18 files changed, 618 insertions, 204 deletions
diff --git a/noncore/apps/opie-sheet/Excel.cpp b/noncore/apps/opie-sheet/Excel.cpp
index fc49d56..57aef20 100644
--- a/noncore/apps/opie-sheet/Excel.cpp
+++ b/noncore/apps/opie-sheet/Excel.cpp
@@ -1,1527 +1,1574 @@
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
+#include "Excel.h"
+/* STD */
#include <stdio.h>
#include <stdlib.h>
#include <math.h>
#include <time.h>
#include <sys/types.h>
#include <strings.h>
-#include "Excel.h"
static xfrecord formatter[] = {
{ 0xe , DATEFORMAT, "%m/%d/%y"},
{ 0xf , DATEFORMAT, "%d-%b-%y"},
{ 0x10, DATEFORMAT, "%d-%b"},
{ 0x11, DATEFORMAT, "%b-%y"},
{ 0x12, DATEFORMAT, "%I:%M %p"},
{ 0x13, DATEFORMAT, "%I:%M:%S %p"},
{ 0x14, DATEFORMAT, "%H:%M"},
{ 0x15, DATEFORMAT, "%H:%M:%S"},
{ 0x16, DATEFORMAT, "%m/%d/%y %H:%M"},
{ 0x2d, DATEFORMAT, "%M:%S"},
{ 0x2e, DATEFORMAT, "%H:%M:%S"},
{ 0x2f, DATEFORMAT, "%M:%S"},
{ 0xa5, DATEFORMAT, "%m/%d/%y %I:%M %p"},
{ 0x1 , NUMBERFORMAT, "%.0f"},
{ 0x2 , NUMBERFORMAT, "%.2f"},
{ 0x3 , NUMBERFORMAT, "#,##%.0f"},
{ 0x4 , NUMBERFORMAT, "#,##%.2f"},
{ 0x5 , NUMBERFORMAT, "$#,##%.0f"},
{ 0x6 , NUMBERFORMAT, "$#,##%.0f"},
{ 0x7 , NUMBERFORMAT, "$#,##%.2f"},
{ 0x8 , NUMBERFORMAT, "$#,##%.2f"},
{ 0x9 , NUMBERFORMAT, "%.0f%%"},
{ 0xa , NUMBERFORMAT, "%.2f%%"},
{ 0xb , NUMBERFORMAT, "%e"},
{ 0x25, NUMBERFORMAT, "#,##%.0f;(#,##0)"},
{ 0x26, NUMBERFORMAT, "#,##%.0f;(#,##0)"},
{ 0x27, NUMBERFORMAT, "#,##%.2f;(#,##0.00)"},
{ 0x28, NUMBERFORMAT, "#,##%.2f;(#,##0.00)"},
{ 0x29, NUMBERFORMAT, "#,##%.0f;(#,##0)"},
{ 0x2a, NUMBERFORMAT, "$#,##%.0f;($#,##0)"},
{ 0x2b, NUMBERFORMAT, "#,##%.2f;(#,##0.00)"},
{ 0x2c, NUMBERFORMAT, "$#,##%.2f;($#,##0.00)"},
{ 0x30, NUMBERFORMAT, "##0.0E0"},
{ 0, 0, ""}
};
int ExcelBook::Integer2Byte(int b1, int b2)
{
int i1 = b1 & 0xff;
int i2 = b2 & 0xff;
int val = i2 << 8 | i1;
return val;
};
int ExcelBook::Integer4Byte(int b1,int b2,int b3,int b4)
{
int i1 = Integer2Byte(b1, b2);
int i2 = Integer2Byte(b3, b4);
int val = i2 << 16 | i1;
return val;
};
-int ExcelBook::Integer2ByteFile(FILE *f) {
+int ExcelBook::Integer2ByteFile(FILE *f)
+{
int i1, i2;
i1 = fgetc(f);
i2 = fgetc(f);
return Integer2Byte(i1,i2);
};
float ExcelBook::Float4Byte(int b1, int b2, int b3, int b4)
{
int i;
float f;
unsigned char *ieee;
ieee = (unsigned char *) &f;
for (i = 0; i < 4; i++) ieee[i] = 0;
ieee[0] = ((int)b4) & 0xff;
ieee[1] = ((int)b3) & 0xff;
ieee[2] = ((int)b2) & 0xff;
ieee[3] = ((int)b1) & 0xff;
return f;
};
double ExcelBook::Double4Byte(int b1, int b2, int b3, int b4)
{
long int rk;
double value;
rk=Integer4Byte(b1,b2,b3,b4);
//printf("Double4Bytes:%d,%d,%d,%d\r\n",b1,b2,b3,b4);
if ( (rk & 0x02) != 0)
{
long int intval = rk >> 2; //drops the 2 bits
printf("Double4Byte:intval=%d, rk=%d, rk>>2=%d\r\n",intval,rk,rk>>2);
value = (double) intval;
printf("Double4Byte: VALUEINT=%f\r\n",value);
if ( (rk & 0x01) != 0)
{
value /= 100.0;
};
return value;
- }else
+ }
+ else
{
union { double d; unsigned long int b[2]; } dbl_byte;
unsigned long int valbits = (rk & 0xfffffffc);
#if defined(__arm__) && !defined(__vfp__)
dbl_byte.b[0]=valbits;
dbl_byte.b[1]=0;
#else
dbl_byte.b[0]=0;
dbl_byte.b[1]=valbits;
#endif
printf("dbl_byte.b[0]=%d,dbl_byte.b[1]=%d\r\n",dbl_byte.b[0],dbl_byte.b[1]);
value=dbl_byte.d;
printf("Double4Byte: VALUE=%f\r\n",value);
if ( (rk & 0x01) != 0)
{
value /= 100.0;
};
return value;
};
};
void ExcelBook::DetectEndian(void)
{
int end;
long i = 0x44332211;
unsigned char* a = (unsigned char*) &i;
end = (*a != 0x11);
- if (end == 1) {
+ if (end == 1)
+ {
endian = BIG_ENDIAN;
printf("BIGENDIAN!\r\n");
- } else {
+ }
+ else
+ {
endian = LITTLE_ENDIAN;
printf("LITTLEENDIAN!\r\n");
}
};
double ExcelBook::Double8Byte(int b1, int b2, int b3, int b4, int b5, int b6, int b7, int b8)
{
int i;
double d;
unsigned char *ieee;
ieee = (unsigned char *)&d;
for (i = 0; i < 8; i++) ieee[i] = 0;
- if (endian == BIG_ENDIAN) {
+ if (endian == BIG_ENDIAN)
+ {
ieee[0] = ((int)b8) & 0xff;ieee[1] = ((int)b7) & 0xff;
ieee[2] = ((int)b6) & 0xff;ieee[3] = ((int)b5) & 0xff;
ieee[4] = ((int)b4) & 0xff;ieee[5] = ((int)b3) & 0xff;
ieee[6] = ((int)b2) & 0xff;ieee[7] = ((int)b1) & 0xff;
- } else {
+ }
+ else
+ {
ieee[0] = ((int)b1) & 0xff;ieee[1] = ((int)b2) & 0xff;
ieee[2] = ((int)b3) & 0xff;ieee[3] = ((int)b4) & 0xff;
ieee[4] = ((int)b5) & 0xff;ieee[5] = ((int)b6) & 0xff;
ieee[6] = ((int)b7) & 0xff;ieee[7] = ((int)b8) & 0xff;
}
return d;
};
bool ExcelBook::OpenFile(char *Filename)
{
printf("Opening excel file!\r\n");
File= fopen(Filename, "r");
Position=0; // first byte index in file
XFRecords.resize(0);
SharedStrings.resize(0);
Names.resize(0);
Sheets.resize(0);
if(File==NULL) return false;
printf("Opened excel file!\r\n");
return true;
};
bool ExcelBook::CloseFile(void)
{
int w1;
for(w1=0;w1<(int)XFRecords.count();w1++)
{
if(XFRecords[w1]!=NULL) {delete XFRecords[w1];XFRecords[w1]=NULL;};
};
for(w1=0;w1<(int)SharedStrings.count();w1++)
{
if(SharedStrings[w1]!=NULL) {delete SharedStrings[w1];SharedStrings[w1]=NULL;};
};
for(w1=0;w1<(int)Names.count();w1++)
{
if(Names[w1]!=NULL) {delete Names[w1];Names[w1]=NULL;};
};
for(w1=0;w1<(int)Sheets.count();w1++)
{
if(Sheets[w1]!=NULL) {delete Sheets[w1];Sheets[w1]=NULL;};
};
XFRecords.resize(0);
SharedStrings.resize(0);
Names.resize(0);
Sheets.resize(0);
fclose(File);
printf("closed excel file!\r\n");
if(File==NULL) return true;
return false;
};
void ExcelBook::SeekPosition(int pos)
{
if(!feof(File))
{
Position=pos;
//printf("SeekPosition:Pos:%d\r\n",Position);
fseek(File,pos,SEEK_SET);
};
};
void ExcelBook::SeekSkip(int pos)
{
if(!feof(File))
{
Position=Position+pos;
//printf("SeekSkip:Pos:%d\r\n",Position);
fseek(File, Position, SEEK_SET);
};
};
int ExcelBook::FileEOF(void)
{
if(File!=NULL) return(feof(File)); else return 0;
//EOF is defined in stdlib as -1
};
int ExcelBook::Get2Bytes(void)
{
int i1,i2;
i1=0; i2=0;
if (!feof(File))
{
i1=fgetc(File);
Position++;
};
if (!feof(File))
{
i2=fgetc(File);
Position++;
};
return Integer2Byte(i1,i2);
};
char* ExcelBook::Read(int pos, int length)
{
int i;
char *data;
data= new char[length];
SeekPosition(pos);
for(i=0; i<length; i++)
{
if(!feof(File)) data[i]=fgetc(File);
};
Position= Position+length;
return data;
};
QString ExcelBook::ReadUnicodeChar(int pos, int length)
{
int i;
QString data;
int i1=' ',i2=' ',ii;
SeekPosition(pos);
for(i=0; i<length; i++)
{
if(!feof(File)) i1=fgetc(File);
if(!feof(File)) i2=fgetc(File);
ii=Integer2Byte(i1,i2);
data.append(ii);
Position+=2;
};
return data;
};
QString* ExcelBook::GetString(int num)
{
if(num>=0 && num<(int)SharedStrings.count())
{
return SharedStrings[num];
};
return new QString("");
};
int ExcelBook::SeekBOF(void)
{
int opcode,version,streamtype,length,ret=0;
char *data;
while(!feof(File))
{
opcode=Get2Bytes();
if(opcode==XL_BOF)
{
length=Get2Bytes();
data=Read(Position,length);
version=Integer2Byte(data[0], data[1]);
streamtype=Integer2Byte(data[2], data[3]);
printf("SEEKBOF:opcode=XLBOF, %d ,version %d\r\n",Position,version);
delete data; data=NULL;
if (version==BIFF8) ret=8;
else if(version==BIFF7) ret=7;
printf("SEEKBOF:versionBIFF%d\r\n",ret);
if(streamtype==WBKGLOBAL) return ret *2;
else if(streamtype==WRKSHEET) return ret *1;
return 1;
};
};
return 0;
};
ExcelBREC* ExcelBook::GetBREC(void)
{
ExcelBREC* rec;
rec= new ExcelBREC;
if(FileEOF()) return NULL;
rec->data=NULL;
rec->code=Get2Bytes();
rec->length=Get2Bytes();
rec->position=Position;
SeekSkip(rec->length);
return rec;
};
ExcelBREC* ExcelBook::PeekBREC(void)
{
int oldpos;
ExcelBREC* NextRec;
oldpos=Position;
NextRec=GetBREC();
SeekPosition(oldpos);
return NextRec;
};
char* ExcelBook::GetDataOfBREC(ExcelBREC* record)
{
if(record->data==NULL)
{
ConvertCharToArray(record,Read(record->position,record->length),record->length);
};
return record->data;//new?
};
void ExcelBook::ConvertCharToArray(ExcelBREC* record, char* chars, int length)
{
record->data=new char[length];
for(int w1=0;w1<=length-1;w1++)
record->data[w1]=chars[w1];
};
bool ExcelSheet::InitCells()
{
int r;
Cells.resize(rows * cols + cols+1);
if(Cells.count()==0) return false;
for(r=0;r < Cells.count();r++)
{
Cells[r]=NULL;
};
return true;
};
void ExcelSheet::Set(int row, int col, ExcelCell* cell)
{
if(cell!=NULL&&(row*cols+col)<Cells.count())
{
Cells[row*cols+col]=cell;
};
};
ExcelCell* ExcelSheet::Get(int row, int col)
{
ExcelCell* cell;
cell=Cells[row*cols+col];
if(cell==NULL) return NULL;
return cell;
};
int ExcelBook::SheetHandleRecord(ExcelSheet* sheet, ExcelBREC* record)
{
char* data=NULL;
switch (record->code)
{
case XL_DIMENSION:
data = GetDataOfBREC(record);
if (record->length == 10)
{
sheet->rows = Integer2Byte(data[2], data[3]);
sheet->cols = Integer2Byte(data[6], data[7]);
- } else
+ }
+ else
{
sheet->rows = Integer4Byte(data[4], data[5], data[6], data[7]);
sheet->cols = Integer2Byte(data[10], data[11]);
}
sheet->InitCells();
break;
case XL_LABELSST:
HandleLabelSST(sheet, record);
break;
case XL_RK:
case XL_RK2:
HandleRK(sheet, record);
break;
case XL_MULRK:
HandleMulrk(sheet, record);
break;
case XL_ROW:
break;
case XL_NUMBER:
HandleNumber(sheet, record);
break;
case XL_BOOLERR:
break;
case XL_CONTINUE:
break;
case XL_FORMULA:
case XL_FORMULA2:
HandleFormula(sheet, record);
break;
case XL_LABEL:
break;
case XL_NAME:
HandleName(sheet, record);
break;
case XL_BOF:
break;
case XL_EOF:
return 0;
default:
break;
};
return 1;
};
int ExcelBook::ReadSheet(ExcelSheet* sheet)
{
ExcelBREC* record;
int oldpos;
oldpos = Position;
SeekPosition(sheet->position);
record = GetBREC();
while (record!=NULL)
{
if (!SheetHandleRecord(sheet, record)) break;
record=GetBREC();
};
SeekPosition(oldpos);
return 1;
};
ExcelSheet* ExcelBook::GetSheet(void)
{
ExcelSheet* sh=NULL;
int type;
type=SeekBOF();
Version=type;
sh=new ExcelSheet;
if(type)
{
sh->type=type;
sh->position=Position;
sh->name=QString("");
};
if(type==8||type==7)
{
ReadSheet(sh);
};
return sh;
};
void ExcelBook::ParseSheets(void)
{
int BOFs;
ExcelBREC* r;
BOFs=1;
r=GetBREC();
while(BOFs)
{
r=GetBREC();
switch(r->code)
{
case XL_SST:
HandleSST(r);
break;
case XL_TXO:
break;
case XL_NAME:
break;
case XL_ROW:
break;
case XL_FORMAT:
HandleFormat(r);
break;
case XL_XF:
HandleXF(r);
break;
case XL_BOUNDSHEET:
HandleBoundSheet(r);
break;
case XL_EXTSST:
break;
case XL_CONTINUE:
break;
case XL_EOF:
BOFs--;
break;
default:
break;
};
};
};
void ExcelBook::GetSheets(void)
{
ExcelSheet* sheet;
Sheets.resize(0);
sheet=GetSheet();
while (sheet->Cells.count()!= 0 )
{
Sheets.resize(Sheets.count()+1);
Sheets[Sheets.count()-1]=sheet;
sheet->name=*Names[Sheets.count()-1];
sheet=GetSheet();
};
};
bool ExcelBook::ParseBook(char *file)
{
dateformat=QString("");
DetectEndian();
OpenFile(file);
SeekBOF();
ParseSheets();
GetSheets();
return true;
};
QString ExcelBook::GetASCII(char* inbytes, int pos, int chars)
{
int i;
QString outstr="";
for (i = 0; i < chars; i++)
{
outstr.append(inbytes[i+pos]);
};
return outstr;
};
QString ExcelBook::GetUnicode(char * inbytes, int pos, int chars)
{
QString outstr="";
int i;
int rc;
for (i=0; i<chars*2; i++)
{
rc=Integer2Byte(inbytes[i+pos],inbytes[i+pos+1]);
outstr.append(QChar(rc));
i++;
};
return outstr;
};
void ExcelBook::HandleBoundSheet(ExcelBREC* rec)
{
char* data;
int type;
int visibility;
int length;
int pos;
QString name;
pos = 8;
data = GetDataOfBREC(rec);
type = data[4];
visibility = data[5];
length = data[6];
if(data[7]==0)
{
//ascii
name=GetASCII(data,pos,length);
- }else
+ }
+ else
{
name=GetUnicode(data,pos,length);
};
Names.resize(Names.count()+1);
Names[Names.count()-1]=new QString(name);
};
void ExcelBook::HandleName(ExcelSheet* sheet, ExcelBREC* rec)
{
char* data;
QString name;
int length;
int pos;
pos = 15;
data = GetDataOfBREC(rec);
length = data[3];
name = GetASCII(data,pos,length);
};
ExcelFormat* ExcelBook::GetFormatting(int xf)
{
int i;
ExcelFormat* rec;
rec=new ExcelFormat();
for (i = 0; formatter[i].code != 0; i++)
{
if (xf == formatter[i].code) break;
};
if (formatter[i].format ==NULL) return NULL;
rec->code = xf;
rec->type = formatter[i].type;
rec->format = formatter[i].format;
return rec;
};
void ExcelBook::HandleSetOfSST(ExcelBREC* rec/*, SSTList* cont*/, char* bytes)
{
QString str=QString("");
char* data;
int chars, pos, options, i;
int richstring, fareaststring, runlength=0;
int richruns=0,fareastsize=0;
int totalstrings;
int uniquestrings;
data = GetDataOfBREC(rec);
totalstrings = Integer4Byte(data[0], data[1], data[2], data[3]);
uniquestrings = Integer4Byte(data[4], data[5], data[6], data[7]);
pos = 8;
for (i = 0; i < uniquestrings; i++)
{
richruns=0; fareastsize=0;
chars = Integer2Byte(data[pos], data[pos+1]);
pos += 2;
options = data[pos];
pos++;
fareaststring = ((options & 0x04) != 0);
richstring = ((options & 0x08) != 0);
if(richstring)
{
richruns= Integer2Byte(data[pos],data[pos+1]);
pos+=2;
};
if(fareaststring)
{
fareastsize=Integer4Byte(data[pos], data[pos+1], data[pos+2], data[pos+3]);
pos+=4;
};
if ((options & 0x01) == 0) //8 bit chars
{
/* ascii */
str = GetASCII(bytes,pos,chars);
pos=pos+chars;
if(str[0]=='=') str[0]=' ';
}else //16 bit chars
{
/* unicode */
str = GetUnicode(bytes,pos,chars);
pos=pos+chars*2;
};
// HERE TO PUT richformat handling
if (richstring)
{
pos += 4 * richruns;
};
if (fareaststring)
{
pos += fareastsize;
};
//printf("String=%s, length=%d first=0x%x\r\n",str.ascii(),str.length(),str[0].unicode());
SharedStrings.resize(SharedStrings.count()+1);
SharedStrings[SharedStrings.count()-1]=new QString(str);
}
};
char* ExcelBook::MergeBytesFromSSTs(ExcelBREC* rec,SSTList* cont)
{
int i, pos;
int length;
char* data;
char* bytes;
length = rec->length;
for (i = 0; i < (int) cont->rec.count(); i++)
{
length += cont->rec[i]->length;
}
bytes = GetDataOfBREC(rec);
pos = rec->length;
for (i = 0; i < (int) cont->rec.count(); i++)
{
data = GetDataOfBREC(cont->rec[i]);
*bytes += pos;
bytes = data;
pos += cont->rec[i]->length;
}
return bytes;
};
void ExcelBook::HandleSST(ExcelBREC* rec)
{
char* bytes;
SSTList* cont;
cont= new SSTList;
ExcelBREC* nr;
nr = PeekBREC();
while (nr->code == XL_CONTINUE)
{
cont->rec.resize(cont->rec.count()+1);
cont->rec[cont->rec.count()-1]=GetBREC();
nr = PeekBREC();
}
bytes = MergeBytesFromSSTs(rec,cont);
HandleSetOfSST(rec, bytes);
for(int w1=0;w1<(int)cont->rec.count();w1++)
{
if(cont->rec[w1]!=NULL) {delete cont->rec[w1];cont->rec[w1]=NULL;};
};
cont->rec.resize(0);
};
void ExcelBook::HandleLabelSST(ExcelSheet* sheet, ExcelBREC* rec)
{
int index, row, col;
char* data;
data = GetDataOfBREC(rec);
index = Integer4Byte(data[6], data[7], data[8], data[9]);
row = Integer2Byte(data[0], data[1]);
col = Integer2Byte(data[2], data[3]);
sheet->Set(row,col, CellLabel(row, col, *GetString(index)));
};
ExcelCell* ExcelBook::CellLabel(int row, int col, QString str)
{
ExcelCell* c;
c= new ExcelCell;
c->row = row;
c->col = col;
c->type = CELL_LABEL;
c->valuec = str;
return c;
};
ExcelCell* ExcelBook::CellNumber(int row, int col, int index, double d)
{
ExcelCell* c;
c=new ExcelCell;
c->row = row;
c->col = col;
c->xfindex = index;
c->type = CELL_NUMBER;
c->valued = d;
return c;
};
QString* ExcelBook::CellDataString(ExcelSheet* sh, int row, int col)
{
time_t date;
struct tm *tmptr;
ExcelCell* c;
char str[128];
QString format;
int precision;
int utcOffsetDays = 25569;
int sInADay = 24 * 60 * 60;
c = sh->Get(row,col);
if (c == NULL) return new QString("");
switch (c->type)
{
case CELL_LABEL:
return new QString(c->valuec);
case CELL_NUMBER:
if (XFRecords[c->xfindex]->type == DATEFORMAT)
{
format = XFRecords[c->xfindex]->format;
date = (time_t) ((c->valued - utcOffsetDays) * sInADay);
tmptr = gmtime(&date);
if (dateformat)
{
strftime(str,1024,dateformat.ascii(),tmptr);
- } else
+ }
+ else
{
strftime(str,1024,format.ascii(),tmptr);
};
- } else
+ }
+ else
if (XFRecords[c->xfindex]->type == NUMBERFORMAT)
{
format = XFRecords[c->xfindex]->format;
//sprintf(str,format.ascii(),c->valued);
// the real format is ignored...
// because there is more work to be done in the field
precision = CellGetPrecision(c->valued);
sprintf(str,"%.*f",precision,c->valued);
- }else
+ }
+ else
{
precision = CellGetPrecision(c->valued);
sprintf(str,"%.*f",precision,c->valued);
};
break;
case CELL_DATE:
break;
case CELL_BOOLEAN:
break;
case CELL_ERROR:
break;
}
return new QString(str);
};
int ExcelBook::CellGetPrecision(double d)
{
double t;
int i,x;
int count;
if (d < 0) d *= -1;
i = (int)d;
t = d - (double)i;
if (t <= 0)
{
return 0;
};
count = 0;
for (x = 6; x > 1; x--)
{
i = (int)d;
t = d - (double)i;
t *= pow(10,x - 2);
i = (int)t;
t = t - (double)i;
t *= 10;
i = (int)t;
if (i > 0) break;
count++;
};
return (5 - count);
};
void ExcelBook::CellSetDateFormat(char *d)
{
dateformat = QString(d);
};
void ExcelBook::HandleMulrk(ExcelSheet* sheet, ExcelBREC* record)
{
struct mulrk mulrk;
char* data;
ExcelCell* cell;
int len;
int i;
len = record->length;
data = GetDataOfBREC(record);
mulrk.row = Integer2Byte(data[0],data[1]);
mulrk.first = Integer2Byte(data[2],data[3]);
mulrk.last = Integer2Byte(data[len - 2],data[len - 1]);
mulrk.numrks = mulrk.last - mulrk.first + 1;
MulrkRead(&mulrk, data);
for (i = 0; i < mulrk.numrks; i++)
{
cell = CellNumber(mulrk.row, mulrk.first + i, mulrk.xfindices[i], mulrk.rkdbls[i]);
sheet->Set(mulrk.row,mulrk.first+ i, cell);
//printf("handleMULRK:row=%d,col=%d,val=%f\r\n",mulrk.row,mulrk.first+i,mulrk.rkdbls[i]);
}
//delete(mulrk.xfindices);
//delete(mulrk.rkdbls);
};
void ExcelBook::MulrkRead(struct mulrk *mulrk, char* data)
{
double d;
int i;
int pos;
pos = 4;
mulrk->xfindices.resize(mulrk->numrks);
mulrk->rkdbls.resize(mulrk->numrks);
for (i = 0; i < mulrk->numrks; i++)
{
mulrk->xfindices[i] = Integer2Byte(data[pos], data[pos+1]);
d=Double4Byte(data[pos+2], data[pos+3], data[pos+4], data[pos+5]);
//printf("double:%f\r\n",d);
mulrk->rkdbls[i] = d;
pos += 6;
}
};
void ExcelBook::HandleNumber(ExcelSheet* sheet, ExcelBREC* record)
{
int xfindex, row, col;
char* data;
double d;
data = GetDataOfBREC(record);
row = Integer2Byte(data[0], data[1]);
col = Integer2Byte(data[2], data[3]);
xfindex = Integer2Byte(data[4], data[5]);
#if defined(__arm__) && !defined(__vfp__)
d=Double8Byte(data[10], data[11], data[12], data[13],data[6], data[7], data[8], data[9]);
#else
d=Double8Byte(data[6], data[7], data[8], data[9],data[10], data[11], data[12], data[13]);
#endif
//even if ARM is little endian... doubles are been placed as bigendian words.
//thanks pb_ for that. :)
sheet->Set(row,col, CellNumber(row,col,xfindex,d));
//printf("handleNumber:row=%d,col=%d,val=%f\r\n",row,col,d);
};
ExcelFormat::ExcelFormat()
{
code=0;type=0;format="";
};
ExcelFormat::ExcelFormat(int c,int t, QString s)
{
code=c;type=t;format=s;
};
void ExcelBook::HandleFormat(ExcelBREC* rec)
{
ExcelFormat* xfrec;
char* data;
int format;
data = GetDataOfBREC(rec);
format = Integer2Byte(data[2],data[3]);
xfrec = GetFormatting(format);
/*int idx;
idx=XFRecords.count()-1;
XFRecords[idx]->code=xfrec->code;
XFRecords[idx]->type=xfrec->type;
XFRecords[idx]->format="manos";
//XFRecords[XFRecords.count()-1]=xfrec;
printf("6\r\n");*/
};
void ExcelBook::HandleXF(ExcelBREC* rec)
{
ExcelFormat* xfrec;
char* data;
int format;
data = GetDataOfBREC(rec);
format = Integer2Byte(data[2],data[3]);
xfrec = GetFormatting(format);
XFRecords.resize(XFRecords.count()+1);
XFRecords[XFRecords.count()-1]=xfrec;
};
void ExcelBook::HandleRK(ExcelSheet* sheet, ExcelBREC* record)
{
int xfindex, row, col;
char* data;
double d;
data = GetDataOfBREC(record);
row = Integer2Byte(data[0], data[1]);
col = Integer2Byte(data[2], data[3]);
xfindex = Integer2Byte(data[4], data[5]);
d=Double4Byte(data[6], data[7], data[8], data[9]);
sheet->Set(row,col,CellNumber(row,col,xfindex,d));
//printf("handleRK:row=%d,col=%d,val=%f\r\n",row,col,d);
};
void ExcelBook::HandleFormula(ExcelSheet* sheet, ExcelBREC* record)
{
int xfindex, row, col;
char* data;
double d;
data = GetDataOfBREC(record);
row = Integer2Byte(data[0], data[1]);
col = Integer2Byte(data[2], data[3]);
if (data[6] == 0 && data[12] == -1 && data[13] == -1)
{
// string
- } else
+ }
+ else
if (data[6] == 1 && data[12] == -1 && data[13] == -1)
{
// boolean
- } else
+ }
+ else
if ( data[6] == 2 && data[12] == -1 && data[13] == -1)
{
// error
}
else
{
// number
xfindex = Integer2Byte(data[4], data[5]);
d=Double8Byte(data[6], data[7], data[8], data[9],data[10], data[11], data[12], data[13]);
QString s1;
int sz;
sz=Integer2Byte(data[20],data[21]);// size of the formula
char* formuladata;
formuladata=new char[sz];
for(int w1=0;w1<sz;w1++)
{
formuladata[w1]=data[22+w1];
};
//22 is the first 0 idx of formula data
s1="="+GetFormula(row,col,sheet,formuladata,sz);
//printf("GetFormula:Formula=%s\r\n",s1.ascii());
sheet->Set(row,col,CellLabel(row,col,s1));
}
};
QString ExcelBook::GetFormula(int row, int col, ExcelSheet* sheet, char* data, int sz)
{
int length=sz;
printf("{FormulaParser}\r\n");
printf("row=%d, col=%d, length=%d\r\n",row,col,length);
int idx=0;
int w1,w2,w3,w4;
double d1;
int token;
QString s1;
QList <QString> operands;
operands.setAutoDelete(TRUE);
QString formula;
operands.clear();
while( idx<length )
{
token= data[idx]; idx++;
switch(token)
{
case 0x1E: //prtInt
w1=Integer2Byte(data[idx],data[idx+1]);
idx=idx+2;
operands.prepend(new QString(QString::number(w1)));
printf(" token:ptgInt,num=%d\r\n",w1);
break;
case 0x1F: //ptgNumber
#if defined(__arm__) && !defined(__vfp__)
d1=Double8Byte(data[idx+4],data[idx+5],data[idx+6],data[idx+7]
,data[idx],data[idx+1],data[idx+2],data[idx+3]);
#else
d1=Double8Byte(data[idx],data[idx+1],data[idx+2],data[idx+3]
,data[idx+4],data[idx+5],data[idx+6],data[idx+7]);
#endif
idx=idx+8;
operands.prepend(new QString(QString::number(d1)));
printf(" token:ptgNumber,num=%f\r\n",d1);
break;
case 0x17: //ptgStr
if(Version==8)
{
//unicode string
//w1=Integer2Byte(data[idx],data[idx+1]);idx+=2;
w1=data[idx];idx++;
printf("len=%d\r\n",w1);
int richruns=0; int fareastsize=0;
int richstring,fareaststring;
int options = data[idx];idx++;
fareaststring = ((options & 0x04) != 0);
richstring = ((options & 0x08) != 0);
if(richstring)
{
//containts rich string formatting.
printf("STRING:richstring\r\n");
richruns= Integer2Byte(data[idx],data[idx+1]);
printf("richruns:%d\r\n",richruns);
idx+=2;
};
if(fareaststring)
{
//contains far east formatting
printf("STRING:fareast!\r\n");
fareastsize=Integer4Byte(data[idx], data[idx+1],
data[idx+2], data[idx+3]);
printf("fareastsize=%d",fareastsize);
idx+=4;
};
if ((options & 0x01) == 0) //8 bit chars
{
/* ascii */
s1 = GetASCII(data,idx,w1);
idx=idx+w1;
printf("STRING:ASCII=%s\r\n",s1.ascii());
}else //16 bit chars
{
/* unicode */
s1 = GetUnicode(data,idx,w1);
idx=idx+w1*2;
printf("STRING:unicode=%s\r\n",s1.ascii());
};
// HERE TO PUT richformat handling
if (richstring)
{
idx += 4 * richruns;
};
if (fareaststring)
{
idx += fareastsize;
};
s1=QString("""")+s1+QString("""");
operands.prepend(new QString(s1));
- }else
+ }
+ else
{
w1=data[idx];idx++;
s1=GetASCII(data,idx,w1);
s1=QString("""")+s1+QString("""");
idx=idx+w1;
operands.prepend(new QString(s1));
};
printf(" token:ptgStr,num=%d\r\n",w1);
break;
case 0x25:
case 0x45:
case 0x65: // ptgArea
if(Version==8)
{
w1=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//row1
w2=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//row2
w3=Integer2Byte(data[idx],data[idx+1]) & 0x00FF;idx=idx+2;//col1
w4=Integer2Byte(data[idx],data[idx+1]) & 0x00FF;idx=idx+2;//col2
- }else
+ }
+ else
{
w1=Integer2Byte(data[idx],data[idx+1]) & 0x3FFF;idx=idx+2;//row1
w2=Integer2Byte(data[idx],data[idx+1]) & 0x3FFF;idx=idx+2;//row2
w3=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//col1
w4=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//col2
};
//ignores relative or absolute refs
s1=FindCellName(w1,w3)+":"+FindCellName(w2,w4);
printf(" token:ptgArea,ref=%s\r\n",s1.ascii());
operands.prepend(new QString(s1));
break;
case 0x24:
case 0x44:
case 0x64://ptgRef
if(Version==8)
{
w1=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//row
w2=Integer2Byte(data[idx],data[idx+1]) & 0x00FF;idx=idx+2;//col
- }else
+ }
+ else
{
w1=Integer2Byte(data[idx],data[idx+1]) & 0x3FFF;idx=idx+2;//row
w2=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;//col
};
s1=FindCellName(w1,w2);
printf("token:ptgRef,ref=%s\r\n",s1.ascii());
operands.prepend(new QString(s1));
break;
case 0x1D: // ptgBool
w1=data[idx];idx++;
printf("token:ptgBool,val=%d\r\n",w1);
operands.prepend(new QString(QString::number(w1)));
break;
case 0x16://ptg MissArg
printf("token:ptgMissArg, val=' '\r\n");
operands.prepend(new QString("0"));
break;
case 0x12://ptgUplus==
printf("token:ptgUplus\r\n");
s1=QString("+")+operands.first()->ascii();
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x13://ptgUminus
printf("token:ptgUminus\r\n");
s1=QString("-")+operands.first()->ascii();
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x03://ptgAdd
printf("token:ptgAdd\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("+")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x04://ptgSub
printf("token:ptgSub\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("-")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x05://ptgMul
printf("token:ptgMul\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("*")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x06://ptgDiv
printf("token:ptgDiv\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("/")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x07://ptgPOWER
printf("token:ptgPow\r\n");
operands.first();
s1=QString("POWER(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x08://ptgConcat
printf("token:ptgConcat\r\n");
operands.first();
s1=QString("CONCATENATE(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x15://ptgParenthesis
printf("token:ptgParenthesis\r\n");
s1=QString("(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x14://ptgPercent
printf("token:ptgPercent\r\n");
s1=operands.first()->ascii()+QString("*0.01");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x9://ptgLessThan
printf("token:ptgLESS\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("<")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xa://ptgLessEqual
printf("token:ptgLESS_EQUAL\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("<=")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xb://ptgEQUAL
printf("token:ptgEQUAL\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("==")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xc://ptgGREATER_EQUAL
printf("token:ptgGREAT_EQUAL\r\n");
operands.first();
s1=operands.next()->ascii()
+QString(">=")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xd://ptgGREAT_THAN
printf("token:ptgGREAT_THAN\r\n");
operands.first();
s1=operands.next()->ascii()
+QString(">")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe://ptgNOT_EQUAL
printf("token:ptgNOTequal\r\n");
operands.first();
s1=operands.next()->ascii()
+QString("!=")+operands.first()->ascii();
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x19://attribute can be Sum,If,Choose
w3=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;
idx++;
printf("token:ATTRIBUTE:0x%x\r\n",w3);
for(w4=idx;w4<length;w4++)
printf("0x%x, ",data[w4]);
if(w3&0x01)//choose
{
printf("token:CHOOSE\r\n");
}
else if(w3&0x02)//if
{
printf("token:IF\r\n");
}
else if(w3&0x10)//sum
{
printf("token:SUM\r\n");
};
break;
case 0x21:
case 0x22:
case 0x42:
case 0x62:
case 0x41:
case 0x61://ptgFunction
printf("token:ptgFunction\r\n");
if(token==0x22||token==0x42||token==0x62)
{
w2=(int)data[idx];idx++;
w1=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;
- }else
+ }
+ else
{
w1=Integer2Byte(data[idx],data[idx+1]);idx=idx+2;
};
switch(w1)
{
case 0xf://SIN
s1=QString("SIN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x10://COS
s1=QString("COS(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x11://tan
s1=QString("TAN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x62://asin
s1=QString("ASIN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x63://ACOS
s1=QString("ACOS(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x12://ATAN
s1=QString("ATAN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe5://SINH
s1=QString("SINH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe6://COSH
s1=QString("COSH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe7://TANH
s1=QString("TANH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe8://ASINH
s1=QString("ASINH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xe9://ACOSH
s1=QString("ACOSH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xea://ATANH
s1=QString("ATANH(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x13://pi
s1="PI()";
operands.prepend(new QString(s1));
break;
case 0x14://sqrt
s1=QString("SQRT(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x15://exp
s1=QString("EXP(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x16://LN
s1=QString("LN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x17://LOG10
s1=QString("LOG10(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x18://ABS
s1=QString("ABS(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x19://int
s1=QString("INT(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x1a://sign
s1=QString("SIGN(")+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x1b://round
operands.first();
s1=QString("ROUND(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()
+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x1d://index
operands.first();
s1=QString("INDEX(")+operands.next()->ascii()
+QString(",")
+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x1: // if ATTRIBUTE
operands.first();operands.next();
s1=QString("IF(")+operands.next()->ascii()+QString(",");
operands.first();
s1=s1+operands.next()->ascii()+QString(",");
s1=s1+operands.first()->ascii()+QString(")");
operands.removeFirst();
operands.removeFirst();
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x81://isblank
s1=QString("ISBLANK(")+operands.first()->ascii()
+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x80://isnumber
s1=QString("ISNUMBER(")+operands.first()->ascii()
+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x120://ceiling
operands.first();
s1=QString("CEILING(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()
+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x11d://floor
operands.first();
s1=QString("FLOOR(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()
+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x157://degrees
s1=QString("DEGREES(")+operands.first()->ascii()
+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x156://radians
s1=QString("RADIANS(")+operands.first()->ascii()
+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0xb8://fact
s1=QString("FACT(")+operands.first()->ascii()
+QString(")");
operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x27://MOD
operands.first();
s1=QString("MOD(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()
+QString(")");
operands.removeFirst();operands.removeFirst();
operands.prepend(new QString(s1));
break;
case 0x151://power
operands.first();
s1=QString("POWER(")+operands.next()->ascii()
+QString(",")+operands.first()->ascii()
+QString(")");
operands.removeFirst();operands.removeFirst();
diff --git a/noncore/apps/opie-sheet/Excel.h b/noncore/apps/opie-sheet/Excel.h
index 0a581cf..51ccf5c 100644
--- a/noncore/apps/opie-sheet/Excel.h
+++ b/noncore/apps/opie-sheet/Excel.h
@@ -1,205 +1,228 @@
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
+
+/* QT */
+#include <qstring.h>
+#include <qarray.h>
+#include <qlist.h>
+/* STD */
#include <stdio.h>
#include <stdlib.h>
#include <math.h>
#include <time.h>
#include <sys/types.h>
#include <strings.h>
-#include <qstring.h>
-#include <qarray.h>
-#include <qlist.h>
#define DATEFORMAT 0x1
#define NUMBERFORMAT 0x2
#define BIFF8 0x600
#define BIFF7 0x500
#define WBKGLOBAL 0x5
#define WRKSHEET 0x10
#define XL_ARRAY 0x221
#define XL_BOUNDSHEET 0x85
#define XL_BOF 0x809
#define XL_BOOLERR 0x205
#define XL_CONTINUE 0x3c
#define XL_DIMENSION 0x200
#define XL_EOF 0x0a
#define XL_EXTSST 0xff
#define XL_FORMULA 0x406
#define XL_FORMULA2 0x6
#define XL_FORMAT 0x41e
#define XL_INDEX 0x20b
#define XL_LABEL 0x204
#define XL_LABELSST 0xfd
#define XL_MULRK 0xbd
#define XL_NAME 0x18
#define XL_NOTE 0x1c
#define XL_NUMBER 0x203
#define XL_RK 0x7e
#define XL_RK2 0x27e
#define XL_ROW 0x208
#define XL_SST 0xfc
#define XL_STRING 0x207
#define XL_TXO 0x1b6
#define XL_XF 0xe0
#define XL_UNKNOWN 0xffff
#define CELL_LABEL 0x2
#define CELL_NUMBER 0x3
#define CELL_DATE 0x4
#define CELL_BOOLEAN 0x5
#define CELL_ERROR 0x6
class ExcelFormat
{
public:
int code;
int type;
QString format;
ExcelFormat();
ExcelFormat(int c,int t, QString s);
};
struct xfrecord
{
int code;
int type;
QString format;
};
class ExcelCell
{
public:
int type;
int row,col;
int xfindex; //xf format index of cell
int valuei;
double valued;
QString valuec;
};
class ExcelBREC
{
public:
int code;
int length;
int position;
char* data;
};
class SSTList
{
public:
QArray <ExcelBREC*> rec;
};
class ExcelSheet
{
public:
QString name;
ExcelBREC BOFRecord;
int position;
int type;
int rows;
int cols;
int cellsize,rowalloc,cellalloc;
QArray <ExcelCell*> Cells;
bool InitCells(void); // true if ok
ExcelCell* Get(int row, int col);
void Set(int row, int col, ExcelCell* cell);
};
-struct mulrk {
+struct mulrk
+{
int row;
int first;
int last;
int numrks;
QArray<int> rknumbers;
QArray<double> rkdbls;
QArray<int> xfindices;
};
-
-
-
class ExcelBook
{
public:
FILE *File;
int Position;
//int stringcount;
QArray <QString*> SharedStrings;
//int xfcount;
QArray <ExcelFormat*> XFRecords;
//int Sheetcount;
QArray <ExcelSheet*> Sheets;
//int name count;
QArray <QString*> Names;
QString dateformat;
int Version;
int endian;
int Integer2Byte(int b1, int b2 );
int Integer4Byte(int b1, int b2, int b3, int b4 );
int Integer2ByteFile(FILE *f);
float Float4Byte(int b1, int b2, int b3, int b4);
double Double4Byte(int b1, int b2, int b3, int b4);
double Double8Byte(int b1, int b2, int b3, int b4, int b5, int b6, int b7, int b8);
void DetectEndian(void);
bool OpenFile(char *Filename); // true if ok
bool CloseFile(void); // true if ok
void SeekPosition(int pos); // go to Pos
void SeekSkip(int pos); // skips pos bytes.
int FileEOF(void); //returns -1 if EOF else 0
int Get2Bytes(void); //gets an int from the file
char* Read(int pos, int length);
QString ReadUnicodeChar(int pos, int length);
QString* GetString(int num); //gets the num string from SharedStrings;
int SeekBOF(void);
ExcelBREC* GetBREC(void);
ExcelBREC* PeekBREC(void);
char* GetDataOfBREC(ExcelBREC* record);
void ConvertCharToArray(ExcelBREC* record, char* chars, int length);
int SheetHandleRecord(ExcelSheet* sheet, ExcelBREC* record);
int ReadSheet(ExcelSheet* sheet); //read the sheet sheet*
ExcelSheet* GetSheet(void);
void ParseSheets(void);
void GetSheets(void);
bool ParseBook(char *file); // THIS IS THE MAIN PARSE FUNCTION of file
QString GetASCII(char* inbytes, int pos, int chars);
QString GetUnicode(char * inbytes, int pos, int chars);
void HandleBoundSheet( ExcelBREC* rec);
void HandleName(ExcelSheet* sheet, ExcelBREC* rec);
ExcelFormat* GetFormatting(int xf);
void HandleSetOfSST(ExcelBREC* rec/*, SSTList* cont*/, char* bytes);
char* MergeBytesFromSSTs(ExcelBREC* rec,SSTList* cont);
void HandleSST(ExcelBREC* rec);
void HandleLabelSST(ExcelSheet* sheet, ExcelBREC* rec);
ExcelCell* CellLabel(int row, int col, QString str);
ExcelCell* CellNumber(int row, int col, int index, double d);
QString* CellDataString(ExcelSheet* sh, int row, int col);
int CellGetPrecision(double d);
void CellSetDateFormat(char *d);
void HandleMulrk(ExcelSheet* sheet, ExcelBREC* record);
void MulrkRead(struct mulrk *mulrk, char* data);
void HandleNumber(ExcelSheet* sheet, ExcelBREC* record);
void HandleFormat(ExcelBREC* rec);
void HandleXF(ExcelBREC* rec);
void HandleRK(ExcelSheet* sheet, ExcelBREC* record);
void HandleFormula(ExcelSheet* sheet, ExcelBREC* record);
QString GetFormula(int row, int col, ExcelSheet* sheet, char* data, int sz);
QString FindCellName(int row, int col);
-
-
-
-
-
};
diff --git a/noncore/apps/opie-sheet/cellformat.cpp b/noncore/apps/opie-sheet/cellformat.cpp
index 342ebe9..602d20d 100644
--- a/noncore/apps/opie-sheet/cellformat.cpp
+++ b/noncore/apps/opie-sheet/cellformat.cpp
@@ -1,626 +1,644 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "cellformat.h"
+/* QT */
#include <qlistbox.h>
#include <qlabel.h>
#define COMBO_WIDTHS 155
#define COMBO_HEIGHTS 21
#define COLOR_COUNT 17
#define STYLE_COUNT 14
#define HALIGN_COUNT 3
#define VALIGN_COUNT 3
QColor qtColors[COLOR_COUNT]={Qt::black,Qt::white, Qt::darkGray,
Qt::gray, Qt::lightGray, Qt::red,
Qt::green, Qt::blue, Qt::cyan,
Qt::magenta, Qt::yellow,
Qt::darkRed, Qt::darkGreen,
Qt::darkBlue, Qt::darkCyan,
Qt::darkMagenta, Qt::darkYellow};
Qt::BrushStyle brushStyles[STYLE_COUNT]={Qt::SolidPattern,
Qt::Dense1Pattern, Qt::Dense2Pattern,
Qt::Dense3Pattern, Qt::Dense4Pattern,
Qt::Dense5Pattern, Qt::Dense6Pattern,
Qt::Dense7Pattern, Qt::HorPattern,
Qt::VerPattern, Qt::CrossPattern,
Qt::BDiagPattern, Qt::FDiagPattern,
Qt::DiagCrossPattern};
QString namesHAlign[HALIGN_COUNT]={"Left", "Right", "Center"};
QString namesVAlign[VALIGN_COUNT]={"Top", "Bottom", "Center"};
Qt::AlignmentFlags flagsHAlign[HALIGN_COUNT]={Qt::AlignLeft,
Qt::AlignRight,
Qt::AlignHCenter};
Qt::AlignmentFlags flagsVAlign[VALIGN_COUNT]={Qt::AlignTop,
Qt::AlignBottom,
Qt::AlignVCenter};
CellFormat::CellFormat(QWidget *parent)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetBorders=new QWidget(tabs);
widgetBackground=new QWidget(tabs);
widgetFont=new QWidget(tabs);
widgetAlignment=new QWidget(tabs);
tabs->addTab(widgetBorders, tr("&Borders"));
tabs->addTab(widgetBackground, tr("Back&ground"));
tabs->addTab(widgetFont, tr("&Font"));
tabs->addTab(widgetAlignment, tr("&Alignment"));
fontDB.loadRenderers();
changedFont=changedAlign=changedBrush=FALSE;
// Borders tab
borderEditor=new BorderEditor(widgetBorders);
borderEditor->setGeometry(10, 10, 215, 145);
connect(borderEditor, SIGNAL(clicked(BorderEditor::BorderArea)),
this, SLOT(borderClicked(BorderEditor::BorderArea)));
comboBordersWidth=createCombo(COMBO_WIDTH, widgetBorders, tr("&Width:"), 165);
comboBordersColor=createCombo(COMBO_COLOR, widgetBorders, tr("&Color:"), 165+(COMBO_HEIGHTS+10));
buttonBordersDefaults=new QPushButton(tr("&Default Borders"), widgetBorders);
buttonBordersDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10),
110, COMBO_HEIGHTS);
connect(buttonBordersDefaults, SIGNAL(clicked()),
this, SLOT(slotBordersDefaults()));
// Background tab
frameBackground=new QFrame(widgetBackground);
frameBackground->setGeometry(10, 10, 215, 145);
frameBackground->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboBackgroundStyle=createCombo(COMBO_STYLE, widgetBackground, tr("&Style:"), 165);
connect(comboBackgroundStyle, SIGNAL(activated(int)), this, SLOT(backgroundClicked(int)));
comboBackgroundColor=createCombo(COMBO_COLOR, widgetBackground, tr("&Color:"), 165+(COMBO_HEIGHTS+10));
connect(comboBackgroundColor, SIGNAL(activated(int)), this, SLOT(backgroundClicked(int)));
buttonBackgroundDefaults=new QPushButton(tr("&Default Background"), widgetBackground);
buttonBackgroundDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonBackgroundDefaults, SIGNAL(clicked()), this, SLOT(slotBackgroundDefaults()));
// Font tab
frameFont=new QFrame(widgetFont);
frameFont->setGeometry(10, 10, 215, 125);
frameFont->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboFontFamily=createCombo(COMBO_FONT, widgetFont, tr("&Font:"), 145);
connect(comboFontFamily, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
comboFontSize=createCombo(COMBO_SIZE, widgetFont, tr("&Size:"), 145+(COMBO_HEIGHTS+10));
connect(comboFontSize, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
comboFontColor=createCombo(COMBO_COLOR, widgetFont, tr("&Color:"), 145+2*(COMBO_HEIGHTS+10));
connect(comboFontColor, SIGNAL(activated(int)), this, SLOT(fontClicked(int)));
checkFontBold=new QCheckBox(tr("&Bold"), widgetFont);
checkFontBold->setGeometry(10, 145+3*(COMBO_HEIGHTS+10), 40, COMBO_HEIGHTS);
connect(checkFontBold, SIGNAL(toggled(bool)), this, SLOT(fontClicked(bool)));
checkFontItalic=new QCheckBox(tr("&Italic"), widgetFont);
checkFontItalic->setGeometry(60, 145+3*(COMBO_HEIGHTS+10), 40, COMBO_HEIGHTS);
connect(checkFontItalic, SIGNAL(toggled(bool)), this, SLOT(fontClicked(bool)));
buttonFontDefaults=new QPushButton(tr("&Default Font"), widgetFont);
buttonFontDefaults->setGeometry(115, 145+3*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonFontDefaults, SIGNAL(clicked()), this, SLOT(slotFontDefaults()));
// Alignment tab
frameAlignment=new QFrame(widgetAlignment);
frameAlignment->setGeometry(10, 10, 215, 145);
frameAlignment->setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
comboAlignmentVertical=createCombo(COMBO_VALIGN, widgetAlignment, tr("&Vertical:"), 165);
connect(comboAlignmentVertical, SIGNAL(activated(int)), this, SLOT(alignClicked(int)));
comboAlignmentHorizontal=createCombo(COMBO_HALIGN, widgetAlignment, tr("&Horizontal:"), 165+(COMBO_HEIGHTS+10));
connect(comboAlignmentHorizontal, SIGNAL(activated(int)), this, SLOT(alignClicked(int)));
checkAlignmentWrap=new QCheckBox(tr("&Word Wrap"), widgetAlignment);
checkAlignmentWrap->setGeometry(10, 165+2*(COMBO_HEIGHTS+10), 90, COMBO_HEIGHTS);
connect(checkAlignmentWrap, SIGNAL(toggled(bool)), this, SLOT(alignClicked(bool)));
buttonAlignmentDefaults=new QPushButton(tr("&Default Alignment"), widgetAlignment);
buttonAlignmentDefaults->setGeometry(115, 165+2*(COMBO_HEIGHTS+10), 110, COMBO_HEIGHTS);
connect(buttonAlignmentDefaults, SIGNAL(clicked()), this, SLOT(slotAlignmentDefaults()));
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Format Cells"));
}
CellFormat::~CellFormat()
-{
-}
+{}
int CellFormat::findColorIndex(const QColor &color)
{
for (int i=0; i<COLOR_COUNT; ++i)
if (qtColors[i]==color)
return i;
return 0;
}
int CellFormat::findVAlignIndex(Qt::AlignmentFlags flag)
{
for (int i=0; i<VALIGN_COUNT; ++i)
if (flagsVAlign[i] & flag)
return i;
return 0;
}
int CellFormat::findHAlignIndex(Qt::AlignmentFlags flag)
{
for (int i=0; i<HALIGN_COUNT; ++i)
if (flagsHAlign[i] & flag)
return i;
return 0;
}
int CellFormat::findBrushStyleIndex(Qt::BrushStyle style)
{
for (int i=0; i<STYLE_COUNT; ++i)
if (brushStyles[i]==style)
return i;
return 0;
}
void CellFormat::setBrushBackground(const QBrush &brush)
{
comboBackgroundColor->setCurrentItem(findColorIndex(brush.color()));
comboBackgroundStyle->setCurrentItem(findBrushStyleIndex(brush.style()));
QPixmap pix(frameBackground->contentsRect().width(), frameBackground->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), brush);
frameBackground->setBackgroundPixmap(pix);
brushBackground=brush;
}
void CellFormat::setTextFont(const QFont &font, const QColor &color)
{
comboFontColor->setCurrentItem(findColorIndex(color));
comboFontFamily->setCurrentItem(findComboItemIndex(comboFontFamily, font.family()));
comboFontSize->setCurrentItem(findComboItemIndex(comboFontSize, QString::number(font.pointSize())));
checkFontBold->setChecked(font.weight()==QFont::Bold);
checkFontItalic->setChecked(font.italic());
QPixmap pix(frameFont->contentsRect().width(), frameFont->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), Qt::white);
p.setFont(font);
p.setPen(color);
p.drawText(pix.rect(), Qt::AlignCenter, tr("Opie Sheet"));
frameFont->setBackgroundPixmap(pix);
fontFont=font;
fontColor=color;
}
void CellFormat::setTextAlign(Qt::AlignmentFlags flags)
{
comboAlignmentVertical->setCurrentItem(findVAlignIndex(flags));
comboAlignmentHorizontal->setCurrentItem(findHAlignIndex(flags));
checkAlignmentWrap->setChecked(flags & Qt::WordBreak);
QPixmap pix(frameAlignment->contentsRect().width(), frameAlignment->contentsRect().height());
QPainter p(&pix);
pix.fill();
p.fillRect(pix.rect(), Qt::white);
p.drawText(10, 10, pix.width()-20, pix.height()-20, flags, tr("Opie Sheet"));
frameAlignment->setBackgroundPixmap(pix);
textAlignment=flags;
}
void CellFormat::slotFontDefaults()
{
changedFont=TRUE;
setTextFont(font(), Qt::black);
}
void CellFormat::slotAlignmentDefaults()
{
changedAlign=TRUE;
setTextAlign((Qt::AlignmentFlags)(Qt::AlignLeft | Qt::AlignTop));
}
void CellFormat::slotBackgroundDefaults()
{
changedBrush=TRUE;
setBrushBackground(Qt::white);
}
void CellFormat::slotBordersDefaults()
{
QPen defaultPen(Qt::gray, 1, Qt::SolidLine);
borderEditor->setPen(defaultPen, BorderEditor::Top);
borderEditor->setPen(defaultPen, BorderEditor::Bottom);
borderEditor->setPen(defaultPen, BorderEditor::Left);
borderEditor->setPen(defaultPen, BorderEditor::Right);
borderEditor->setPen(defaultPen, BorderEditor::Vert);
borderEditor->setPen(defaultPen, BorderEditor::Horz);
}
void CellFormat::backgroundClicked(int index)
{
changedBrush=TRUE;
setBrushBackground(QBrush(qtColors[comboBackgroundColor->currentItem()], brushStyles[comboBackgroundStyle->currentItem()]));
}
void CellFormat::fontClicked(bool on)
{
fontClicked(0);
}
void CellFormat::fontClicked(int index)
{
changedFont=TRUE;
setTextFont(QFont(comboFontFamily->currentText(), comboFontSize->currentText().toInt(), checkFontBold->isChecked() ? QFont::Bold : QFont::Normal, checkFontItalic->isChecked(), QFont::AnyCharSet), qtColors[comboFontColor->currentItem()]);
}
void CellFormat::alignClicked(bool on)
{
alignClicked(0);
}
void CellFormat::alignClicked(int index)
{
changedAlign=TRUE;
setTextAlign((Qt::AlignmentFlags)(flagsVAlign[comboAlignmentVertical->currentItem()] | flagsHAlign[comboAlignmentHorizontal->currentItem()] | (checkAlignmentWrap->isChecked() ? Qt::WordBreak : 0)));
}
void CellFormat::createSizeCombo(QComboBox *combo)
{
combo->clear();
QValueList<int> sizes=fontDB.standardSizes();
for (QValueList<int>::ConstIterator i=sizes.begin(); i!=sizes.end(); ++i)
combo->insertItem(QString::number(*i));
}
void CellFormat::borderClicked(BorderEditor::BorderArea area)
{
QPen newPen(qtColors[comboBordersColor->currentItem()], comboBordersWidth->currentItem()+1, Qt::SolidLine);
if (newPen==borderEditor->getPen(area))
borderEditor->setPen(QPen(Qt::gray, 1, Qt::NoPen), area);
else
borderEditor->setPen(newPen, area);
}
int CellFormat::findComboItemIndex(QComboBox *combo, const QString &item)
{
for (int i=0; i<combo->count(); ++i)
if (combo->text(i)==item)
return i;
return 0;
}
QComboBox *CellFormat::createCombo(comboType type, QWidget *parent,
const QString &caption, int y)
{
QComboBox *combo=new QComboBox(FALSE, parent);
combo->setGeometry(70, y, COMBO_WIDTHS, COMBO_HEIGHTS);
combo->setSizeLimit(5);
switch (type)
{
case COMBO_WIDTH: createWidthCombo(combo); break;
case COMBO_STYLE: createStyleCombo(combo); break;
case COMBO_FONT: createFontCombo(combo); break;
case COMBO_SIZE: createSizeCombo(combo); break;
case COMBO_COLOR: createColorCombo(combo); break;
case COMBO_HALIGN: createHAlignCombo(combo); break;
case COMBO_VALIGN: createVAlignCombo(combo); break;
default: break;
}
QLabel *label=new QLabel(combo, caption, parent);
label->setGeometry(10, y, 50, COMBO_HEIGHTS);
return combo;
}
void CellFormat::createHAlignCombo(QComboBox *combo)
{
for (int i=0; i<HALIGN_COUNT; ++i)
combo->insertItem(namesHAlign[i]);
}
void CellFormat::createVAlignCombo(QComboBox *combo)
{
for (int i=0; i<VALIGN_COUNT; ++i)
combo->insertItem(namesVAlign[i]);
}
void CellFormat::createWidthCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=1; i<=6; ++i)
{
pix.fill();
p.setPen(QPen(Qt::black, i, Qt::SolidLine));
p.drawLine(5, COMBO_HEIGHTS/2, width-10, COMBO_HEIGHTS/2);
combo->insertItem(pix);
}
}
void CellFormat::createFontCombo(QComboBox *combo)
{
combo->insertStringList(fontDB.families());
}
void CellFormat::createStyleCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=0; i<STYLE_COUNT; ++i)
{
pix.fill();
p.fillRect(5, 5, width-10, COMBO_HEIGHTS-10, brushStyles[i]);
combo->insertItem(pix);
}
}
void CellFormat::createColorCombo(QComboBox *combo)
{
int width=combo->listBox()->maxItemWidth();
QPixmap pix(width, COMBO_HEIGHTS);
QPainter p(&pix);
for (int i=0; i<COLOR_COUNT; ++i)
{
pix.fill();
p.setPen(QPen(qtColors[i], 3, Qt::SolidLine));
p.drawLine(5, COMBO_HEIGHTS/2, width-10, COMBO_HEIGHTS/2);
combo->insertItem(pix);
}
}
int CellFormat::exec(Sheet *s)
{
sheet=s;
int row1, row2, col1, col2, row, col;
sheet->getSelection(&row1, &col1, &row2, &col2);
QPen penTop=sheet->getPen(row1-1, col1, 0), penBottom=sheet->getPen(row2, col1, 0),
penLeft=sheet->getPen(row1, col1-1, 1), penRight=sheet->getPen(row1, col2, 1),
penVert=sheet->getPen(row1, col1, 1), penHorz=sheet->getPen(row1, col1, 0),
penDefault=borderEditor->getDefaultPen();
for (row=row1+1; row<=row2; ++row)
if (sheet->getPen(row, col1-1, 1)!=penLeft)
{
penLeft=penDefault;
break;
}
for (row=row1+1; row<=row2; ++row)
if (sheet->getPen(row, col2, 1)!=penRight)
{
penRight=penDefault;
break;
}
for (col=col1+1; col<=col2; ++col)
if (sheet->getPen(row1-1, col, 0)!=penTop)
{
penTop=penDefault;
break;
}
for (col=col1+1; col<=col2; ++col)
if (sheet->getPen(row2, col, 0)!=penBottom)
{
penBottom=penDefault;
break;
}
for (row=row1; row<=row2; ++row)
for (col=col1; col<col2; ++col)
if (sheet->getPen(row, col, 1)!=penVert)
{
penVert=penDefault;
break;
}
for (row=row1; row<row2; ++row)
for (col=col1; col<=col2; ++col)
if (sheet->getPen(row, col, 0)!=penHorz)
{
penHorz=penDefault;
break;
}
borderEditor->setPen(penTop, BorderEditor::Top);
borderEditor->setPen(penBottom, BorderEditor::Bottom);
borderEditor->setPen(penLeft, BorderEditor::Left);
borderEditor->setPen(penRight, BorderEditor::Right);
borderEditor->setPen(penVert, BorderEditor::Vert);
borderEditor->setPen(penHorz, BorderEditor::Horz);
setBrushBackground(sheet->getBrush(row1, col1));
setTextFont(sheet->getFont(row1, col1), sheet->getFontColor(row1, col1));
setTextAlign(sheet->getAlignment(row1, col1));
if (QDialog::exec()==QDialog::Accepted)
{
penTop=borderEditor->getPen(BorderEditor::Top);
penBottom=borderEditor->getPen(BorderEditor::Bottom);
penLeft=borderEditor->getPen(BorderEditor::Left);
penRight=borderEditor->getPen(BorderEditor::Right);
penVert=borderEditor->getPen(BorderEditor::Vert);
penHorz=borderEditor->getPen(BorderEditor::Horz);
if (penTop!=penDefault)
for (col=col1; col<=col2; ++col)
sheet->setPen(row1-1, col, 0, penTop);
if (penBottom!=penDefault)
for (col=col1; col<=col2; ++col)
sheet->setPen(row2, col, 0, penBottom);
if (penLeft!=penDefault)
for (row=row1; row<=row2; ++row)
sheet->setPen(row, col1-1, 1, penLeft);
if (penRight!=penDefault)
for (row=row1; row<=row2; ++row)
sheet->setPen(row, col2, 1, penRight);
if (penVert!=penDefault)
for (row=row1; row<=row2; ++row)
for (col=col1; col<col2; ++col)
sheet->setPen(row, col, 1, penVert);
if (penHorz!=penDefault)
for (row=row1; row<row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setPen(row, col, 0, penHorz);
if (changedBrush)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setBrush(row, col, brushBackground);
}
if (changedAlign)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setTextAlign(row, col, textAlignment);
}
if (changedFont)
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
sheet->setTextFont(row, col, fontFont, fontColor);
}
return QDialog::Accepted;
}
return QDialog::Rejected;
}
//
// Border Editor
//
BorderEditor::BorderEditor(QWidget *parent)
:QFrame(parent)
{
setFrameStyle(QFrame::StyledPanel | QFrame::Sunken);
}
BorderEditor::~BorderEditor()
-{
-}
+{}
void BorderEditor::drawContents(QPainter *p)
{
QFrame::drawContents(p);
int x=contentsRect().x(), y=contentsRect().y(), width=contentsRect().width()/3, height=contentsRect().height()/3;
int lineFirstX=x+width/6, lineFirstY=y+height/6, lineLastX=contentsRect().right()-width/6, lineLastY=contentsRect().bottom()-height/6;
p->fillRect(contentsRect(), Qt::white);
p->fillRect(x+width/3, y+height/3, width, height, Qt::gray);
p->fillRect(x+(5*width/3), y+height/3, width, height, Qt::gray);
p->fillRect(x+width/3, y+(5*height)/3, width, height, Qt::gray);
p->fillRect(x+(5*width)/3, y+(5*height)/3, width, height, Qt::gray);
if (penTop.width()>0)
{
p->setPen(penTop);
p->drawLine(lineFirstX, lineFirstY, lineLastX, lineFirstY);
}
if (penBottom.width()>0)
{
p->setPen(penBottom);
p->drawLine(lineFirstX, lineLastY, lineLastX, lineLastY);
}
if (penHorz.width()>0)
{
p->setPen(penHorz);
p->drawLine(lineFirstX, y+contentsRect().height()/2, lineLastX, y+contentsRect().height()/2);
}
if (penLeft.width()>0)
{
p->setPen(penLeft);
p->drawLine(lineFirstX, lineFirstY, lineFirstX, lineLastY);
}
if (penRight.width()>0)
{
p->setPen(penRight);
p->drawLine(lineLastX, lineFirstY, lineLastX, lineLastY);
}
if (penVert.width()>0)
{
p->setPen(penVert);
p->drawLine(x+contentsRect().width()/2, lineFirstY, x+contentsRect().width()/2, lineLastY);
}
}
void BorderEditor::setPen(const QPen &pen, BorderArea area)
{
switch (area)
{
case Top: penTop=pen; break;
case Bottom: penBottom=pen; break;
case Left: penLeft=pen; break;
case Right: penRight=pen; break;
case Horz: penHorz=pen; break;
case Vert: penVert=pen; break;
};
update();
}
void BorderEditor::mouseReleaseEvent(QMouseEvent *e)
{
QFrame::mouseReleaseEvent(e);
int x=contentsRect().x(), y=contentsRect().y(), width=contentsRect().width()/3, height=contentsRect().height()/3;
BorderArea area=None;
if (e->x()<x+width/3) area=Left;
if (e->x()>x+(8*width)/3) area=Right;
if (e->x()>x+(4*width)/3 && e->x()<x+(5*width)/3) area=Vert;
if (e->y()<y+height/3) area=Top;
if (e->y()>y+(8*height)/3) area=Bottom;
if (e->y()>y+(4*height)/3 && e->y()<y+(5*height)/3) area=Horz;
if (area!=None)
emit clicked(area);
}
QPen BorderEditor::getPen(BorderArea area)
{
switch (area)
{
case Top: return penTop;
case Bottom: return penBottom;
case Left: return penLeft;
case Right: return penRight;
case Horz: return penHorz;
case Vert: return penVert;
};
return getDefaultPen();
}
diff --git a/noncore/apps/opie-sheet/cellformat.h b/noncore/apps/opie-sheet/cellformat.h
index b569b7f..e07af9c 100644
--- a/noncore/apps/opie-sheet/cellformat.h
+++ b/noncore/apps/opie-sheet/cellformat.h
@@ -1,120 +1,142 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef CELLFORMAT_H
#define CELLFORMAT_H
+#include "sheet.h"
+
+/* OPIE */
#include <qpe/fontdatabase.h>
+
+/* QT */
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qcombobox.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
-#include "sheet.h"
-
class BorderEditor: public QFrame
{
Q_OBJECT
// QT objects
QPen penTop, penBottom, penLeft, penRight, penHorz, penVert;
// Private functions
void drawContents(QPainter *p);
// Reimplemented QFrame functions
void mouseReleaseEvent(QMouseEvent *e);
public:
// Definitions
enum BorderArea {None, Top, Bottom, Left, Right, Horz, Vert};
BorderEditor(QWidget *parent=0);
~BorderEditor();
void setPen(const QPen &pen, BorderArea area);
QPen getPen(BorderArea area);
QPen getDefaultPen() { return QPen(Qt::black, 1, Qt::DotLine); }
signals:
void clicked(BorderEditor::BorderArea);
};
class CellFormat: public QDialog
{
Q_OBJECT
enum comboType {COMBO_OTHER, COMBO_WIDTH, COMBO_FONT, COMBO_SIZE, COMBO_STYLE, COMBO_COLOR, COMBO_VALIGN, COMBO_HALIGN};
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetBorders, *widgetBackground, *widgetFont, *widgetAlignment;
QComboBox *comboBordersWidth, *comboBordersColor, *comboBackgroundColor, *comboBackgroundStyle, *comboFontColor, *comboFontSize, *comboFontFamily, *comboAlignmentVertical, *comboAlignmentHorizontal;
QCheckBox *checkFontBold, *checkFontItalic, *checkAlignmentWrap;
QPushButton *buttonBordersDefaults, *buttonBackgroundDefaults, *buttonFontDefaults, *buttonAlignmentDefaults;
QFrame *frameBackground, *frameFont, *frameAlignment;
QBrush brushBackground;
QFont fontFont;
QColor fontColor;
Qt::AlignmentFlags textAlignment;
FontDatabase fontDB;
// Other objects & variables
Sheet *sheet;
BorderEditor *borderEditor;
bool changedFont, changedAlign, changedBrush;
// Private functions
void createWidthCombo(QComboBox *combo);
void createFontCombo(QComboBox *combo);
void createHAlignCombo(QComboBox *combo);
void createVAlignCombo(QComboBox *combo);
void createStyleCombo(QComboBox *combo);
void createSizeCombo(QComboBox *combo);
void createColorCombo(QComboBox *combo);
QComboBox *createCombo(comboType type, QWidget *parent, const QString &caption, int y);
int findHAlignIndex(Qt::AlignmentFlags flag);
int findVAlignIndex(Qt::AlignmentFlags flag);
int findComboItemIndex(QComboBox *combo, const QString &item);
int findColorIndex(const QColor &color);
int findBrushStyleIndex(Qt::BrushStyle style);
private slots:
void borderClicked(BorderEditor::BorderArea area);
void backgroundClicked(int index);
void fontClicked(bool on);
void fontClicked(int index);
void alignClicked(bool on);
void alignClicked(int index);
void slotBordersDefaults();
void slotBackgroundDefaults();
void slotFontDefaults();
void slotAlignmentDefaults();
public:
CellFormat(QWidget *parent=0);
~CellFormat();
int exec(Sheet *s);
void setTextAlign(Qt::AlignmentFlags flags);
void setTextFont(const QFont &font, const QColor &color);
void setBrushBackground(const QBrush &brush);
};
#endif
diff --git a/noncore/apps/opie-sheet/finddlg.cpp b/noncore/apps/opie-sheet/finddlg.cpp
index e4c6ec8..c724159 100644
--- a/noncore/apps/opie-sheet/finddlg.cpp
+++ b/noncore/apps/opie-sheet/finddlg.cpp
@@ -1,84 +1,104 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
+#include "finddlg.h"
+
+/* QT */
#include <qlabel.h>
#include <qradiobutton.h>
-#include "finddlg.h"
FindDialog::FindDialog(QWidget *parent)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetFind=new QWidget(tabs);
widgetOptions=new QWidget(tabs);
tabs->addTab(widgetFind, tr("&Find && Replace"));
tabs->addTab(widgetOptions, tr("&Options"));
// Find tab
QLabel *label=new QLabel(tr("&Search for:"), widgetFind);
label->setGeometry(10, 10, 215, 20);
editFind=new QLineEdit(widgetFind);
editFind->setGeometry(10, 40, 215, 20);
label->setBuddy(editFind);
label=new QLabel(tr("&Replace with:"), widgetFind);
label->setGeometry(10, 80, 215, 20);
editReplace=new QLineEdit(widgetFind);
editReplace->setGeometry(10, 110, 215, 20);
editReplace->setEnabled(FALSE);
label->setBuddy(editReplace);
groupType=new QVButtonGroup(tr("&Type"), widgetFind);
groupType->setGeometry(10, 150, 215, 90);
QRadioButton *radio=new QRadioButton(tr("&Find"), groupType);
radio=new QRadioButton(tr("&Replace"), groupType);
radio=new QRadioButton(tr("Replace &all"), groupType);
groupType->setButton(0);
connect(groupType, SIGNAL(clicked(int)), this, SLOT(typeChanged(int)));
// Options tab
checkCase=new QCheckBox(tr("Match &case"), widgetOptions);
checkCase->setGeometry(10, 10, 215, 20);
checkSelection=new QCheckBox(tr("Current &selection only"), widgetOptions);
checkSelection->setGeometry(10, 40, 215, 20);
checkEntire=new QCheckBox(tr("&Entire cell"), widgetOptions);
checkEntire->setGeometry(10, 70, 215, 20);
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Find & Replace"));
}
FindDialog::~FindDialog()
-{
-}
+{}
void FindDialog::typeChanged(int id)
{
editReplace->setEnabled(id>0);
}
int FindDialog::exec(Sheet *s)
{
if (QDialog::exec()==QDialog::Accepted)
{
int id=groupType->id(groupType->selected());
s->dataFindReplace(editFind->text(), editReplace->text(), checkCase->isChecked(), !checkSelection->isChecked(), checkEntire->isChecked(), id>0, id>1);
return QDialog::Accepted;
}
return QDialog::Rejected;
}
diff --git a/noncore/apps/opie-sheet/finddlg.h b/noncore/apps/opie-sheet/finddlg.h
index 1af2da5..b456f21 100644
--- a/noncore/apps/opie-sheet/finddlg.h
+++ b/noncore/apps/opie-sheet/finddlg.h
@@ -1,49 +1,70 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef FINDDLG_H
#define FINDDLG_H
+#include "sheet.h"
+
+/* QT */
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qlineedit.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
#include <qvbuttongroup.h>
-#include "sheet.h"
class FindDialog: public QDialog
{
Q_OBJECT
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetFind, *widgetOptions;
QCheckBox *checkCase, *checkSelection, *checkEntire;
QLineEdit *editFind, *editReplace;
QVButtonGroup *groupType;
private slots:
void typeChanged(int id);
public:
FindDialog(QWidget *parent=0);
~FindDialog();
int exec(Sheet *s);
};
#endif
diff --git a/noncore/apps/opie-sheet/main.cpp b/noncore/apps/opie-sheet/main.cpp
index 861473e..bf35908 100644
--- a/noncore/apps/opie-sheet/main.cpp
+++ b/noncore/apps/opie-sheet/main.cpp
@@ -1,23 +1,42 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "mainwindow.h"
#include <opie2/oapplicationfactory.h>
using namespace Opie::Core;
OPIE_EXPORT_APP( OApplicationFactory<MainWindow> )
diff --git a/noncore/apps/opie-sheet/mainwindow.cpp b/noncore/apps/opie-sheet/mainwindow.cpp
index 061748e..bb85a24 100644
--- a/noncore/apps/opie-sheet/mainwindow.cpp
+++ b/noncore/apps/opie-sheet/mainwindow.cpp
@@ -1,285 +1,306 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "mainwindow.h"
+/* OPIE */
#include <qpe/resource.h>
#include <qpe/qpeapplication.h>
+/* QT */
#include <qmessagebox.h>
#include <qradiobutton.h>
+/* STD */
#include "cellformat.h"
#include "numberdlg.h"
#include "textdlg.h"
#include "sortdlg.h"
#include "finddlg.h"
#define DEFAULT_NUM_ROWS 300
#define DEFAULT_NUM_COLS (26*3)
#define DEFAULT_NUM_SHEETS 3
MainWindow::MainWindow(QWidget *parent, const char* n, WFlags fl)
:QMainWindow(parent, n, fl)
{
// initialize variables
documentModified=FALSE;
// construct objects
currentDoc=0;
- fileSelector=new FileSelector("application/sheet-qt", this, QString::null);
+ fileSelector=new FileSelector("application/opie-sheet", this, QString::null);
ExcelSelector=new FileSelector("application/excel",this,QString::null,FALSE);
connect(fileSelector, SIGNAL(closeMe()), this, SLOT(selectorHide()));
connect(fileSelector, SIGNAL(newSelected(const DocLnk&)), this, SLOT(selectorFileNew(const DocLnk&)));
connect(fileSelector, SIGNAL(fileSelected(const DocLnk&)), this, SLOT(selectorFileOpen(const DocLnk&)));
connect(ExcelSelector,SIGNAL(fileSelected(const DocLnk&)),this,SLOT(slotImportExcel(const DocLnk&)));
connect(ExcelSelector,SIGNAL(closeMe()), this, SLOT(ExcelSelectorHide()));
-
listSheets.setAutoDelete(TRUE);
initActions();
initMenu();
initEditToolbar();
initFunctionsToolbar();
initStandardToolbar();
initSheet();
// set window title
setCaption(tr("Opie Sheet"));
// create sheets
selectorFileNew(DocLnk());
}
MainWindow::~MainWindow()
{
if (currentDoc) delete currentDoc;
}
void MainWindow::documentSave(DocLnk *lnkDoc)
{
FileManager fm;
QByteArray streamBuffer;
QDataStream stream(streamBuffer, IO_WriteOnly);
typeSheet *currentSheet=findSheet(sheet->getName());
if (!currentSheet)
{
QMessageBox::critical(this, tr("Error"), tr("Inconsistency error!"));
return;
}
sheet->copySheetData(&currentSheet->data);
stream.writeRawBytes("SQT100", 6);
stream << (Q_UINT32)listSheets.count();
for (typeSheet *tempSheet=listSheets.first(); tempSheet; tempSheet=listSheets.next())
{
stream << tempSheet->name << (Q_UINT32)tempSheet->data.count();
for (typeCellData *tempCell=tempSheet->data.first(); tempCell; tempCell=tempSheet->data.next())
stream << (Q_UINT32)tempCell->col << (Q_UINT32)tempCell->row << tempCell->borders.right << tempCell->borders.bottom << tempCell->background << (Q_UINT32)tempCell->alignment << tempCell->fontColor << tempCell->font << tempCell->data;
}
- lnkDoc->setType("application/sheet-qt");
+ lnkDoc->setType("application/opie-sheet");
if (!fm.saveFile(*lnkDoc, streamBuffer))
{
QMessageBox::critical(this, tr("Error"), tr("File cannot be saved!"));
return;
}
documentModified=FALSE;
}
void MainWindow::documentOpen(const DocLnk &lnkDoc)
{
FileManager fm;
QByteArray streamBuffer;
if (!lnkDoc.isValid() || !fm.loadFile(lnkDoc, streamBuffer))
{
QMessageBox::critical(this, tr("Error"), tr("File cannot be opened!"));
documentModified=FALSE;
selectorFileNew(DocLnk());
return;
}
QDataStream stream(streamBuffer, IO_ReadOnly);
Q_UINT32 countSheet, countCell, i, j, row, col, alignment;
typeSheet *newSheet;
typeCellData *newCell;
char fileFormat[7];
stream.readRawBytes(fileFormat, 6);
fileFormat[6]=0;
if ((QString)fileFormat!="SQT100")
{
QMessageBox::critical(this, tr("Error"), tr("Invalid file format!"));
documentModified=FALSE;
selectorFileNew(DocLnk());
return;
}
stream >> countSheet;
for (i=0; i<countSheet; ++i)
{
newSheet=new typeSheet;
newSheet->data.setAutoDelete(TRUE);
stream >> newSheet->name >> countCell;
comboSheets->insertItem(newSheet->name);
for (j=0; j<countCell; ++j)
{
newCell=new typeCellData;
stream >> col >> row >> newCell->borders.right >> newCell->borders.bottom >> newCell->background >> alignment >> newCell->fontColor >> newCell->font >> newCell->data;
newCell->col=col;
newCell->row=row;
newCell->alignment=(Qt::AlignmentFlags)alignment;
newSheet->data.append(newCell);
}
listSheets.append(newSheet);
if (i==0)
{
sheet->setName(newSheet->name);
sheet->setSheetData(&newSheet->data);
}
}
}
int MainWindow::saveCurrentFile(bool ask)
{
if (ask)
{
int result=QMessageBox::information(this, tr("Save File"), tr("Do you want to save the current file?"), QMessageBox::Yes, QMessageBox::No, QMessageBox::Cancel);
if (result!=QMessageBox::Yes) return result;
}
if (!currentDoc->isValid())
{
TextDialog dialogText(this);
if (dialogText.exec(tr("Save File"), tr("&File Name:"), tr("UnnamedFile"))!=QDialog::Accepted || dialogText.getValue().isEmpty()) return QMessageBox::Cancel;
currentDoc->setName(dialogText.getValue());
currentDoc->setFile(QString::null);
currentDoc->setLinkFile(QString::null);
}
documentSave(currentDoc);
return QMessageBox::Yes;
}
void MainWindow::selectorFileNew(const DocLnk &lnkDoc)
{
selectorHide();
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) return;
if (currentDoc) delete currentDoc;
currentDoc = new DocLnk(lnkDoc);
editData->clear();
listSheets.clear();
comboSheets->clear();
typeSheet *newSheet=createNewSheet();
newSheet->data.setAutoDelete(TRUE);
sheet->setName(newSheet->name);
sheet->setSheetData(&newSheet->data);
for (int i=1; i<DEFAULT_NUM_SHEETS; ++i)
createNewSheet();
documentModified=FALSE;
}
void MainWindow::closeEvent(QCloseEvent *e)
{
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) e->ignore();
else e->accept();
}
void MainWindow::selectorFileOpen(const DocLnk &lnkDoc)
{
selectorHide();
if (documentModified && saveCurrentFile()==QMessageBox::Cancel) return;
if (currentDoc) delete currentDoc;
currentDoc = new DocLnk();
listSheets.clear();
comboSheets->clear();
documentOpen(lnkDoc);
documentModified=FALSE;
}
void MainWindow::selectorShow()
{
sheet->hide();
setCentralWidget(fileSelector);
fileSelector->show();
fileSelector->reread();
}
void MainWindow::selectorHide()
{
fileSelector->hide();
setCentralWidget(sheet);
sheet->show();
}
void MainWindow::slotFileNew()
{
selectorFileNew(DocLnk());
}
void MainWindow::slotFileOpen()
{
selectorShow();
}
void MainWindow::slotImportExcelOpen()
{
sheet->hide();
setCentralWidget(ExcelSelector);
ExcelSelector->show();
ExcelSelector->reread();
}
void MainWindow::ExcelSelectorHide()
{
ExcelSelector->hide();
setCentralWidget(sheet);
sheet->show();
}
void MainWindow::slotFileSave()
{
saveCurrentFile(FALSE);
}
void MainWindow::setDocument(const QString &applnk_filename)
{
selectorFileOpen(DocLnk(applnk_filename));
}
void MainWindow::initActions()
{
fileNew=new QAction(tr("New File"), Resource::loadPixmap( "new" ), tr("&New"), 0, this);
connect(fileNew, SIGNAL(activated()), this, SLOT(slotFileNew()));
fileOpen=new QAction(tr("Open File"), Resource::loadPixmap( "fileopen" ), tr("&Open"), 0, this);
connect(fileOpen, SIGNAL(activated()), this, SLOT(slotFileOpen()));
fileSave=new QAction(tr("Save File"),Resource::loadPixmap( "save" ), tr("&Save"), 0, this);
connect(fileSave, SIGNAL(activated()), this, SLOT(slotFileSave()));
fileSaveAs=new QAction(tr("Save File As"), Resource::loadPixmap( "save" ), tr("Save &As"), 0, this);
connect(fileSaveAs, SIGNAL(activated()), this, SLOT(slotFileSaveAs()));
//fileQuit=new QAction(tr("Quit"), tr("&Quit"), 0, this);
//connect(fileQuit, SIGNAL(activated()), this, SLOT(close()));
fileExcelImport=new QAction(tr("Import Excel file"),Resource::loadPixmap( "opie-sheet/excel16" ),tr("Import E&xcel file"),0,this);
connect(fileExcelImport, SIGNAL(activated()), this, SLOT(slotImportExcelOpen()));
// helpGeneral=new QAction(tr("General Help"), QPixmap(help_general_xpm), tr("&General"), 0, this);
diff --git a/noncore/apps/opie-sheet/mainwindow.h b/noncore/apps/opie-sheet/mainwindow.h
index eacbe36..642b7ae 100644
--- a/noncore/apps/opie-sheet/mainwindow.h
+++ b/noncore/apps/opie-sheet/mainwindow.h
@@ -1,141 +1,164 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef MAINWINDOW_H
#define MAINWINDOW_H
+#include "Excel.h"
+#include "sheet.h"
+
+/* OPIE */
#include <qpe/applnk.h>
#include <qpe/fileselector.h>
+
+/* QT */
#include <qmenubar.h>
#include <qtoolbar.h>
#include <qmainwindow.h>
#include <qaction.h>
#include <qlineedit.h>
#include <qbutton.h>
#include <qcombobox.h>
#include <qtoolbutton.h>
-#include "Excel.h"
-#include "sheet.h"
typedef struct typeSheet
{
QString name;
QList<typeCellData> data;
};
class MainWindow: public QMainWindow
{
Q_OBJECT
// QPE objects
DocLnk* currentDoc;
QMenuBar *menu;
QToolBar *toolbarFunctions, *toolbarEdit, *toolbarStandard;
FileSelector *fileSelector;
FileSelector *ExcelSelector;
// QT objects
QPopupMenu *menuFile, *menuEdit, *menuInsert, *menuFormat, *menuData, *menuHelp,
*submenuFunc, *submenuFuncStd, *submenuFuncStandard, *submenuFuncLogic,
*submenuFuncTrig, *submenuFuncString, *submenuFuncScientific, *submenuFuncDistr,
*submenuFuncStat,
*submenuRow, *submenuCol, *submenuSheet;
QAction *fileNew, *fileOpen, *fileSave, *fileSaveAs, *fileExcelImport, *fileQuit, *helpAbout, *editAccept, *editCancel, *formatCells,
*funcPlus, *funcMinus, *funcCross, *funcDivide, *funcParanOpen, *funcParanClose, *funcComma, *funcEqual,
*editCut, *editCopy, *editPaste, *editPasteContents, *editClear, *insertCols, *insertRows, *insertSheets, *insertCells,
*rowHeight, *rowShow, *rowHide, *rowAdjust, *colWidth, *colShow, *colHide, *colAdjust, *sheetRename, *sheetRemove,
*dataSort, *dataFindReplace, *editCellSelect, *helpGeneral;
QLineEdit *editData;
QButton *buttonUp, *buttonDown, *buttonLeft, *buttonRight;
QComboBox *comboSheets;
QToolButton *toolFunction;
QList<typeSheet> listSheets;
QString helpFile;
// Other objects
Sheet *sheet;
// Variables
bool documentModified;
// Private functions
void initMenu();
void initActions();
void initFunctionsToolbar();
void initEditToolbar();
void initStandardToolbar();
void initSheet();
void addToData(const QString &data);
int saveCurrentFile(bool ask=TRUE);
void documentOpen(const DocLnk &lnkDoc);
void documentSave(DocLnk *lnkDoc);
void closeEvent(QCloseEvent *e);
void addFlyAction(const QString &text, const QString &menuText, const QString &tip, QWidget *w);
typeSheet *createNewSheet();
typeSheet *findSheet(const QString &name);
private slots:
void slotFileNew();
void slotFileOpen();
void slotFileSave();
void slotFileSaveAs();
void slotImportExcel(const DocLnk &lnkDoc);
void slotImportExcelOpen();
void ExcelSelectorHide();
void slotHelpAbout();
void slotEditAccept();
void slotEditCancel();
void slotEditPaste();
void slotEditPasteContents();
void slotFormatCells();
void slotInsertCells();
void slotInsertRows();
void slotInsertCols();
void slotInsertSheets();
void slotDataSort();
void slotDataFindReplace();
void slotRowHeight();
void slotRowAdjust();
void slotRowShow();
void slotRowHide();
void slotColumnWidth();
void slotColumnAdjust();
void slotColumnShow();
void slotColumnHide();
void slotSheetRename();
void slotSheetRemove();
void slotFuncOutput();
void slotCellSelect(bool lock);
void slotCellClicked(const QString &cell);
void slotSheetChanged(const QString &name);
void slotDocModified();
void selectorShow();
void selectorHide();
void selectorFileNew(const DocLnk &lnkDoc);
void selectorFileOpen(const DocLnk &lnkDoc);
public:
static QString appName() { return QString::fromLatin1("sheetqt"); }
MainWindow(QWidget *p, const char*, WFlags);
~MainWindow();
void setHelpFile(const QString &help_filename) { helpFile=help_filename; }
public slots:
void setDocument(const QString &applnk_filename);
};
#endif
diff --git a/noncore/apps/opie-sheet/numberdlg.cpp b/noncore/apps/opie-sheet/numberdlg.cpp
index 90fbaa2..43574e9 100644
--- a/noncore/apps/opie-sheet/numberdlg.cpp
+++ b/noncore/apps/opie-sheet/numberdlg.cpp
@@ -1,50 +1,68 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "numberdlg.h"
NumberDialog::NumberDialog(QWidget *parent)
:QDialog(parent, 0, TRUE)
{
edit=new QSpinBox(this);
edit->setGeometry(120, 10, 70, 25);
label=new QLabel(this);
label->setGeometry(10, 10, 100, 25);
label->setBuddy(edit);
resize(200, 45);
}
NumberDialog::~NumberDialog()
-{
-}
+{}
int NumberDialog::exec(const QString &caption, const QString &text,
int value, int min, int max, int step)
{
setCaption(caption);
label->setText(text);
edit->setValue(value);
edit->setMinValue(min);
edit->setMaxValue(max);
edit->setLineStep(step);
return QDialog::exec();
}
int NumberDialog::getValue()
{
return edit->value();
}
diff --git a/noncore/apps/opie-sheet/numberdlg.h b/noncore/apps/opie-sheet/numberdlg.h
index 81e3326..497c076 100644
--- a/noncore/apps/opie-sheet/numberdlg.h
+++ b/noncore/apps/opie-sheet/numberdlg.h
@@ -1,38 +1,58 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef NUMBERDLG_H
#define NUMBERDLG_H
+/* QT */
#include <qdialog.h>
#include <qlabel.h>
#include <qspinbox.h>
class NumberDialog: public QDialog
{
Q_OBJECT
// QT objects
QLabel *label;
QSpinBox *edit;
public:
NumberDialog(QWidget *parent=0);
~NumberDialog();
int exec(const QString &caption, const QString &text, int value=1, int min=1, int max=99, int step=1);
int getValue();
};
#endif
diff --git a/noncore/apps/opie-sheet/opie-sheet.pro b/noncore/apps/opie-sheet/opie-sheet.pro
index ced4daf..d0beb93 100644
--- a/noncore/apps/opie-sheet/opie-sheet.pro
+++ b/noncore/apps/opie-sheet/opie-sheet.pro
@@ -1,9 +1,24 @@
CONFIG = qt warn_on quick-app
-HEADERS = mainwindow.h sheet.h cellformat.h finddlg.h numberdlg.h sortdlg.h textdlg.h Excel.h
-SOURCES = main.cpp mainwindow.cpp sheet.cpp cellformat.cpp finddlg.cpp numberdlg.cpp sortdlg.cpp textdlg.cpp Excel.cpp
+HEADERS = mainwindow.h \
+ sheet.h \
+ cellformat.h \
+ finddlg.h \
+ numberdlg.h \
+ sortdlg.h \
+ textdlg.h \
+ Excel.h
+SOURCES = main.cpp \
+ mainwindow.cpp \
+ sheet.cpp \
+ cellformat.cpp \
+ finddlg.cpp \
+ numberdlg.cpp \
+ sortdlg.cpp \
+ textdlg.cpp \
+ Excel.cpp
INCLUDEPATH += $(OPIEDIR)/include
DEPENDPATH += $(OPIEDIR)/include
LIBS += -lqpe -lopiecore2
TARGET = opie-sheet
include ( $(OPIEDIR)/include.pro )
diff --git a/noncore/apps/opie-sheet/sheet.cpp b/noncore/apps/opie-sheet/sheet.cpp
index 88847da..477c982 100644
--- a/noncore/apps/opie-sheet/sheet.cpp
+++ b/noncore/apps/opie-sheet/sheet.cpp
@@ -1,1777 +1,1824 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "sheet.h"
+/* QT */
#include <qmessagebox.h>
+
+/* STD */
#include <math.h>
#include <stdlib.h>
#include <stdio.h>
#include <time.h>
#define DEFAULT_COL_WIDTH 50
Sheet::Sheet(int numRows, int numCols, QWidget *parent)
:QTable(numRows, numCols, parent)
{
defaultBorders.right=defaultBorders.bottom=QPen(Qt::gray, 1, Qt::SolidLine);
defaultCellData.data="";
defaultCellData.background=QBrush(Qt::white, Qt::SolidPattern);
defaultCellData.alignment=(Qt::AlignmentFlags)(Qt::AlignLeft | Qt::AlignTop);
defaultCellData.fontColor=Qt::black;
defaultCellData.font=font();
defaultCellData.borders=defaultBorders;
clicksLocked=FALSE;
selectionNo=-1;
setSelectionMode(QTable::Single);
sheetData.setAutoDelete(TRUE);
clipboardData.setAutoDelete(TRUE);
for (int i=0; i<numCols; ++i)
horizontalHeader()->setLabel(i, getHeaderString(i+1), DEFAULT_COL_WIDTH);
connect(this, SIGNAL(currentChanged(int,int)), this, SLOT(slotCellSelected(int,int)));
connect(this, SIGNAL(valueChanged(int,int)), this, SLOT(slotCellChanged(int,int)));
}
Sheet::~Sheet()
-{
-}
+{}
typeCellData *Sheet::findCellData(int row, int col)
{
typeCellData *tempCellData;
for (tempCellData=sheetData.first(); tempCellData; tempCellData=sheetData.next())
{
if (tempCellData->row==row && tempCellData->col==col) return tempCellData;
}
return NULL;
}
void Sheet::slotCellSelected(int row, int col)
{
typeCellData *cellData=findCellData(row, col);
if (cellData)
{
emit currentDataChanged(cellData->data);
- }else
+ }
+ else
emit currentDataChanged("");
}
typeCellData *Sheet::createCellData(int row, int col)
{
if (row<0 || col<0) return NULL;
typeCellData *cellData=new typeCellData;
cellData->row=row;
cellData->col=col;
cellData->data=defaultCellData.data;
cellData->borders=defaultCellData.borders;
cellData->alignment=defaultCellData.alignment;
cellData->font=defaultCellData.font;
cellData->fontColor=defaultCellData.fontColor;
cellData->background=defaultCellData.background;
sheetData.append(cellData);
return cellData;
}
void Sheet::slotCellChanged(int row, int col)
{
typeCellData *cellData=findCellData(row, col);
if (!cellData) cellData=createCellData(row, col);
if (cellData) cellData->data=text(row, col);
for (cellData=sheetData.first(); cellData; cellData=sheetData.next())
{
// modified by Toussis Manolis koppermind@panafonet.gr
// the parser was crashing if there were no closed parenthesis.
int w1,ii=0;
for(w1=0;w1<=(int)text(row, col).length();w1++)
{
if(text(row,col)[w1]=='(') ii++;
if(text(row,col)[w1]==')') ii--;
};
if(ii==0) setText(cellData->row, cellData->col, dataParser(findCellName(cellData->row, cellData->col), cellData->data));
//end of modification
// old was plain:
//setText(cellData->row, cellData->col, dataParser(findCellName(cellData->row, cellData->col), cellData->data));
};
emit sheetModified();
}
void Sheet::ReCalc(void)
{
typeCellData* cellData;
for (cellData=sheetData.first(); cellData; cellData=sheetData.next())
{
//printf("cellchanged:%d, %d\r\n",cellData->row,cellData->col);
slotCellChanged(cellData->row,cellData->col);
};
};
void Sheet::swapCells(int row1, int col1, int row2, int col2)
{
typeCellData *cellData1=findCellData(row1, col1), *cellData2=findCellData(row2, col2);
if (!cellData1) cellData1=createCellData(row1, col1);
if (!cellData2) cellData2=createCellData(row2, col2);
if (cellData1 && cellData2)
{
QString tempData(cellData1->data);
cellData1->data=cellData2->data;
cellData2->data=tempData;
setText(cellData1->row, cellData1->col, dataParser(findCellName(cellData1->row, cellData1->col), cellData1->data));
setText(cellData2->row, cellData2->col, dataParser(findCellName(cellData2->row, cellData2->col), cellData2->data));
emit sheetModified();
}
}
QString Sheet::getParameter(const QString &parameters, int paramNo, bool giveError, const QString funcName)
{
QString params(parameters);
int position;
for (int i=0; i<paramNo; ++i)
{
position=params.find(',');
if (position<0)
{
if (giveError) QMessageBox::critical(this, tr("Error"), tr("Too few arguments to function '"+funcName+'\''));
//printf("params:%s\r\n",parameters.ascii());
return QString(NULL);
}
params=params.mid(position+1);
}
position=params.find(',');
if (position<0) return params;
return params.left(position);
}
bool Sheet::findRange(const QString &variable1, const QString &variable2, int *row1, int *col1, int *row2, int *col2)
{
int row, col;
if (!findRowColumn(variable1, row1, col1, FALSE) || !findRowColumn(variable2, row2, col2, FALSE)) return FALSE;
if (*row1>*row2)
{
row=*row1;
*row1=*row2;
*row2=row;
}
if (*col1>*col2)
{
col=*col1;
*col1=*col2;
*col2=col;
}
return TRUE;
}
bool Sheet::findRowColumn(const QString &variable, int *row, int *col, bool giveError)
{
int position=variable.find(QRegExp("\\d"));
if (position<1)
{
if (giveError) QMessageBox::critical(this, tr("Error"), tr("Invalid variable: '"+variable+'\''));
return FALSE;
}
*row=variable.mid(position).toInt()-1;
*col=getHeaderColumn(variable.left(position))-1;
return TRUE;
}
QString Sheet::calculateVariable(const QString &variable)
{
bool ok;
printf("calculateVariable=%s,len=%d\r\n",variable.ascii(),variable.length());
if(variable.left(1)=="\"") return QString(variable.mid(1,variable.length()-2));
double tempResult=variable.toDouble(&ok);
if (ok)
{
if(tempResult!=0.0)
{
return QString::number(tempResult);
}
else
{
if(variable!="0" || variable!="0.0") return QString(variable); // hereis a string variable
return QString::number(tempResult);
};
};
int row, col;
if(findRowColumn(variable, &row, &col, FALSE)) return dataParser(variable, text(row,col));
//return (findRowColumn(variable, &row, &col, TRUE) ? dataParser(variable, text(row, col)) : 0);
return QString(variable);
}
double Sheet::BesselI0(double x)
{
//Returns the modi ed Bessel function I0(x) for any real x.
double ax,ans;
double y;
if ((ax=fabs(x)) < 3.75)
{
y=x/3.75;
y*=y;
ans=1.0+y*(3.5156229+y*(3.0899424+y*(1.2067492 +y*(0.2659732+y*(0.360768e-1+y*0.45813e-2)))));
- }else
+ }
+ else
{
y=3.75/ax;
ans=(exp(ax)/sqrt(ax))*(0.39894228+y*(0.1328592e-1 +y*(0.225319e-2+y*(-0.157565e-2+y*(0.916281e-2 +y*(-0.2057706e-1+y*(0.2635537e-1+y*(-0.1647633e-1 +y*0.392377e-2))))))));
}
return ans;
};
double Sheet::BesselI1(double x)
{
double ax,ans;
double y;
if ((ax=fabs(x)) < 3.75)
{
y=x/3.75;
y*=y;
ans=ax*(0.5+y*(0.87890594+y*(0.51498869+y*(0.15084934 +y*(0.2658733e-1+y*(0.301532e-2+y*0.32411e-3))))));
- } else
+ }
+ else
{
y=3.75/ax;
ans=0.2282967e-1+y*(-0.2895312e-1+y*(0.1787654e-1 -y*0.420059e-2)); ans=0.39894228+y*(-0.3988024e-1+y*(-0.362018e-2 +y*(0.163801e-2+y*(-0.1031555e-1+y*ans))));
ans *= (exp(ax)/sqrt(ax));
}
return x < 0.0 ? -ans : ans;
};
double Sheet::BesselI(int n, double x)
{
double ACC=40.0;
double BIGNO=1.0e10;
double BIGNI=1.0e-10;
int j;
double bi,bim,bip,tox,ans;
if (n < 2) return 0.0;
if (x == 0.0) return 0.0; else
{
tox=2.0/fabs(x);
bip=ans=0.0;
bi=1.0;
for (j=2*(n+(int) sqrt(ACC*n));j>0;j--)
{
bim=bip+j*tox*bi;
bip=bi;
bi=bim;
if (fabs(bi) > BIGNO)
{
ans *= BIGNI;
bi *= BIGNI;
bip *= BIGNI;
}
if (j == n) ans=bip;
}
ans *= BesselI0(x)/bi;
return x < 0.0 && (n & 1) ? -ans : ans;
}
};
double Sheet::BesselK0(double x)
{
double y,ans;
if (x <= 2.0)
{
y=x*x/4.0;
ans=(-log(x/2.0)*BesselI0(x))+(-0.57721566+y*(0.42278420 +y*(0.23069756+y*(0.3488590e-1+y*(0.262698e-2 +y*(0.10750e-3+y*0.74e-5))))));
- } else
+ }
+ else
{
y=2.0/x;
ans=(exp(-x)/sqrt(x))*(1.25331414+y*(-0.7832358e-1 +y*(0.2189568e-1+y*(-0.1062446e-1+y*(0.587872e-2 +y*(-0.251540e-2+y*0.53208e-3))))));
}
return ans;
};
double Sheet::BesselK1(double x)
{
double y,ans;
if (x <= 2.0)
{
y=x*x/4.0;
ans=(log(x/2.0)*BesselI1(x))+(1.0/x)*(1.0+y*(0.15443144 +y*(-0.67278579+y*(-0.18156897+y*(-0.1919402e-1 +y*(-0.110404e-2+y*(-0.4686e-4)))))));
- } else
+ }
+ else
{
y=2.0/x;
ans=(exp(-x)/sqrt(x))*(1.25331414+y*(0.23498619 +y*(-0.3655620e-1+y*(0.1504268e-1+y*(-0.780353e-2 +y*(0.325614e-2+y*(-0.68245e-3)))))));
}
return ans;
};
double Sheet::BesselK(int n, double x)
{
int j;
double bk,bkm,bkp,tox;
if (n < 2) return 0.0;
tox=2.0/x;
bkm=BesselK0(x);
bk=BesselK1(x);
for (j=1;j<n;j++)
{
bkp=bkm+j*tox*bk;
bkm=bk;
bk=bkp;
}
return bk;
};
double Sheet::BesselJ0(double x)
{
double ax,z;
double xx,y,ans,ans1,ans2;
if ((ax=fabs(x)) < 8.0)
{
y=x*x;
ans1=57568490574.0+y*(-13362590354.0+y*(651619640.7 +y*(-11214424.18+y*(77392.33017+y*(-184.9052456)))));
ans2=57568490411.0+y*(1029532985.0+y*(9494680.718 +y*(59272.64853+y*(267.8532712+y*1.0))));
ans=ans1/ans2;
- } else
+ }
+ else
{
z=8.0/ax;
y=z*z;
xx=ax-0.785398164;
ans1=1.0+y*(-0.1098628627e-2+y*(0.2734510407e-4 +y*(-0.2073370639e-5+y*0.2093887211e-6)));
ans2 = -0.1562499995e-1+y*(0.1430488765e-3 +y*(-0.6911147651e-5+y*(0.7621095161e-6 -y*0.934935152e-7)));
ans=sqrt(0.636619772/ax)*(cos(xx)*ans1-z*sin(xx)*ans2);
}
return ans;
};
double Sheet::BesselY0(double x)
{
double z;
double xx,y,ans,ans1,ans2;
if (x < 8.0)
{
y=x*x;
ans1 = -2957821389.0+y*(7062834065.0+y*(-512359803.6 +y*(10879881.29+y*(-86327.92757+y*228.4622733))));
ans2=40076544269.0+y*(745249964.8+y*(7189466.438 +y*(47447.26470+y*(226.1030244+y*1.0))));
ans=(ans1/ans2)+0.636619772*BesselJ0(x)*log(x);
- } else
+ }
+ else
{
z=8.0/x;
y=z*z;
xx=x-0.785398164;
ans1=1.0+y*(-0.1098628627e-2+y*(0.2734510407e-4 +y*(-0.2073370639e-5+y*0.2093887211e-6)));
ans2 = -0.1562499995e-1+y*(0.1430488765e-3 +y*(-0.6911147651e-5+y*(0.7621095161e-6 +y*(-0.934945152e-7))));
ans=sqrt(0.636619772/x)*(sin(xx)*ans1+z*cos(xx)*ans2);
}
return ans;
};
double Sheet::BesselJ1(double x)
{
double ax,z;
double xx,y,ans,ans1,ans2;
if ((ax=fabs(x)) < 8.0)
{
y=x*x;
ans1=x*(72362614232.0+y*(-7895059235.0+y*(242396853.1 +y*(-2972611.439+y*(15704.48260+y*(-30.16036606))))));
ans2=144725228442.0+y*(2300535178.0+y*(18583304.74 +y*(99447.43394+y*(376.9991397+y*1.0))));
ans=ans1/ans2;
- } else
+ }
+ else
{
z=8.0/ax; y=z*z; xx=ax-2.356194491;
ans1=1.0+y*(0.183105e-2+y*(-0.3516396496e-4 +y*(0.2457520174e-5+y*(-0.240337019e-6))));
ans2=0.04687499995+y*(-0.2002690873e-3 +y*(0.8449199096e-5+y*(-0.88228987e-6 +y*0.105787412e-6)));
ans=sqrt(0.636619772/ax)*(cos(xx)*ans1-z*sin(xx)*ans2);
if (x < 0.0) ans = -ans;
}
return ans;
};
double Sheet::BesselY1(double x)
{
double z;
double xx,y,ans,ans1,ans2;
if (x < 8.0)
{
y=x*x;
ans1=x*(-0.4900604943e13+y*(0.1275274390e13 +y*(-0.5153438139e11+y*(0.7349264551e9 +y*(-0.4237922726e7+y*0.8511937935e4)))));
ans2=0.2499580570e14+y*(0.4244419664e12 +y*(0.3733650367e10+y*(0.2245904002e8 +y*(0.1020426050e6+y*(0.3549632885e3+y)))));
ans=(ans1/ans2)+0.636619772*(BesselJ1(x)*log(x)-1.0/x);
- } else
+ }
+ else
{
z=8.0/x;
y=z*z;
xx=x-2.356194491;
ans1=1.0+y*(0.183105e-2+y*(-0.3516396496e-4 +y*(0.2457520174e-5+y*(-0.240337019e-6))));
ans2=0.04687499995+y*(-0.2002690873e-3 +y*(0.8449199096e-5+y*(-0.88228987e-6 +y*0.105787412e-6)));
ans=sqrt(0.636619772/x)*(sin(xx)*ans1+z*cos(xx)*ans2);
}
return ans;
};
double Sheet::BesselY(int n, double x)
{
int j;
double by,bym,byp,tox;
if (n < 2) return 0.0;
tox=2.0/x;
by=BesselY1(x);
bym=BesselY0(x);
for (j=1;j<n;j++)
{
byp=j*tox*by-bym;
bym=by;
by=byp;
}
return by;
};
double Sheet::BesselJ(int n, double x)
{
double ACC=40.0;
double BIGNO=1.0e10;
double BIGNI=1.0e-10;
int j,jsum,m;
double ax,bj,bjm,bjp,sum,tox,ans;
if (n < 2) return 0.0;
ax=fabs(x);
if (ax == 0.0) return 0.0;
else if (ax > (double) n)
{
tox=2.0/ax;
bjm=BesselJ0(ax);
bj=BesselJ1(ax);
for (j=1;j<n;j++)
{
bjp=j*tox*bj-bjm;
bjm=bj;
bj=bjp;
}
ans=bj;
- } else
+ }
+ else
{
tox=2.0/ax;
m=2*((n+(int) sqrt(ACC*n))/2);
jsum=0;
bjp=ans=sum=0.0;
bj=1.0;
for (j=m;j>0;j--)
{
bjm=j*tox*bj-bjp;
bjp=bj;
bj=bjm;
if (fabs(bj) > BIGNO)
{
bj *= BIGNI;
bjp *= BIGNI;
ans *= BIGNI;
sum *= BIGNI;
}
if (jsum) sum += bj;
jsum=!jsum;
if (j == n) ans=bjp;
}
sum=2.0*sum-bj;
ans /= sum;
}
return x < 0.0 && (n & 1) ? -ans : ans;
};
double Sheet::GammaLn(double xx)
{
double x,y,tmp,ser;
static double cof[6]={76.18009172947146,-86.50532032941677, 24.01409824083091,-1.231739572450155, 0.1208650973866179e-2,-0.5395239384953e-5};
int j;
y=x=xx;
tmp=x+5.5;
tmp -= (x+0.5)*log(tmp);
ser=1.000000000190015;
for (j=0;j<=5;j++) ser += cof[j]/++y;
return -tmp+log(2.5066282746310005*ser/x);
};
double Sheet::Factorial(double n)
{
if (n < 0) return 0.0;
if (n > 100) return 0.0;
return exp(GammaLn(n+1.0));
};
double Sheet::GammaP(double a, double x)
{
// returns GammaP(a,x)
//void gcf(float *gammcf, float a, float x, float *gln);
//void gser(float *gamser, float a, float x, float *gln);
double gamser,gammcf,gln;
if (x < 0.0 || a <= 0.0) return 0.0;//error
if (x < (a+1.0))
{
GammaSeries(&gamser,a,x,&gln);
return gamser;
- }else
+ }
+ else
{
GammaContinuedFraction(&gammcf,a,x,&gln);
return 1.0-gammcf;
}
};
double Sheet::GammaQ(double a,double x)
{
//returns GammaQ(a,x)=1.0 - GammaP(a,x);
return (1.0-GammaP(a,x));
};
void Sheet::GammaSeries(double *gamser, double a, double x, double *gln)
{
double EPS=3.0e-7;
int ITMAX=100;
int n;
double sum,del,ap;
*gln=GammaLn(a);
if (x <= 0.0)
{
if (x < 0.0) return;//error
*gamser=0.0;
return;
- } else
+ }
+ else
{
ap=a;
del=sum=1.0/a;
for (n=1;n<=ITMAX;n++)
{
++ap;
del *= x/ap;
sum += del;
if (fabs(del) < fabs(sum)*EPS)
{
*gamser=sum*exp(-x+a*log(x)-(*gln));
return;
}
- } return;
+ }
+ return;
return;
}
};
void Sheet::GammaContinuedFraction(double *gammcf, double a, double x, double *gln)
{
double EPS=3.0e-7;
double FPMIN=1.0e-30;
int ITMAX=100;
int i;
double an,b,c,d,del,h;
*gln=GammaLn(a);
b=x+1.0-a;
c=1.0/FPMIN;
d=1.0/b; h=d;
for (i=1;i<=ITMAX;i++)
{
an = -i*(i-a);
b += 2.0; d=an*d+b;
if (fabs(d) < FPMIN) d=FPMIN;
c=b+an/c;
if (fabs(c) < FPMIN) c=FPMIN;
d=1.0/d; del=d*c; h *= del;
if (fabs(del-1.0) < EPS) break;
}
if (i > ITMAX) return;
*gammcf=exp(-x+a*log(x)-(*gln))*h;
};
double Sheet::ErrorFunction(double x)
{
return x < 0.0 ? -GammaP(0.5,x*x) : GammaP(0.5,x*x);
};
double Sheet::ErrorFunctionComplementary(double x)
{
return x < 0.0 ? 1.0+GammaP(0.5,x*x) : GammaQ(0.5,x*x);
};
double Sheet::Beta(double z, double w)
{
return exp(GammaLn(z)+GammaLn(w)-GammaLn(z+w));
};
double Sheet::BetaContinuedFraction(double a, double b, double x)
{
int MAXIT=100;
double EPS=3.0e-7;
double FPMIN=1.0e-30;
int m,m2;
double aa,c,d,del,h,qab,qam,qap;
qab=a+b;
qap=a+1.0; qam=a-1.0; c=1.0;
d=1.0-qab*x/qap;
if (fabs(d) < FPMIN) d=FPMIN;
d=1.0/d; h=d;
for (m=1;m<=MAXIT;m++)
{
m2=2*m; aa=m*(b-m)*x/((qam+m2)*(a+m2));
d=1.0+aa*d;
if (fabs(d) < FPMIN) d=FPMIN;
c=1.0+aa/c;
if (fabs(c) < FPMIN) c=FPMIN;
d=1.0/d; h *= d*c;
aa = -(a+m)*(qab+m)*x/((a+m2)*(qap+m2)); d=1.0+aa*d;
if (fabs(d) < FPMIN) d=FPMIN;
c=1.0+aa/c;
if (fabs(c) < FPMIN) c=FPMIN; d=1.0/d;
del=d*c; h *= del;
if (fabs(del-1.0) < EPS) break;
}
if (m > MAXIT) return 0.0;
return h;
};
double Sheet::BetaIncomplete(double a, double b, double x)
{
double bt;
if (x < 0.0 || x > 1.0) return 0.0;
if (x == 0.0 || x == 1.0) bt=0.0; else
bt=exp(GammaLn(a+b)-GammaLn(a)-GammaLn(b)+a*log(x)+b*log(1.0-x));
if (x < (a+1.0)/(a+b+2.0)) return bt*BetaContinuedFraction(a,b,x)/a; else
return 1.0-bt*BetaContinuedFraction(b,a,1.0-x)/b;
};
double Sheet::functionSum(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
double result=0, tempResult;
bool ok;
if (findRange(param1, param2, &row1, &col1, &row2, &col2))
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok) result+=tempResult;
}
return result;
- }else
+ }
+ else
{
double d1=0,d2=0;
d1=calculateVariable(param1).toDouble(&ok);
d2=calculateVariable(param2).toDouble(&ok);
return(d1+d2);
};
return 0;
}
QString Sheet::functionIndex(const QString &param1, const QString &param2, int indx)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
int ii=1;
for (col=col1; col<=col2; ++col)
for (row=row1; row<=row2; ++row)
{
if(ii==indx) return text(row,col);
ii++;
}
return QString("");
}
double Sheet::functionVariancePopulation(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double avg1=functionAvg(param1,param2);
double result=0, tempResult;
int count1=0;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok) { result=result + (tempResult - avg1)*(tempResult - avg1); count1++;};
}
if(count1>0) result=result/double(count1); else result=0.0;
return result;
};
double Sheet::functionVariance(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double avg1=functionAvg(param1,param2);
double result=0, tempResult;
int count1=0;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok) { result=result + (tempResult - avg1)*(tempResult - avg1); count1++;};
}
if(count1>1) result=result/double(count1-1); else result=0.0;
return result;
};
double Sheet::functionSkew(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double avg1=functionAvg(param1,param2);
double var1=sqrt(functionVariancePopulation(param1,param2));
if(var1==0.0) return 0.0;
double result=0, tempResult;
int count1=0;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok)
{
result=result + (tempResult - avg1)*(tempResult - avg1)*(tempResult - avg1)/(var1*var1*var1);
count1++;
};
}
if(count1>0) result=result/double(count1); else result=0.0;
return result;
};
double Sheet::functionKurt(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
double avg1=functionAvg(param1,param2);
double var1=sqrt(functionVariancePopulation(param1,param2));
if(var1==0.0) return 0.0;
double result=0, tempResult;
int count1=0;
bool ok;
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok)
{
result=result + (tempResult - avg1)*(tempResult - avg1)*
(tempResult - avg1)*(tempResult - avg1)/(var1*var1*var1*var1);
count1++;
};
}
if(count1>0) result=result/double(count1)-3.0; else result=0.0;
return result;
};
double Sheet::functionSumSQ(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
double result=0, tempResult;
bool ok;
if (findRange(param1, param2, &row1, &col1, &row2, &col2))
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempResult=text(row, col).toDouble(&ok);
if (ok) result+=tempResult*tempResult;
}
return result;
- }else
+ }
+ else
{
double d1=0,d2=0;
d1=calculateVariable(param1).toDouble(&ok);
d2=calculateVariable(param2).toDouble(&ok);
return(d1*d1+d2*d2);
};
return 0;
}
double Sheet::functionMin(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
double min=0, tempMin;
bool ok, init=FALSE;
if (findRange(param1, param2, &row1, &col1, &row2, &col2))
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempMin=text(row, col).toDouble(&ok);
if (ok && (!init || tempMin<min))
{
min=tempMin;
init=TRUE;
}
}
return min;
- }else
+ }
+ else
{
double d1=0,d2=0;
d1=calculateVariable(param1).toDouble(&ok);
d2=calculateVariable(param2).toDouble(&ok);
if(d1<d2) return(d1); else return(d2);
};
return 0;
}
double Sheet::functionMax(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
double max=0, tempMax;
bool ok, init=FALSE;
if (findRange(param1, param2, &row1, &col1, &row2, &col2))
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
tempMax=text(row, col).toDouble(&ok);
if (ok && (!init || tempMax>max))
{
max=tempMax;
init=TRUE;
}
};
return max;
- }else
+ }
+ else
{
double d1=0,d2=0;
d1=calculateVariable(param1).toDouble(&ok);
d2=calculateVariable(param2).toDouble(&ok);
if(d1>d2) return(d1); else return(d2);
};
return 0;
}
double Sheet::functionAvg(const QString &param1, const QString &param2)
{
double resultSum=functionSum(param1, param2), resultCount=functionCount(param1, param2);
return (resultCount>0 ? resultSum/resultCount : 0);
}
double Sheet::functionCount(const QString &param1, const QString &param2)
{
int row1, col1, row2, col2, row, col;
int divider=0;
bool ok;
if (findRange(param1, param2, &row1, &col1, &row2, &col2))
{
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
text(row, col).toDouble(&ok);
if (ok) ++divider;
};
return divider;
- }else
+ }
+ else
{
double d1=0,d2=0;int ii=0;
d1=calculateVariable(param1).toDouble(&ok);
if (ok) ii++;
d2=calculateVariable(param2).toDouble(&ok);
if (ok) ii++;
return(ii);
};
return 0;
}
double Sheet::functionCountIf(const QString &param1, const QString &param2, const QString &param3)
{
int row1, col1, row2, col2, row, col;
if (!findRange(param1, param2, &row1, &col1, &row2, &col2)) return 0;
//same as count except check if each field is equal to param3
int divider=0;
QString s2;
bool ok;
s2=calculateVariable(param3);
for (row=row1; row<=row2; ++row)
for (col=col1; col<=col2; ++col)
{
text(row, col).toDouble(&ok);
if (ok && (s2==text(row,col)) ) ++divider;
}
return divider;
}
QString Sheet::calculateFunction(const QString &func, const QString &parameters, int NumOfParams)
{
bool ok;
double val1=0.0,val2=0.0,val3=0.0;
long int vali=0;
int w1,w2;
int row,col;
QString s1,s2;
//basic functions
QString function;
function=func.upper();
if (function=="+")
{
s1=calculateVariable(getParameter(parameters, 0));
s2=calculateVariable(getParameter(parameters, 1));
val1=s1.toDouble(&ok)+s2.toDouble(&ok);
return QString::number(val1);
};
if (function=="-")
{
s1=calculateVariable(getParameter(parameters, 0));
s2=calculateVariable(getParameter(parameters, 1));
val1=s1.toDouble(&ok)-s2.toDouble(&ok);
return QString::number(val1);
};
if (function=="*")
{
val1=calculateVariable(
getParameter(parameters, 0)).toDouble(&ok)
*calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
return QString::number(val1);
};
if (function=="/")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val2==0.0) return QString("Err101");
val1=val1/val2;
return QString::number(val1);
};
if (function==">")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1>val2) return QString::number(1); else return QString::number(0);
};
if (function=="<")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1<val2) return QString::number(1); else return QString::number(0);
};
if (function==">=")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1>=val2) return QString::number(1); else return QString::number(0);
};
if (function=="<=")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1<=val2) return QString::number(1); else return QString::number(0);
};
if (function=="!=")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1!=val2) return QString::number(1); else return QString::number(0);
};
if (function=="=="||function=="=")
{
val1=calculateVariable(getParameter(parameters, 0)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1)).toDouble(&ok);
if(val1==val2) return QString::number(1); else return QString::number(0);
};
//LOGICAL / INFO
if (function=="ISBLANK")
{
if(findRowColumn(getParameter(parameters, 0), &row, &col, FALSE))
{
if(text(row,col).length()==0) val1=1; else val1=0;
- }else
+ }
+ else
{
if(findRowColumn(calculateVariable(getParameter(parameters, 0)), &row,&col, FALSE))
{
if(text(row,col).length()==0) val1=1; else val1=0;
- }else
+ }
+ else
{
val1=0;
};
};
return QString::number(val1);
};
if (function=="ISNUMBER")
{
if(findRowColumn(getParameter(parameters, 0, TRUE, function), &row, &col, FALSE))
{
val1=text(row,col).toDouble(&ok);
if(ok) val1=1; else val1=0;
- }else
+ }
+ else
{
if(findRowColumn(calculateVariable(getParameter(parameters, 0, TRUE, function)), &row,&col, FALSE))
{
val1=text(row,col).toDouble(&ok);
if(ok) val1=1; else val1=0;
- }else
+ }
+ else
{
val1=0;
};
};
return QString::number(val1);
};
if (function=="AND")
{
vali=calculateVariable(getParameter(parameters, 0, TRUE, function)).toInt(&ok)
& calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
return QString::number(vali);
};
if (function=="OR")
{
vali=calculateVariable(getParameter(parameters, 0, TRUE, function)).toInt(&ok)
| calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
return QString::number(vali);
};
if (function=="NOT")
{
vali=!calculateVariable(getParameter(parameters, 0, TRUE, function)).toInt(&ok);
return QString::number(vali);
};
// MATHEMATICAL FUNCTIONS
if (function=="ABS")
{
val1=fabs(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ACOS")
{
val1=acos(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ACOSH")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
if(val1<1.0) return QString::number(0);
val1=acosh(val1);
return QString::number(val1);
};
if (function=="ASIN")
{
val1=asin(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ASINH")
{
val1=asinh(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ATAN")
{
val1=atan(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ATAN2")
{
val1=atan2(calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok),
calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="ATANH")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
if(val1<=-1.0 || val1>=1.0) return QString("Err101");
val1=atanh(val1);
return QString::number(val1);
};
if (function=="CEILING")
{
// rounds up param1 to specified accuracy param2
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
if(val2==0.0) return QString::number(val1);
val1=ceil(val1/val2)*val2;
return QString::number(val1);
};
if (function=="COS")
{
val1=cos(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="COSH")
{
val1=cosh(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="DEGREES")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok)*180.0/M_PI;
return QString::number(val1);
};
if (function=="EXP")
{
val1=exp(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="FACT")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=Factorial(val1);
return QString::number(val2);
};
if (function=="FLOOR")
{
// rounds down param1 to specified accuracy param2
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
if(val2==0.0) return QString::number(val1);
val1=floor(val1/val2)*val2;
return QString::number(val1);
};
if (function=="INT")
{
// rounds down param1
val1=int(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="EVEN")
{
//converts param1 to even
vali=int(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
if(vali % 2 !=0) val1=vali+1; else val1=vali;
return QString::number(val1);
};
if (function=="ODD")
{
//converts param1 to odd
vali=int(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
if(vali % 2 !=0) val1=vali; else val1=vali+1;
return QString::number(val1);
};
if (function=="ISEVEN")
{
//Is Even param1?
vali=int(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
if(vali % 2 == 0) val1=1; else val1=0;
return QString::number(val1);
};
if (function=="ISODD")
{
//Is odd param1?
vali=int(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
if(vali % 2 == 0) val1=0; else val1=1;
return QString::number(val1);
};
if (function=="LN")
{
// returns the natural logarithm of param1
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
if(val1<=0.0) return QString("Err101");
val1=log(val1);
return QString::number(val1);
};
if (function=="LOG10")
{
// returns the base-10 logarithm of param1
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
if(val1<=0.0) return QString("Err101");
val1=log10(val1);
return QString::number(val1);
};
if (function=="LOG")
{
// return the base-param2 logarithm of param1
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
if(val1<=0.0 || val2<=0.0 ) return QString("Err101");
val1=log(val1)/log(val2);
return QString::number(val1);
};
if (function=="MOD")
{
// return the modulus of param1/param2
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
if(val2==0.0) return QString("Err101");
val1=(int(val1) % int(val2));
return QString::number(val1);
};
if (function=="POWER")
{
// return the param1^param2
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
if(val1<0.0 && (floor(val2)!=val2)) return QString("Err101");
val1=pow(val1,val2);
return QString::number(val1);
};
if (function=="PI")
{
return QString::number(M_PI);
};
if (function=="RADIANS")
{
// param1 deg->rad
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok)*M_PI/180.0;
return QString::number(val1);
};
if (function=="RAND")
{
// retuns random number 0>x>1
srand((unsigned int)time((time_t *)NULL));
val1=double(rand())/double(RAND_MAX);
return QString::number(val1);
};
if (function=="RANDBETWEEN")
{
// returns random number between param1>x>param2
//TOFIX: this is not ok because I think results is always int related.
srand((unsigned int)time((time_t *)NULL));
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val1=fmod(double(rand()),(val2-val1))+val1;
return QString::number(val1);
};
if (function=="ROUND")
{
// rounds down param1 to specified digits param2 (positive decimal digits)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val2=pow(10.0,-val2);
val1=floor(val1/val2)*val2;
return QString::number(val1);
};
if (function=="SIGN")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
if(val1>=0.0) return QString::number(1.0); else return QString::number(-1.0);
};
if (function=="CHGSGN")//changes sign (for unary operator)
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
return QString::number((-1.0)*val1);
};
if (function=="SIN")
{
val1=sin(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="SINH")
{
val1=sinh(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="TAN")
{
val1=tan(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="TANH")
{
val1=tanh(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
if (function=="SQRT")
{
val1=sqrt(calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok));
return QString::number(val1);
};
// STRING FUNCTIONS
if (function=="CONCATENATE")
{
// concatenates strings together
w1=0;
s1="";
while(getParameter(parameters, w1, FALSE, function)!="") //parse all params;
{
s1=s1+calculateVariable(getParameter(parameters, w1));
w1++;
};
return QString(s1);
};
if (function=="EXACT")
{
// compare two string if they are exactly the same
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
s2=calculateVariable(getParameter(parameters, 1, TRUE, function));
if(s1==s2) return QString::number(1); else return QString::number(0);
};
if (function=="FIND")
{
// finds param1 in param2 from pos param3 and after
// returns -1 if not found
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
s2=calculateVariable(getParameter(parameters, 1, TRUE, function));
vali=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
val1=s2.find(s1,vali);
return QString::number(val1);
};
if (function=="LEFT")
{
// returns the param2 left chars from param1 string
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
s2=s1.left(vali);
return QString(s2);
};
if (function=="LEN")
{
// return the length of a string(param1)
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
return QString::number(s1.length());
};
if (function=="MID")
{
// returns the mid word of string param1 with start param2 and len param3
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
w1=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
w2=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
s2=s1.mid(w1,w2);
return QString(s2);
};
if (function=="REPLACE")
{
//replace in param1 text in pos param2 and length param3 to newtext param4
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
w1=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
w2=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
s2=calculateVariable(getParameter(parameters, 3, TRUE, function));
if(w1<0 || w2<0) return QString(s1);
s1=s1.left(w2-1)+s2+s1.right(s1.length()-w1-w2);
return QString(s1);
};
if (function=="REPT")
{
//repeats param1 string param2 times
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
w1=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
for(w2=1;w2<=w1;w2++)
{
s2=s2.append(s1);
};
return QString(s2);
};
if (function=="RIGHT")
{
// returns the param2 right chars from param1 string
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
s2=s1.right(vali);
return QString(s2);
};
if (function=="UPPER")
{
// returns the upper param1 string
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
s1=s1.upper();
return QString(s1);
};
if (function=="LOWER")
{
// returns the lower param1 string
s1=calculateVariable(getParameter(parameters, 0, TRUE, function));
s1=s1.lower();
return QString(s1);
};
if (function=="IF")
{
//usage: IF(param1,param2,param3)
//returns param4 if true(param1)/ param5 if false(param1)
val1=getParameter(parameters, 0, TRUE, function).toDouble(&ok);
if(val1==1.0)
{
s1=calculateVariable(getParameter(parameters, 1, TRUE, function));
return QString(s1);
- }else
+ }
+ else
{
s1=calculateVariable(getParameter(parameters, 2, TRUE, function));
return QString(s1);
};
};
if (function=="SUM")
{
//NumOfParams
val2=0.0;
for(w1=1;w1<=(NumOfParams/2);w1++)
{
val1=functionSum(getParameter(parameters, (w1-1)*2, FALSE, function), getParameter(parameters, (w1-1)*2+1, TRUE, function));
val2=val2+val1;
};
if(NumOfParams%2==1)
{
val2=val2+calculateVariable(getParameter(parameters,NumOfParams-1,FALSE, function)).toDouble(&ok);
};
return QString::number(val2);
};
if (function=="INDEX")
{
s1=functionIndex(getParameter(parameters,0,TRUE,function), getParameter(parameters, 1, TRUE, function), getParameter(parameters,2,TRUE,function).toInt(&ok));
return QString(s1);
};
if (function=="SUMSQ")
{
//NumOfParams
val2=0.0;
for(w1=1;w1<=(NumOfParams/2);w1++)
{
val1=functionSumSQ(getParameter(parameters, (w1-1)*2, FALSE, function), getParameter(parameters, (w1-1)*2+1, TRUE, function));
val2=val2+val1;
};
if(NumOfParams%2==1)
{
val1=calculateVariable(getParameter(parameters,NumOfParams-1,FALSE, function)).toDouble(&ok);
val2=val2+val1*val1;
};
return QString::number(val2);
};
if (function=="COUNT")
{
//NumOfParams
val2=0.0;
for(w1=1;w1<=(NumOfParams/2);w1++)
{
val1=functionCount(getParameter(parameters, (w1-1)*2, FALSE, function), getParameter(parameters, (w1-1)*2+1, TRUE, function));
val2=val2+val1;
};
if(NumOfParams%2==1)
{
val1=calculateVariable(getParameter(parameters,NumOfParams-1,FALSE, function)).toDouble(&ok);
if(ok) val2=val2+1;
};
return QString::number(val2);
};
if (function=="COUNTIF")
{
//NumOfParams
val1=functionCountIf(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function), getParameter(parameters, 2, TRUE, function));
return QString::number(val1);
};
if (function=="MIN")
{
//NumOfParams
val2=0.0;
for(w1=1;w1<=(NumOfParams/2);w1++)
{
val1=functionMin(getParameter(parameters, (w1-1)*2, FALSE, function), getParameter(parameters, (w1-1)*2+1, TRUE, function));
val2=val1;
};
if(NumOfParams%2==1)
{
val1=calculateVariable(getParameter(parameters,NumOfParams-1,FALSE, function)).toDouble(&ok);
if(val1<val2) val2=val1;
};
return QString::number(val2);
};
if (function=="MAX")
{
//NumOfParams
val2=0.0;
for(w1=1;w1<=(NumOfParams/2);w1++)
{
val1=functionMax(getParameter(parameters, (w1-1)*2, FALSE, function), getParameter(parameters, (w1-1)*2+1, TRUE, function));
val2=val1;
};
if(NumOfParams%2==1)
{
val1=calculateVariable(getParameter(parameters,NumOfParams-1,FALSE, function)).toDouble(&ok);
if(val1>val2) val2=val1;
};
return QString::number(val2);
};
if (function=="AVERAGE")
{
val1=functionAvg(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
return QString::number(val1);
};
if(function=="BESSELI")
{
// BesselI (x,n)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
val2=BesselI(vali,val1);
return QString::number(val2);
};
if(function=="BESSELJ")
{
// BesselJ (x,n)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
val2=BesselJ(vali,val1);
return QString::number(val2);
};
if(function=="BESSELK")
{
// BesselK (x,n)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
val2=BesselK(vali,val1);
return QString::number(val2);
};
if(function=="BESSELY")
{
// BesselY (x,n)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
val2=BesselY(vali,val1);
return QString::number(val2);
};
if(function=="GAMMALN")
{
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=GammaLn(val1);
return QString::number(val2);
};
if(function=="ERF")
{
// ERF (a,b)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
return QString::number(ErrorFunction(val2)-ErrorFunction(val1));
};
if(function=="ERFC")
{
// ERFC (a,b)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
return QString::number(ErrorFunctionComplementary(val2)-ErrorFunctionComplementary(val1));
};
if(function=="POISSON")
{
// POISSON DISTR(x,n,distr/desnt)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
if(vali==1)
{
return QString::number(GammaQ(floor(val1)+1, val2));
- }else
+ }
+ else
{
return QString::number(exp(-val2)*pow(val2,val1)/exp(GammaLn(val1+1.0)));
};
};
if(function=="CHIDIST")
{
// POISSON CHIDIST(x,n,distr/density)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
if(vali==1)
{
return QString::number(GammaP(val2/2.0,val1*val1/2.0));
- } else
+ }
+ else
{
return QString::number(
pow(val1,val2-1.0)*exp(-val1*val1/2)/ ( pow(2,val2/2.0-1.0)*exp(GammaLn(val2/2.0)))
);
};
};
if(function=="CHI2DIST")
{
// POISSON CHISQUAREDIST(x,n,distr/density)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 2, TRUE, function)).toInt(&ok);
if(vali==1)
{
return QString::number(GammaP(val2/2.0,val1/2.0));
- } else
+ }
+ else
{
return QString::number(
pow(val1,val2/2.0-1.0)/(exp(val1/2.0)*pow(sqrt(2.0),val2)*exp(GammaLn(val2/2.0)))
);
};
};
if(function=="BETAI")
{
// BETA INCOMPLETE BETA(x,a,b)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val3=calculateVariable(getParameter(parameters, 2, TRUE, function)).toDouble(&ok);
return QString::number(BetaIncomplete(val2,val3,val1));
};
if(function=="GAMMAP")
{
// GammaP (x,a)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
return QString::number(GammaP(val2,val1));
};
if(function=="GAMMAQ")
{
// GammaQ (x,a)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
return QString::number(GammaQ(val2,val1));
};
if (function=="VAR")
{
val1=functionVariance(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
return QString::number(val1);
};
if (function=="VARP")
{
val1=functionVariancePopulation(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
return QString::number(val1);
};
if (function=="STDEV")
{
val1=functionVariance(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if(val1<=0.0) return QString::number(0.0);
return QString::number(sqrt(val1));
};
if (function=="STDEVP")
{
val1=functionVariancePopulation(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
if(val1<=0.0) return QString::number(0.0);
return QString::number(sqrt(val1));
};
if (function=="SKEW")
{
val1=functionSkew(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
return QString::number(val1);
};
if (function=="KURT")
{
val1=functionKurt(getParameter(parameters, 0, TRUE, function), getParameter(parameters, 1, TRUE, function));
return QString::number(val1);
};
if(function=="GAMMADIST")
{
// GAMMADIST (x,alpha,beta,distribution?density1:0)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val3=calculateVariable(getParameter(parameters, 2, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 3, TRUE, function)).toInt(&ok);
if(vali==1)//distribution
{
if(val3==0.0) return QString::number(0.0);
else
return QString::number(GammaP(val2,val1/val3));
}else //density
{
return QString::number(
pow(val1,val2-1.0)*exp(-val1/val3) / (pow(val3,val2)*exp(GammaLn(val2)))
);
};
};
if(function=="BETADIST")
{
// BETADIST (z,alpha,beta,distribution?density1:0)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val3=calculateVariable(getParameter(parameters, 2, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 3, TRUE, function)).toInt(&ok);
if(vali==1)//distribution
{
return QString::number(BetaIncomplete(val2,val3,val1));
}else //density
{
return QString::number(
pow(val1,val2-1.0)*pow(1.0-val1,val3-1.0) / Beta(val2,val3)
);
};
};
if(function=="FDIST")
{
// FDIST (z,d1,d2,distribution?density1:0)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val3=calculateVariable(getParameter(parameters, 2, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 3, TRUE, function)).toInt(&ok);
if(vali==1)//distribution
{
return QString::number(
-BetaIncomplete(val3/2,val2/2,val3/(val3+val2*val1))
+BetaIncomplete(val3/2,val2/2,1)
);
}else //density
{
return QString::number(
pow(val2,val2/2)*pow(val3,val3/2)*pow(val1,val2/2-1)/
(pow(val3+val2*val1,(val2+val3)/2)*Beta(val2/2,val3/2))
);
};
};
if(function=="NORMALDIST")
{
// NORMALDIST (x,m,s,distribution?density1:0)
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
val2=calculateVariable(getParameter(parameters, 1, TRUE, function)).toDouble(&ok);
val3=calculateVariable(getParameter(parameters, 2, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 3, TRUE, function)).toInt(&ok);
if(vali==1)//distribution
{
return QString::number(
(ErrorFunction((val1-val2)/(sqrt(2)*val3))+1)/2.0
);
}else //density
{
return QString::number(
exp(-pow(((val1-val2)/val3),2)/2)/(val3*sqrt(2*M_PI))
);
};
};
if(function=="PHI")
{
// NORMALDIST (x,distribution?density1:0) with mean=0 s=1.0
val1=calculateVariable(getParameter(parameters, 0, TRUE, function)).toDouble(&ok);
vali=calculateVariable(getParameter(parameters, 1, TRUE, function)).toInt(&ok);
if(vali==1)//distribution
{
return QString::number(
(ErrorFunction(val1/(sqrt(2)))+1)/2.0
);
}else //density
{
return QString::number(
exp(-pow(val1,2)/2)/(sqrt(2*M_PI))
);
};
};
/*
StudentTDistribution/: PDF[StudentTDistribution[n_], x_] :=
1/(Sqrt[n] Beta[n/2, 1/2]) Sqrt[n/(n+x^2)]^(n+1) /;
ParameterQ[StudentTDistribution[n]]
StudentTDistribution/: CDF[StudentTDistribution[n_], x_] :=
(1 + Sign[x] BetaRegularized[n/(n+x^2), 1, n/2, 1/2])/2 /;
ParameterQ[StudentTDistribution[n]]
*/
return 0;
};
QString Sheet::dataParserHelper(const QString &data)
{
if(data.left(1)=="""" && data.right(1)=="""") return QString(data);
Expression exp1(data);
exp1.Parse();
QStack<QString> stack1;
stack1.setAutoDelete(TRUE);
int i=0;
QString* s1;
QString* s2=NULL;
int* i1;
int args,tokentype;
QString tempval;
s1=exp1.CompiledBody.first();i1=exp1.CompiledBodyType.first();
while(i<=(int)exp1.CompiledBody.count()-1)
{
args= ((*i1) & 0xFF00)>>8; tokentype=(*i1) & 0x00FF;
if(tokentype==NUMBER_TOKEN)
{
stack1.push(new QString(*s1));
//printf("Parse:Number=%s\r\n",s1->latin1());
@@ -2196,371 +2243,372 @@ void Sheet::insertRows(int no, bool allColumns)
void Sheet::insertColumns(int no, bool allRows)
{
int noCols=numCols();
int newCols=noCols+no;
setNumCols(newCols);
for (int i=noCols; i<newCols; ++i)
horizontalHeader()->setLabel(i, getHeaderString(i+1), DEFAULT_COL_WIDTH);
typeCellData *tempCellData;
int col=currentColumn(), row=currentRow();
for (tempCellData=sheetData.first(); tempCellData; tempCellData=sheetData.next())
if (tempCellData->col>=col && (allRows || tempCellData->row==row))
{
clearCell(tempCellData->row, tempCellData->col);
tempCellData->col+=no;
}
for (tempCellData=sheetData.first(); tempCellData; tempCellData=sheetData.next())
if (tempCellData->col>=col && (allRows || tempCellData->row==row))
{
updateCell(tempCellData->row, tempCellData->col-no);
setText(tempCellData->row, tempCellData->col, dataParser(findCellName(tempCellData->row, tempCellData->col), tempCellData->data));
}
emit sheetModified();
}
void Sheet::dataFindReplace(const QString &findStr, const QString &replaceStr, bool matchCase, bool allCells, bool entireCell, bool replace, bool replaceAll)
{
typeCellData *tempCellData;
int row1, col1, row2, col2;
getSelection(&row1, &col1, &row2, &col2);
bool found=FALSE;
for (tempCellData=sheetData.first(); tempCellData; tempCellData=sheetData.next())
if (allCells || (tempCellData->row>=row1 && tempCellData->row<=row2 && tempCellData->col>=col1 && tempCellData->col<=col2))
{
QTableItem *cellItem=item(tempCellData->row, tempCellData->col);
if (cellItem && (entireCell ? (matchCase ? cellItem->text()==findStr : cellItem->text().upper()==findStr.upper()) : cellItem->text().find(findStr, 0, matchCase)>=0))
{
if (!found)
{
found=TRUE;
clearSelection();
}
setCurrentCell(tempCellData->row, tempCellData->col);
if (replace)
{
tempCellData->data=cellItem->text().replace(QRegExp(findStr, matchCase), replaceStr);
setText(tempCellData->row, tempCellData->col, dataParser(findCellName(tempCellData->row, tempCellData->col), tempCellData->data));
}
if (!replace || !replaceAll) break;
}
}
if (found)
{
if (replace)
slotCellChanged(currentRow(), currentColumn());
}
else
QMessageBox::warning(this, tr("Error"), tr("Search key not found!"));
}
//
// Static functions
//
QString Sheet::getHeaderString(int section)
{
if (section<1) return "";
return getHeaderString((section-1)/26)+QChar('A'+(section-1)%26);
}
int Sheet::getHeaderColumn(const QString &section)
{
if (section.isEmpty()) return 0;
return (section[section.length()-1]-'A'+1)+getHeaderColumn(section.left(section.length()-1))*26;
}
//Expression Parser Class Definition
QChar Expression::chunk0(void)
{
if(chunk.length()>0) return(chunk[0]); else return('\0');
};
Expression::Expression(QString expr1)// constructor
{
Body=expr1;
SYMBOL="+-*/%^=()<>&|!,";
MATHSYMBOL="+-*/%^=<>&|!,";
// lnlim=1.0e-36; // Smallest number allowed
// loglim=1.0e-10 ; // Smallest number allowed in call to log10() *
ErrorFound=TRUE;
n=0;chunk="";SymbGroup=NONE_TOKEN;InExpr=Body;
ArgsOfFunc=0;
CompiledBody.setAutoDelete(TRUE);
CompiledBodyType.setAutoDelete(TRUE);
//CompiledBody=QStringList(0);
};
bool Expression::isSymbol(QChar ch)
{
int j = 0;
while (j<=((int)SYMBOL.length()-1) && ch!=SYMBOL[j]) j++;
if(j<((int)SYMBOL.length())) return true; else return false;
};
bool Expression::isMathSymbol(QChar ch)
{
int j = 0;
while (j<=((int)MATHSYMBOL.length()-1) && ch!=MATHSYMBOL[j]) j++;
if(j<((int)MATHSYMBOL.length())) return true; else return false;
};
void Expression::GetNext()
{
chunk="";
if(n>=(int)InExpr.length()) return;
while (InExpr[n]==' ') n++;
if(InExpr[n]=='\"')
{
while ( (n<(int)InExpr.length()) && (InExpr[n+1]!='\"') )
{
printf("chunk=%s\r\n",chunk.latin1());
chunk+=InExpr[n];
n++;
};
chunk+=InExpr[n];
printf("2\r\n");
SymbGroup=STRING_TOKEN;
}
else if (isSymbol(InExpr[n]))
{
SymbGroup=SYMBOL_TOKEN;
chunk+=InExpr[n];
n++;
if( (n<(int)InExpr.length()) &&
isMathSymbol(InExpr[n-1]) &&
isMathSymbol(InExpr[n]) )
{
SymbGroup=SYMBOL_TOKEN;
chunk+=InExpr[n];
n++;
};
}
else if ((InExpr[n].isLetter())||(InExpr[n]=='#'))
{
while ( (n<(int)InExpr.length()) && !isSymbol(InExpr[n]) )
{
if (!(InExpr[n]==' ')) chunk+=InExpr[n];
n++;
};
if (InExpr[n]=='(') SymbGroup=FUNCTION_TOKEN; // function TOKEN
else SymbGroup=VARIABLE_TOKEN;
}
else if((n<(int)InExpr.length()) &&
((InExpr[n].isDigit()) || (InExpr[n]=='.')))
{
while( n<(int)InExpr.length() )
{
if((InExpr[n].isDigit()) || InExpr[n]=='.')
{
chunk+=InExpr[n];
SymbGroup=NUMBER_TOKEN;
n++;
}
else if(InExpr[n]=='e')
{
if((n+1)<(int)InExpr.length())
{
if(InExpr[n+1]=='-' || InExpr[n+1]=='+' || InExpr[n+1].isDigit())
{
chunk+=InExpr[n];
chunk+=InExpr[n+1];
SymbGroup=NUMBER_TOKEN;
n+=2;
}
}
else
{
break;
}
}
else
{
break;
}
}//while
}//else if
-};//end function
+}
+;//end function
void Expression::First()
{
GetNext();
if (!(chunk=="") && !ErrorFound) Third();
else ErrorFound = true;
};
void Expression::Third()
{
QChar sign, secS='\0';
Fourth();
sign = chunk0();
if((int)chunk.length()>1) secS=chunk[1];
while( sign == '+' || sign == '-'||
sign == '<' || sign == '>'|| sign == '%'||
sign == '&' || sign == '|' || sign == '!' || sign == '='
)
{
GetNext();
Fourth();
QString name;
if( sign == '+' ) name= "+" ;
else if(sign=='-') name= "-" ;
else if(sign=='>' && secS=='\0') name= ">" ;
else if(sign=='<' && secS=='\0') name= "<" ;
else if(sign=='=' && secS=='=') name= "==" ;
else if(sign=='!' && secS=='=') name= "!=" ;
else if(sign=='>' && secS=='=') name= ">=" ;
else if(sign=='<' && secS=='=') name= "<=" ;
else if(sign=='&' && secS=='&') name= "AND" ;
else if(sign=='|' && secS=='|') name= "OR" ;
else if(sign=='%') name= "MOD" ;
CompiledBody.append(new QString(name)); // not sure if pushed in the back.
CompiledBodyType.append(new int(FUNCTION_TOKEN | 2<<8)); //2 argument functions
sign = chunk0();
}
};
void Expression::Fourth()
{
QChar sign;
Fifth();
sign = chunk0();
while( sign == '*' || sign == '/' )
{
GetNext();
Fifth();
QString name;
if( sign == '*' ) name= "*" ;
else name= "/" ;
CompiledBody.append(new QString(name));
CompiledBodyType.append(new int(FUNCTION_TOKEN | 2<<8)); //2 arguments functions
sign = chunk0();
}
};
void Expression::Fifth()
{
Sixth();
//if(chunk.Length==0) return;
if( chunk0() == '^' )
{
GetNext();
Fifth();
CompiledBody.append(new QString("POWER"));
CompiledBodyType.append(new int(FUNCTION_TOKEN | 2<<8)); // 2 argument functions
}
};
void Expression::Sixth()
{
char sign;
sign = ' ';
if(SymbGroup== SYMBOL_TOKEN &&
chunk0() == '+' || chunk0() == '-' | chunk0() == '!')
{
sign = chunk0();
GetNext();
}
Seventh();
if( sign == '-' )
{
CompiledBody.append(new QString("CHGSGN")); // unary minus
CompiledBodyType.append(new int(FUNCTION_TOKEN | 1<<8)); //1 argument
}
if( sign == '!' )
{
CompiledBody.append(new QString("NOT")); // unary minus
CompiledBodyType.append(new int(FUNCTION_TOKEN | 1<<8)); //1 argument
}
};
void Expression::Seventh()
{
if( chunk0() == '(' && SymbGroup==SYMBOL_TOKEN)
{
GetNext();
Third(); //parse the insides until we get a ')'
if (chunk0() != ')') ErrorFound = true;
GetNext();
}
else Eighth();
};
void Expression::Eighth()
{
if ( SymbGroup== NUMBER_TOKEN )
{
CompiledBody.append(new QString(chunk));
CompiledBodyType.append(new int(NUMBER_TOKEN));
GetNext();
}
else if ( SymbGroup== VARIABLE_TOKEN )
{
CompiledBody.append(new QString(chunk));
CompiledBodyType.append(new int(VARIABLE_TOKEN));
GetNext();
}
else if (SymbGroup== STRING_TOKEN )
{
CompiledBody.append(new QString(chunk+QString("\"")));
CompiledBodyType.append(new int(STRING_TOKEN));
GetNext();
}
else Ninth();
};
void Expression::Ninth()
{
if ( SymbGroup== FUNCTION_TOKEN )
{
QString TempFunk = chunk ;
GetNext();
if(chunk0() == '(' )
{
FuncDepth++;
ArgsOfFunc.resize(FuncDepth+1);
ArgsOfFunc[FuncDepth]=1;
//ArgsOfFunc=1;
GetNext();
Third();
while(chunk0()==',') //function arguments separator
{
//ArgsOfFunc++;
ArgsOfFunc[FuncDepth]++;
GetNext();
Third();
};
if (chunk0() != ')') ErrorFound = true;
CompiledBody.append(new QString(TempFunk));
if (TempFunk=="PI") ArgsOfFunc[FuncDepth]=0;
// couldn't find a better way to parse function PI() with 0 args. :)
CompiledBodyType.append(new int(FUNCTION_TOKEN | (ArgsOfFunc[FuncDepth]<<8) ));
//the mask &FF00 gives the arguments of the functions passed.
FuncDepth--;
ArgsOfFunc.resize(FuncDepth+1);
GetNext();
}
}
else
ErrorFound = true;
};
bool Expression::Parse()
{
CompiledBody.clear();
ErrorFound = false;
n = 0;ArgsOfFunc.resize(0);FuncDepth=0;
InExpr=Body;
First();
return(!ErrorFound);
};
diff --git a/noncore/apps/opie-sheet/sheet.h b/noncore/apps/opie-sheet/sheet.h
index f705cd0..92c8061 100644
--- a/noncore/apps/opie-sheet/sheet.h
+++ b/noncore/apps/opie-sheet/sheet.h
@@ -1,209 +1,229 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef SHEET_H
#define SHEET_H
+/* QT */
#include <qtable.h>
#include <qstack.h>
typedef struct typeCellBorders
{
QPen right, bottom;
};
typedef struct typeCellData
{
int col, row;
typeCellBorders borders;
QBrush background;
Qt::AlignmentFlags alignment;
QColor fontColor;
QFont font;
QString data;
};
#define NONE_TOKEN 0
#define NUMBER_TOKEN 1
#define VARIABLE_TOKEN 2
#define FUNCTION_TOKEN 3
#define SYMBOL_TOKEN 4
#define STRING_TOKEN 5
class Expression
{
public:
QString Body;
QList<QString> CompiledBody;
QList<int> CompiledBodyType;
QString SYMBOL;
QString MATHSYMBOL;
QArray<int> ArgsOfFunc;
int FuncDepth;
bool ErrorFound;
int n; // holds the current parser position
QString chunk; // the piece in the parser we are on
int SymbGroup; // the current type
QString InExpr;
QChar chunk0(void); // retunrs the first char of expression;
Expression(QString expr1);// constructor
bool isSymbol(QChar ch);
bool isMathSymbol(QChar ch);
void GetNext();
void First();
void Third();
void Fourth();
void Fifth();
void Sixth();
void Seventh();
void Eighth();
void Ninth();
bool Expression::Parse(); //parses the expression in RPN format;
};
class Sheet: public QTable
{
Q_OBJECT
// Variables
bool clicksLocked;
int selectionNo;
typeCellBorders defaultBorders;
typeCellData defaultCellData;
// QT objects
QList<typeCellData> sheetData, clipboardData;
QString pressedCell, releasedCell, sheetName;
QStringList listDataParser;
// Private functions
bool findRowColumn(const QString &variable, int *row, int *col, bool giveError=FALSE);
QString findCellName(int row, int col);
bool findRange(const QString &variable1, const QString &variable2, int *row1, int *col1, int *row2, int *col2);
QString calculateVariable(const QString &variable);
QString calculateFunction(const QString &func, const QString &parameters, int NumOfParams);
QString getParameter(const QString &parameters, int paramNo, bool giveError=FALSE, const QString funcName="");
QString dataParser(const QString &cell, const QString &data);
QString dataParserHelper(const QString &data);
typeCellData *createCellData(int row, int col);
typeCellData *findCellData(int row, int col);
//LOGICAL / INFO
double functionCountIf(const QString &param1, const QString &param2, const QString &param3);
double functionSumSQ(const QString &param1, const QString &param2); //sum of squares
QString functionIndex(const QString &param1, const QString &param2, int indx);
//math functions computations
double BesselI0(double x);
double BesselI(int n, double x);
double BesselK0(double x);
double BesselI1(double x);
double BesselK1(double x);
double BesselK(int n, double x);
double BesselJ0(double x);
double BesselY0(double x);
double BesselJ1(double x);
double BesselY1(double x);
double BesselY(int n, double x);
double BesselJ(int n, double x);
double GammaLn(double xx);
double Factorial(double n);
double GammaP(double a, double x);
double GammaQ(double a,double x);
void GammaSeries(double *gamser, double a, double x, double *gln);
void GammaContinuedFraction(double *gammcf, double a, double x, double *gln);
double ErrorFunction(double x);
double ErrorFunctionComplementary(double x);
double Beta(double z, double w);
double BetaContinuedFraction(double a, double b, double x);
double BetaIncomplete(double a, double b, double x);
double functionVariance(const QString &param1, const QString &param2);
double functionVariancePopulation(const QString &param1, const QString &param2);
double functionSkew(const QString &param1, const QString &param2);
double functionKurt(const QString &param1, const QString &param2);
// Sheet/Qt parser functions
double functionSum(const QString &param1, const QString &param2);
double functionAvg(const QString &param1, const QString &param2);
double functionMax(const QString &param1, const QString &param2);
double functionMin(const QString &param1, const QString &param2);
double functionCount(const QString &param1, const QString &param2);
// Reimplemented QTable functions
void paintCell(QPainter *p, int row, int col, const QRect & cr, bool selected);
void viewportMousePressEvent(QMouseEvent *e);
void viewportMouseMoveEvent(QMouseEvent *e);
void viewportMouseReleaseEvent(QMouseEvent *e);
public slots:
void slotCellSelected(int row, int col);
void slotCellChanged(int row, int col);
public:
Sheet(int numRows, int numCols, QWidget *parent);
~Sheet();
void ReCalc(void);
void setData(const QString &data);
QString getData();
void setName(const QString &data);
QString getName();
void setPen(int row, int col, int vertical, const QPen &pen);
QPen getPen(int row, int col, int vertical);
void setBrush(int row, int col, const QBrush &brush);
QBrush getBrush(int row, int col);
void setTextAlign(int row, int col, Qt::AlignmentFlags flags);
Qt::AlignmentFlags getAlignment(int row, int col);
void setTextFont(int row, int col, const QFont &font, const QColor &color);
QFont getFont(int row, int col);
QColor getFontColor(int row, int col);
void lockClicks(bool lock=TRUE);
void copySheetData(QList<typeCellData> *destSheetData);
void setSheetData(QList<typeCellData> *srcSheetData);
void getSelection(int *row1, int *col1, int *row2, int *col2);
void insertRows(int no=1, bool allColumns=TRUE);
void insertColumns(int no=1, bool allRows=TRUE);
void dataFindReplace(const QString &find, const QString &replace, bool matchCase=TRUE, bool allCells=TRUE, bool entireCell=FALSE, bool replace=FALSE, bool replaceAll=FALSE);
// Static functions
static int getHeaderColumn(const QString &section);
static QString getHeaderString(int section);
public slots:
void editCut();
void editCopy();
void editPaste(bool onlyContents=FALSE);
void editClear();
void swapCells(int row1, int col1, int row2, int col2);
signals:
void currentDataChanged(const QString &data);
void cellClicked(const QString &cell);
void sheetModified();
};
diff --git a/noncore/apps/opie-sheet/sortdlg.cpp b/noncore/apps/opie-sheet/sortdlg.cpp
index c2cdec8..47d666f 100644
--- a/noncore/apps/opie-sheet/sortdlg.cpp
+++ b/noncore/apps/opie-sheet/sortdlg.cpp
@@ -1,193 +1,213 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
+#include "sortdlg.h"
+
+/* QT */
#include <qlabel.h>
#include <qradiobutton.h>
#include <qmessagebox.h>
-#include "sortdlg.h"
SortDialog::SortDialog(QWidget *parent)
:QDialog(parent, 0, TRUE)
{
// Main widget
tabs=new QTabWidget(this);
widgetSort=new QWidget(tabs);
widgetOptions=new QWidget(tabs);
tabs->addTab(widgetSort, tr("&Sort"));
tabs->addTab(widgetOptions, tr("&Options"));
// Sort tab
comboFieldA=createFieldCombo(tr("&Sort by"), 10);
groupOrderA=createOrderButtons(10);
comboFieldB=createFieldCombo(tr("&Then by"), 90);
groupOrderB=createOrderButtons(90);
comboFieldC=createFieldCombo(tr("Then &by"), 170);
groupOrderC=createOrderButtons(170);
// Options tab
checkCase=new QCheckBox(tr("&Case Sensitive"), widgetOptions);
checkCase->setGeometry(10, 10, 215, 20);
checkCase->setChecked(TRUE);
groupDirection=new QVButtonGroup(tr("&Direction"), widgetOptions);
groupDirection->setGeometry(10, 40, 215, 70);
QRadioButton *radio=new QRadioButton(tr("&Top to bottom (rows)"), groupDirection);
radio=new QRadioButton(tr("&Left to right (columns)"), groupDirection);
groupDirection->setButton(0);
connect(groupDirection, SIGNAL(clicked(int)), this, SLOT(directionChanged(int)));
// Main widget
box=new QVBoxLayout(this);
box->addWidget(tabs);
setCaption(tr("Sort"));
}
SortDialog::~SortDialog()
-{
-}
+{}
QComboBox *SortDialog::createFieldCombo(const QString &caption, int y)
{
QLabel *label=new QLabel(caption, widgetSort);
label->setGeometry(10, y+5, 215, 20);
QComboBox *combo=new QComboBox(FALSE, widgetSort);
combo->setGeometry(10, y+35, 105, 20);
label->setBuddy(combo);
return combo;
}
QVButtonGroup *SortDialog::createOrderButtons(int y)
{
QVButtonGroup *group=new QVButtonGroup(widgetSort);
group->setGeometry(125, y, 100, 60);
QRadioButton *radio=new QRadioButton(tr("&Ascending"), group);
radio=new QRadioButton(tr("&Descending"), group);
group->setButton(0);
return group;
}
void SortDialog::directionChanged(int id)
{
direction=id;
fillFieldCombo(comboFieldA);
fillFieldCombo(comboFieldB);
fillFieldCombo(comboFieldC);
}
void SortDialog::fillFieldCombo(QComboBox *combo)
{
combo->clear();
if (direction)
for (int row=row1; row<=row2; ++row)
combo->insertItem("Row "+QString::number(row+1));
else
for (int col=col1; col<=col2; ++col)
combo->insertItem("Column "+Sheet::getHeaderString(col+1));
}
int SortDialog::exec(Sheet *s)
{
sheet=s;
sheet->getSelection(&row1, &col1, &row2, &col2);
direction=0;
fillFieldCombo(comboFieldA);
fillFieldCombo(comboFieldB);
fillFieldCombo(comboFieldC);
if (row1==row2 && col1==col2)
{
QMessageBox::warning(this, tr("Error"), tr("One cell cannot be sorted!"));
return QDialog::Rejected;
}
if (QDialog::exec()==QDialog::Accepted)
{
QString field1S=comboFieldA->currentText(), field2S=comboFieldB->currentText(), field3S=comboFieldC->currentText();
field1S=field1S.mid(field1S.find(' ')+1);
field2S=field2S.mid(field2S.find(' ')+1);
field3S=field3S.mid(field3S.find(' ')+1);
int field1, field2, field3;
if (direction)
{
field1=field1S.toInt()-1;
field2=field2S.toInt()-1;
field3=field3S.toInt()-1;
int i, j;
for (i=col2; i>=col1; --i)
for (j=col1+1; j<=i; ++j)
{
bool swap=FALSE;
int compareResult=compareItems(s->item(field1, j-1), s->item(field1, j), groupOrderA->id(groupOrderA->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(field2, j-1), s->item(field2, j), groupOrderB->id(groupOrderB->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(field3, j-1), s->item(field3, j), groupOrderC->id(groupOrderC->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
}
}
if (swap)
for (int row=row1; row<=row2; ++row)
s->swapCells(row, j-1, row, j);
}
}
else
{
field1=Sheet::getHeaderColumn(field1S)-1;
field2=Sheet::getHeaderColumn(field2S)-1;
field3=Sheet::getHeaderColumn(field3S)-1;
int i, j;
for (i=row2; i>=row1; --i)
for (j=row1+1; j<=i; ++j)
{
bool swap=FALSE;
int compareResult=compareItems(s->item(j-1, field1), s->item(j, field1), groupOrderA->id(groupOrderA->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(j-1, field2), s->item(j, field2), groupOrderB->id(groupOrderB->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
else if (compareResult==0)
{
compareResult=compareItems(s->item(j-1, field3), s->item(j, field3), groupOrderC->id(groupOrderC->selected()), checkCase->isChecked());
if (compareResult>0) swap=TRUE;
}
}
if (swap)
for (int col=col1; col<=col2; ++col)
s->swapCells(j-1, col, j, col);
}
}
return QDialog::Accepted;
}
return QDialog::Rejected;
}
int SortDialog::compareItems(QTableItem *item1, QTableItem *item2,
int descending, bool caseSensitive)
{
int result=0;
if (item1)
{
if (item2) result=(caseSensitive ? item1->text().compare(item2->text()) : item1->text().upper().compare(item2->text().upper()));
else result=-1;
}
else
if (item2) result=1;
return (descending ? -result : result);
}
diff --git a/noncore/apps/opie-sheet/sortdlg.h b/noncore/apps/opie-sheet/sortdlg.h
index b3699a9..5a1025e 100644
--- a/noncore/apps/opie-sheet/sortdlg.h
+++ b/noncore/apps/opie-sheet/sortdlg.h
@@ -1,59 +1,80 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef SORTDLG_H
#define SORTDLG_H
+#include "sheet.h"
+
+/* QT */
#include <qdialog.h>
#include <qtabwidget.h>
#include <qlayout.h>
#include <qcombobox.h>
#include <qcheckbox.h>
#include <qpushbutton.h>
#include <qvbuttongroup.h>
-#include "sheet.h"
class SortDialog: public QDialog
{
Q_OBJECT
// QT objects
QBoxLayout *box;
QTabWidget *tabs;
QWidget *widgetSort, *widgetOptions;
QVButtonGroup *groupOrderA, *groupOrderB, *groupOrderC, *groupDirection;
QCheckBox *checkCase;
QComboBox *comboFieldA, *comboFieldB, *comboFieldC;
// Other objects & variables
int row1, col1, row2, col2, direction;
Sheet *sheet;
// Private functions
QVButtonGroup *createOrderButtons(int y);
QComboBox *createFieldCombo(const QString &caption, int y);
void fillFieldCombo(QComboBox *combo);
int compareItems(QTableItem *item1, QTableItem *item2, int descending=0, bool caseSensitive=TRUE);
private slots:
void directionChanged(int id);
public:
SortDialog(QWidget *parent=0);
~SortDialog();
int exec(Sheet *s);
};
#endif
diff --git a/noncore/apps/opie-sheet/textdlg.cpp b/noncore/apps/opie-sheet/textdlg.cpp
index 34cec29..020b9ae 100644
--- a/noncore/apps/opie-sheet/textdlg.cpp
+++ b/noncore/apps/opie-sheet/textdlg.cpp
@@ -1,47 +1,65 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#include "textdlg.h"
TextDialog::TextDialog(QWidget *parent)
:QDialog(parent, 0, TRUE)
{
edit=new QLineEdit(this);
edit->setGeometry(90, 10, 100, 25);
label=new QLabel(this);
label->setGeometry(10, 10, 70, 25);
label->setBuddy(edit);
resize(200, 45);
}
TextDialog::~TextDialog()
-{
-}
+{}
int TextDialog::exec(const QString &caption, const QString &text,
const QString &value)
{
setCaption(caption);
label->setText(text);
edit->setText(value);
return QDialog::exec();
}
QString TextDialog::getValue()
{
return edit->text();
}
diff --git a/noncore/apps/opie-sheet/textdlg.h b/noncore/apps/opie-sheet/textdlg.h
index 78ef580..d54da16 100644
--- a/noncore/apps/opie-sheet/textdlg.h
+++ b/noncore/apps/opie-sheet/textdlg.h
@@ -1,38 +1,58 @@
-/***************************************************************************
- * *
- * This program is free software; you can redistribute it and/or modify *
- * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License, or *
- * (at your option) any later version. *
- * *
- ***************************************************************************/
+/*
+ =. This file is part of the Opie Project
+ .=l. Copyright (C) 2004 Opie Developer Team <opie-devel@handhelds.org>
+ .>+-=
+ _;:, .> :=|. This program is free software; you can
+.> <`_, > . <= redistribute it and/or modify it under
+:`=1 )Y*s>-.-- : the terms of the GNU General Public
+.="- .-=="i, .._ License as published by the Free Software
+ - . .-<_> .<> Foundation; either version 2 of the License,
+ ._= =} : or (at your option) any later version.
+ .%`+i> _;_.
+ .i_,=:_. -<s. This program is distributed in the hope that
+ + . -:. = it will be useful, but WITHOUT ANY WARRANTY;
+ : .. .:, . . . without even the implied warranty of
+ =_ + =;=|` MERCHANTABILITY or FITNESS FOR A
+ _.=:. : :=>`: PARTICULAR PURPOSE. See the GNU
+..}^=.= = ; Library General Public License for more
+++= -. .` .: details.
+ : = ...= . :.=-
+ -. .:....=;==+<; You should have received a copy of the GNU
+ -_. . . )=. = Library General Public License along with
+ -- :-=` this library; see the file COPYING.LIB.
+ If not, write to the Free Software Foundation,
+ Inc., 59 Temple Place - Suite 330,
+ Boston, MA 02111-1307, USA.
+
+*/
/*
* Opie Sheet (formerly Sheet/Qt)
* by Serdar Ozler <sozler@sitebest.com>
*/
#ifndef TEXTDLG_H
#define TEXTDLG_H
+/* QT */
#include <qdialog.h>
#include <qlabel.h>
#include <qlineedit.h>
class TextDialog: public QDialog
{
Q_OBJECT
// QT objects
QLabel *label;
QLineEdit *edit;
public:
TextDialog(QWidget *parent=0);
~TextDialog();
int exec(const QString &caption, const QString &text, const QString &value="");
QString getValue();
};
#endif