poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 59673] HSSFWorkbook#setSheetOrder does not update external sheet indexes in formula references with ranges rather than single cells
Date Thu, 09 Jun 2016 08:58:35 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=59673

Matthew Wightman <msww-asfbugs@corefiling.co.uk> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #2 from Matthew Wightman <msww-asfbugs@corefiling.co.uk> ---
I have raised a new bug (Bug 59677) for the external indices issue with
reproduction steps now I have been able to find some.

Depending on the fix implemented for that bug, this patch may be
redundant (except for the additional test case coverage), but depending
on approach taken for that bug might still be needed.

As there is not yet a patch/fix for that bug, I would advise you to
review and apply this patch - the external indexing issue only applies
to some workbooks (where the two indices are not in sync), and corrects
the behaviour on all other workbooks.

For the workbooks with complicated external indices, the current
behaviour for area references is that they may end up pointing to the
wrong sheet after a change in sheet order. This patch will change which
sheet is incorrectly referenced, and can make some of the broken
references point to no sheet at all, instead becoming #REF, but this is
the same as the current treatment of single cell references (as reported
on the new bug).

-- 
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


Mime
View raw message