poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60561] Values wrote in the first visible sheet are overwriting hidden sheet values
Date Thu, 19 Jan 2017 07:24:57 GMT

Javen O'Neal <onealj@apache.org> changed:

           What    |Removed                     |Added
             Status|NEW                         |NEEDINFO

--- Comment #3 from Javen O'Neal <onealj@apache.org> ---
> All modifications done with Excel on the first visible "DataSheet 1" are 
> reported on the "HiddenSheet".

This doesn't make sense. Modifying one sheet should not modify a different
sheet unless there are formulas on the second sheet. The only other way this
would make sense is if you Ctrl+Click the sheets in Excel to create a sheet
[Group], in which case modifications are applied to all selected sheets in that

Group editing is a GUI feature of Excel (not something that is stored in the
OOXML format, except perhaps for group state).

I did not see a difference in POI's behavior with respect to the values that
were written to the sheets when the hidden sheet was made very hidden.

Please provide a unit test that demonstrates the problem that you have. If at
all possible, test for the problem in POI java code, as this eliminates the
variable of Excel's behavior (different versions, macros that run when the
workbook is opened).

You are receiving this mail because:
You are the assignee for the bug.
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message