https://issues.apache.org/bugzilla/show_bug.cgi?id=44636
--- Comment #4 from Josh Micich <[EMAIL PROTECTED]> 2008-03-19 14:05:35 PST --- (In reply to comment #2) I just tried the patch in 3.0.2-FINAL. Both the before and after behaviour was as noted above. I.E. it should work for you. Perhaps the observation of '#VALUE!' in the formula cells is due to my version of Excel. Which version are you using? Just for reference, can you describe more clearly what your Excel does with 'changed.xls'? My observation of Excel 2007 is: - The formulas all appear as '#VALUE!'. - The correct formula text is still visible in the formulas. - Pressing the <enter> key after selecting the formula causes it to evaluate properly. This action seems to translate the tRef PTGs into tRefV PTGs (observable after re-saving). (In reply to comment #3) > I should also point out that the problem is a bit tricky... > If you simplify that spreadsheet at all - remove a row or column for example - > the code works fine. That makes sense. The specific bug that this one-line-fix addresses is the loss of the ptg-class when translating a 'shared formula'. From what I remember on previous bugs (bug 44449), excel has a minimum number of rows before it will use a shared. I noticed a threshold of 6 but I'm not sure if that's universal. POI does not erroneously disturb the ptg-class when reading/writing non-shared formulas. -- 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]
