In as much as this relates to recalculating formulas on opening the sheet, no, this is not yet fixed.
I cant seem to replicate it ever :( However,Michal, hope you realise that poi does not have (yet) an inbuilt mechanism for recalculation formulas .. we depend on excel to make it happen. As far as localisation is concerned .. we only read and write in english. What this means is that an excel file, even if saved in polish version, will have its formulas printed in english using poi. To write formulas, you again need to specify them in java code using english. However, opening them in polish excel will display them in polish (theoretically :) regards - Avik Quoting "Andrew C. Oliver" <[EMAIL PROTECTED]>: > [EMAIL PROTECTED] wrote: > > Hello again, > > > > Thanks a lot for help with charts :) > > Next problem is there are some formulas on my sheet. > > When I change any cell value then save new workbook the formulas exist > but > > don't recalculate after changes and they alter the old values. > > This is a known bug. Avik has this been fixed? > > > > I use Polish version of Excel and syntax of the formulas here are > different > > than in English > > SUM(A4:A15) in English is translated to SUMA(A4:A15) > > IF(...) is translated to JEZELI(...) > > Can that cause problems? > > Unfortunately I have no idea. The formula parser expects english, so > when you WRITE formulas you must write them in english. When it reads > them out, they should also be in english. I would think it would be > fine as long as they resolve to the same binary tokens. If they are > different then that may be a problem. > > I'd be up to trying to help make this localizable once we've completed > formula support, but would consider it unwise until then. > > -Andy > > > > > > Regards, > > > > Michal Langner > > Informa sp. z o.o. > > [EMAIL PROTECTED] > > > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
