[Bug 60509] New: XSSFWorkbook.setSheetName() does not update references in charts

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 60509] New: XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

            Bug ID: 60509
           Summary: XSSFWorkbook.setSheetName() does not update references
                    in charts
           Product: POI
           Version: 3.14-FINAL
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

I have a base xlsx file with several tabs and charts.

When I work on this file with POI, I need to change the sheet names.

Unfortunately, the data referenced by the chart keeps the reference to the old
chart Name when I use XSSFWorkbook.setSheetName().

Related bugs have been fixed for formulas and named ranges, but apparently not
for Charts.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60509] XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
           Severity|major                       |enhancement

--- Comment #1 from Dominik Stadler <[hidden email]> ---
As stated in http://poi.apache.org/spreadsheet/limitations.html support for
charts is very limited currently, therefore this would likely involve a bit
more work to prepare more fundamental support for handling charts first...

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60509] XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

--- Comment #2 from Alain Fagot Bearez <[hidden email]> ---
I found valuable code in #54470 that can be applied to fix this issue.

I am working on it.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60509] XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

PJ Fanning <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |54470


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=54470
[Bug 54470] [PATCH] Solution to support Graph in XSSFWorkbook.cloneSheet method
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60509] XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

Alain Fagot Bearez <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #3 from Alain Fagot Bearez <[hidden email]> ---
resolved by r1842548

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60509] XSSFWorkbook.setSheetName() does not update references in charts

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509
Bug 60509 depends on bug 54470, which changed state.

Bug 54470 Summary: [PATCH] Solution to support Graph in XSSFWorkbook.cloneSheet method
https://bz.apache.org/bugzilla/show_bug.cgi?id=54470

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|---                         |FIXED

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]