You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/12/22 10:25:40 UTC

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

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: dev@poi.apache.org
          Reporter: tarik.osswald@gmail.com
  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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

PJ Fanning <fa...@yahoo.com> 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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

Dominik Stadler <do...@gmx.at> changed:

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

--- Comment #1 from Dominik Stadler <do...@gmx.at> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

--- Comment #2 from Alain Fagot Bearez <Al...@cua.li> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


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

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=60509

Alain Fagot Bearez <Al...@cua.li> changed:

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

--- Comment #3 from Alain Fagot Bearez <Al...@cua.li> ---
resolved by r1842548

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