https://issues.apache.org/bugzilla/show_bug.cgi?id=48404
--- Comment #2 from Vesa Akerman <[email protected]> 2009-12-21 00:39:48 UTC --- Thanks for the prompt reply. That's correct that the syntax I gave for the formula was wrong. I had namely opened the excel file with open office and copied the syntax from there to the bug message. You asked if I know any other than aggregate functions used in 3-D references. No, I don't. I am using POI in a project where we convert files from different (older) file formats into XML format. In testing I noticed that 3-D formulas gave wrong result. I reported this as a bug, because in POI website, in 'Formula support' under 'Supported Features' it says: 'References: single cell & area, 2D & 3D, relative & absolute'. I don't know if it is simple or difficult to recognize a 3-D reference. I think that POI should give anyway an error message, instead of giving erroneous 2-D reference. By the way, at the moment POI supports approximately 60 of the 346 functions implemented in Excel 2003. Do you know if there are any plans to add support to more functions? Thanks, Vesa -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
