<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Not moving freeze pane inserting a new sheet in a Excel 97 file in hidden mode."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109517">109517</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Not moving freeze pane inserting a new sheet in a Excel 97 file in hidden mode.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.2.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>filters and storage
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>luismiguel.lacosta@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=134899" name="attach_134899" title="Test file">attachment 134899</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=134899&action=edit" title="Test file">[details]</a></span>
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>