[Bug 59306] New: Shifting rows does not shift chart data series references

https://bz.apache.org/bugzilla/show_bug.cgi?id=59306

            Bug ID: 59306
           Summary: Shifting rows does not shift chart data series
                    references
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SS Common
          Assignee: [hidden email]
          Reporter: [hidden email]

Created attachment 33752
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33752&action=edit
Excel file with chart

Shifting rows that are part of a chart's data series does not shift the data
series cell references.

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

https://bz.apache.org/bugzilla/show_bug.cgi?id=59306

--- Comment #1 from Javen O'Neal <[hidden email]> ---
Created attachment 33753
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33753&action=edit
SimpleScatterChart.xls

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

https://bz.apache.org/bugzilla/show_bug.cgi?id=59306

--- Comment #2 from Javen O'Neal <[hidden email]> ---
Tried to write a unit test for this, then discovered XSSFChart is pretty
incomplete. Without using the CTChart* classes, it is possible to add data
series to a chart but not query existing data series.

/lang=jython
from java.io import File
from org.apache.poi.ss.usermodel import WorkbookFactory
f = File('SimpleScatterChart.xlsx')
wb = WorkbookFactory.create(f, None, True)
sheet1 = wb.getSheet('Sheet1')
chart1 = wb.getSheet('Chart1')
sheet1scatter = sheet1.createDrawingPatriarch().getCharts()[0]
chart1scatter = chart1.createDrawingPatriarch().getCharts()[0]

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

https://bz.apache.org/bugzilla/show_bug.cgi?id=59306

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Blocks|                            |60072


Referenced Bugs:

https://bz.apache.org/bugzilla/show_bug.cgi?id=60072
[Bug 60072] Sheet shiftRows doesn't trigger charts position updating
--
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]