[Lazarus] fplazspreadsheet formula

Andreas Schneider aksdb at gmx.de
Sat Aug 7 15:30:48 CEST 2010


On Sat, 07 Aug 2010 13:13:31 +0200, Bogusław Brandys <brandys at o2.pl>
wrote:
> Yes,I'm talking about code from xls5biff. I've put it into xls8biff and 
> it seems to work but in openoffice calc I see error 520 instead of 
> formula so evidently it need adjustment. What should I change ,maybe 
> tokens have  different hex values?
> What I need is simple formulas like =A1+B1 , =A1/D1 and =SUM(A1:A12), 
> RPN is not a problem.
> Currently I have to revert my code and use Excel automation class which 
> is not portable of course.
> 
> 
> Boguslaw

You should be able to find details about the formulas in the file format
specs from Microsoft:
http://www.microsoft.com/interop/docs/officebinaryformats.mspx

Alternatively your can use the reverse engineered specs from
OpenOffice.org:
http://sc.openoffice.org/excelfileformat.pdf




More information about the Lazarus mailing list