https://issues.apache.org/bugzilla/show_bug.cgi?id=56295
Bug ID: 56295
Summary: Cell styles are not copied from one workbook to
another
Product: POI
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Attached you will find a zip file containing a JUnit test to replicate the
issue. Basically we open a first workbook and add to it a new sheet where we
clone the content from a second workbook sheet. We are expecting the style from
the second to appear in the first however that does not happen as the
screenshots show.
1. Download poi-3.10-FINAL
2. Download the junit-4.11.jar which includes hamcrest (POI lib ships the
version without hamcrest)
3. Download the zip file and uncompress it somewhere
4. Compile and run the test as per the below (Note I downloaded everything to
my ~/Downloads MAC directory):
$ cd xlsx-xslm-style-lost-on-merge/
$ javac -cp
".:/Users/nu/Downloads/poi-3.10-FINAL/*:/Users/nu/Downloads/poi-3.10-FINAL/lib/*"
*.java
$ java -cp
".:/Users/nu/Downloads/poi-3.10-FINAL/*:/Users/nu/Downloads/poi-3.10-FINAL/lib/*:/Users/nu/Downloads/poi-3.10-FINAL/ooxml-lib/*:/Users/nu/Downloads/junit-4.11.jar"
org.junit.runner.JUnitCore XlsxSheetCopyUtilTest
5. Look into the output.xlsm file to confirm the styles from pet.xlsx are lost
when its sheet is copied to zoom200.xlsm file.
BTW the attached files are coming from
https://issues.apache.org/bugzilla/show_bug.cgi?id=52348 with small
modifications.
Thanks,
- Nestor
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]