https://bz.apache.org/bugzilla/show_bug.cgi?id=65289
Bug ID: 65289
Summary: XSSFWorkbook.cloneSheet leading to save prompt by
Excel without any changes done
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: majorconce...@t-online.de
Target Milestone: ---
Created attachment 37848
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37848&action=edit
Code to reproduce the issue
Hi, I have the following scenario: I am opening an excel file using POI,
perform a cloneSheet operation on the first sheet and save the file under a new
name. When opening the newly created file using Excel 365, a save prompt occurs
on closing the file, although no changes have been done. The save prompt asks
me to save changes that have occurred.
This is quite annoying for everyone who just wants to look into the file. Also
it doesn't make sense and seems to be some kind of bug by POI or Excel. But
even if this whould be an Excel bug, it would be great if POI would find a way
to prevent it.
This has been tested using a newly created empty file. If you would like to
reproduce the observation, you could use the attached class "Test.java". After
having let it run you would open the newly created file by Excel - see below -
and immediately close it. You would be prompted to save changes.
Prerequisites are an existent folder "c:/temp" and an empty excel file named
"test.xlsx" in there. The newly created file will be named "test_copy.xlsx".
You may change path and file names according to your suits. You also need at
least Java 1.8 and Excel 365.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
