https://bz.apache.org/bugzilla/show_bug.cgi?id=62121
Nick Burch <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #9 from Nick Burch <[email protected]> --- Generally speaking, we try to have POI mimic Excel where practical/possible. We have special logic in the Date and Number formatting code, for example, to handle the edge cases where Excel and Java formatting rules differ. (At a cost of complexity and performance, sadly) As a first step here, it would be great if someone could create a small spreadsheet in Excel, with 3 columns: formula as text, formula, manually typed in number of what excel renders. Add in a bunch of rows for various power edge cases Second step - write a junit unit test that runs over that sample file, and checks where Apache POI differs from Excel Third step - write a patch to POI to get it to match Excel in all cases... Step #1 can be done by anyone - no POI experience needed, just Excel experience. Step #2 should be possible for anyone with some POI + junit user experience. #3 may or may not need extensive POI and/or Math skills, but we need people to tackle the easier #1 and #2 first before we can ponder proposed/actual fixes for 3! -- 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]
