[Libreoffice-bugs] [Bug 114544] New: FILESAVE: Calc duplicates Print Areas when saving as an Excel XLSX file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=114544

            Bug ID: 114544
           Summary: FILESAVE: Calc duplicates Print Areas when saving as
                    an Excel XLSX file
           Product: LibreOffice
           Version: 5.3.6.1 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tslagter at osa.state.mn.us

Description:
When saving a spreadsheet as an XLSX file, Calc duplicates any existing print
areas. When checking the underlying XML files, the workbook.xml file contains a
duplicate 'definedName' node for each print area.

Steps to Reproduce:
1. Create a new Calc file.
2. Define a new Print Range.
3. Save the file as Microsoft Excel 2007-2013 XML (.xlsx) file.
4. Close and reopen the file.
5. Select Insert -> Defined Name or Expression... and note that the Print Area
is listed.
6. Insert some data and save the file (or Save As a new XLSX file).
7. Close and reopen the file.
8. Select Insert -> Defined Name or Expression... and note that there are now
two Print Areas listed, one with "_0" appended to the original name.
9. Repeat 6-8 to replicate multiple times.

Actual Results:  
The original Print Area is duplicated every time the file is saved.

Expected Results:
Only the original Print Area will be listed each time the file is saved and
reopened.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I ran into this while trying to read the file in an automated system. In the
underlying XML files, the 'definedName' element is duplicated with the same
'name' value, which does not seem to be valid. Excel removes the duplicate when
opening the file; LibreOffice Calc appends the "_0" to prevent a duplicate
name. While this may only be annoying to those using Calc as a standard user,
when parsing the XML the duplicate XML elements create problems.

I tested this with 5.3.6.2, 5.3.7.2, and 5.4.3.2 (all x64) - the same problem
exists in all of them.

About LibreOffice:
Version: 5.4.3.2 (x64)
Build ID: 92a7159f7e4af62137622921e809f8546db437e5
CPU threads: 8; OS: Windows 6.19; UI render: default; 
Locale: en-US (en_US); Calc: group


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:57.0) Gecko/20100101
Firefox/57.0

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171218/48cc5352/attachment-0001.html>