[Bug 63902] New: Cloned chart has reference to field with original sheet. Problem with method Workbook.cloneSheet(int sheetNum)

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

            Bug ID: 63902
           Summary: Cloned chart has reference to field with original
                    sheet. Problem with method Workbook.cloneSheet(int
                    sheetNum)
           Product: POI
           Version: 4.1.1-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

Hi,
I think I found a bug related with method Workbook.cloneSheet(int sheetNum).
When I cloned original sheet(sheetA) with chart(chartA) in cloned sheet(sheetB)
in chart(chartB) I have reference to original sheet(sheetA) but not to
new(sheetB) . That doesn't works as expected and I think new chart(chartB) in
the new sheet(sheetB) should have reference to fields from new(sheetB).  I
tried change references manual by CTNumRef.setF(String var1) and
CTStrRef.setF(String var1) but when I did that I change reference also in
original(chartA). That is only with cloned chart(chartB). I think they can be
related with something together.

Conclusion:
I want to cloned chart(chartB) has reference to new cloned sheet (sheetB) not
to original.
Thx

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

--- Comment #1 from [hidden email] ---
Created attachment 36996
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36996&action=edit
Test case

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

--- Comment #2 from [hidden email] ---
Comment on attachment 36996
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=36996
Test case

Sorry, this was for another ticket, no idea how it got attached here...

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

--- Comment #3 from Johannes Paul <[hidden email]> ---
I am facing almost the same issue, except the fact, that i can't even open the
File anymore with Excel (2016).
It gets corrupted and can't be open, and not even be automatically repaired by
Excel.

I have also a Template sheet, including a chart. If i try to clone that
template (and rename the clone), and save the file, the file is corrupt.
If i repeat the same process after just deleting the chart, everything works.

How can i contribute or help?

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

--- Comment #4 from Alain Fagot Bearez <[hidden email]> ---
Hi,

Could you repeat your experiment with the version I am trying to build on
https://github.com/apache/poi/pull/227 and share your example file?

Thanks!

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

--- Comment #5 from Johannes Paul <[hidden email]> ---
Sadly i can't setup POI locally. It won't build.
If you provide me somehow the jars (or help me to setup POI), i would be happy
to test it!

[hidden email]

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

--- Comment #6 from Alain Fagot Bearez <[hidden email]> ---
When successful, the build
https://ci-builds.apache.org/job/POI/job/POI-DSL-1.16/195/ will contain
references to artifacts which you could download.

You can find guidance to setup your development environment on
https://poi.apache.org/devel/index.html

You can also ask specific questions about building and testing through the
mailing lists at https://poi.apache.org/help/index.html

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

--- Comment #7 from Dominik Stadler <[hidden email]> ---
Related change: r1886605

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