On Sat, 07 Aug 2010 13:13:31 +0200, Bogusław Brandys <[email protected]> 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 -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
