Custom Properties Cleared when Saving [closed]

asked 2013-06-26 16:01:40 +0200

PsyMonkey gravatar image

updated 2015-10-04 19:36:39 +0200

Alex Kemp gravatar image

I am using POI (Java API for Microsoft Documents) and Microsoft Excel 2008/2010 to create Excel Documents with Custom Properties. The properties can be viewed perfectly in Libre Office via File->Properties then the Custom Properties Tab.

Problem is if you make any changes to the file and hit save all the Custom Properties are cleared. This does not happen when Editing a file in Microsoft Excel 2008/2010. I have been able to reproduce this on LibreOffice and LibreOffice

How to reproduce: Use Microsoft Office Excel 2010/2008 create new Excel Spreadsheet. Add data to any cell. Add custom properties to the Spreadsheet E.g Key=SuperKey, Value=123456, ValueType=Text. Open the file in LibreOffice or view the Custom Properties on the file. This will work perfect. Edit any cell in the spreadsheet and hit save and exit. If you op the file in Microsoft Office or Libre Office the custom properties are gone.

Edit: Forgot to added using xlsx file format.

No need is a known bug :

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-04 19:36:48.694418