Re: [Lazarus] fplazspreadsheet formula

2010-08-09 Thread Felipe Monteiro de Carvalho
More specifically, there are some cell address differences in the section: 3.3.4 Cell Addresses in BIFF8 -- Felipe Monteiro de Carvalho -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org

Re: [Lazarus] fplazspreadsheet formula

2010-08-07 Thread Bogusław Brandys
José Mejuto pisze: Hello Lazarus-List, Friday, August 6, 2010, 10:25:12 PM, you wrote: BB Is formula implemented in fpspreadsheet component ? I've tested BB excel8write and resulting xls file has missing all cells which should BB contain formulas. No, formulas are now under development. I

Re: [Lazarus] fplazspreadsheet formula

2010-08-07 Thread José Mejuto
Hello Lazarus-List, Saturday, August 7, 2010, 8:45:47 AM, you wrote: BB Maybe it's possible for xlsbiff8 to override WriteRPNFormula method ? BB IMHO I saw almost complete code commented in WriteFormula method but I BB don't follow it. That code is far, far away from functional, it can write a

Re: [Lazarus] fplazspreadsheet formula

2010-08-07 Thread Bogusław Brandys
José Mejuto pisze: Hello Lazarus-List, Saturday, August 7, 2010, 8:45:47 AM, you wrote: BB Maybe it's possible for xlsbiff8 to override WriteRPNFormula method ? BB IMHO I saw almost complete code commented in WriteFormula method but I BB don't follow it. That code is far, far away from

Re: [Lazarus] fplazspreadsheet formula

2010-08-07 Thread Andreas Schneider
On Sat, 07 Aug 2010 13:13:31 +0200, Bogusław Brandys bran...@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

Re: [Lazarus] fplazspreadsheet formula

2010-08-07 Thread Felipe Monteiro de Carvalho
Hello, If you have fpspreadsheet, then you already have the reverse engineered docs from OpenOffice. They should be in the directory fpspreadsheet/docs Or something similar. Basically just look in the docs for the appropriate formula changes between biff 5 and biff 8. The real formula format

[Lazarus] fplazspreadsheet formula

2010-08-06 Thread Bogusław Brandys
Hi Is formula implemented in fpspreadsheet component ? I've tested excel8write and resulting xls file has missing all cells which should contain formulas. Regards Boguslaw -- ___ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org

Re: [Lazarus] fplazspreadsheet formula

2010-08-06 Thread José Mejuto
Hello Lazarus-List, Friday, August 6, 2010, 10:25:12 PM, you wrote: BB Is formula implemented in fpspreadsheet component ? I've tested BB excel8write and resulting xls file has missing all cells which should BB contain formulas. No, formulas are now under development. I hope to start to test