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]

Reply via email to