[Libreoffice-bugs] [Bug 109517] New: Not moving freeze pane inserting a new sheet in a Excel 97 file in hidden mode.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 109517
           Summary: Not moving freeze pane inserting a new sheet in a
                    Excel 97 file in hidden mode.
           Product: LibreOffice
           Version: 5.2.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: filters and storage
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: luismiguel.lacosta at gmail.com

Created attachment 134899
  --> https://bugs.documentfoundation.org/attachment.cgi?id=134899&action=edit
Test file

In a basic macro with the following steps:

1) Load in hidden mode a Excel 97 file (.xls) with a freeze pane in a sheet
2) Insert a new sheet before then sheet with the freeze 
3) Save the file as Excel 97

The expected behaviour is that in the changed file the freeze pane remains but
moved with the initial sheet but the observed behaviour is that the freeze pane
remains in the sheet with the same original position in worksheet.
(example a worksheet with a sheet named "Original" in position 0 with a freeze,
insert new sheet named "New" in position 0 and the result is a worksheet with
the sheet named "New" in position 0 has the freeze and the sheet named
"Original" in position 1 lost the freeze).

I have made another test:

Loading the file not using the hidden mode the result is the same as expected.

Loading the same file as .ods in hidden mode all the freezes are removed (not
expected but logical).

Saving the file as .xlsx all the freezes are removed.

I have attached some files to test:

-Download the files "Test.odt", "Test2.odt" and "Test2.xls".
-Open the file "Test.odt" with the others files in same folder.
-Press the button "test xls file hidden".
-In the file "Test2.xls" with a freeze in sheet "Hoja 1" a new sheet is
inserted before that sheet (using hidden mode). 
-The file is saved as ".odt", ".xls" and ".xlsx"
-All then changed files are displayed to compare

The adjacent buttons test the other possibilities:

-"test ods file hidden" -> Load a .ods file using hidden mode
-"test ods file not hidden" -> Load a .ods file not using hidden mode
-"test xls file not hidden" -> Load a .xls file not using hidden mode

Versión: 5.2.4.2
Id. de compilación: 3d5603e1122f0f102b62521720ab13a38a4e0eb0
Subprocesos de CPU: 2; Versión de SO: Windows 6.1; Repr. de IU: predeterminado; 
Configuración regional: es-ES (es_ES); Calc: group

-- 
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/20170727/0ba417a1/attachment-0001.html>