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 2019/11/03 21:14:57 UTC

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

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

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

--- Comment #1 from bschuhmacher@ubpartner.com ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

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

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

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

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

--- Comment #2 from bschuhmacher@ubpartner.com ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

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

--- Comment #3 from Johannes Paul <jo...@gmx.de> ---
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

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

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

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

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

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

--- Comment #5 from Johannes Paul <jo...@gmx.de> ---
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!

gunter.henning@gmx.de

-- 
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 63902] Cloned chart has reference to field with original sheet. Problem with method Workbook.cloneSheet(int sheetNum)

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

--- Comment #7 from Dominik Stadler <do...@gmx.at> ---
Related change: r1886605

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