<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:klasse@partyheld.de" title="Johnny_M <klasse@partyheld.de>"> <span class="fn">Johnny_M</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - can not save the xlsx file page break information."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=88403">bug 88403</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>klasse@partyheld.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - can not save the xlsx file page break information."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=88403#c16">Comment # 16</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - can not save the xlsx file page break information."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=88403">bug 88403</a>
from <span class="vcard"><a class="email" href="mailto:klasse@partyheld.de" title="Johnny_M <klasse@partyheld.de>"> <span class="fn">Johnny_M</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133828" name="attach_133828" title="Resulting XLSX file saved on test step 5">attachment 133828</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133828&action=edit" title="Resulting XLSX file saved on test step 5">[details]</a></span>
Resulting XLSX file saved on test step 5
I've come across this recently as well, both with XLSX files created by LO and
ones (apparently) created by MS Excel.
Minimal reproduction procedure:
Action:
1. Open a new Calc spreadsheet
2. Enter the word "test" somewhere in the middle of the sheet (e.g., cell K30)
3. Change to the page break view (menu View -> Page Break)
4. Drag and drop the right boundary of Page 1 to the one of Page 2, to have one
single page instead of two
5. Save the file in the "Microsoft Excel 2007-2013 XML (.xlsx)" format
6. Close the file
7. Open the file again
Expected results:
3. Two pages are shown (Page 1 and Page 2)
4. Page 1 covers the entire used area
5. File gets saved
6. File closed
7. File opens in the Page Break view with Page 1 covering the entire used area,
as set before saving
Actual results:
3. to 6. As expected
7. Page 1 and Page 2 are shown as before the boundary change
The issue also occurs with existing XLSX files created with both MS Excel or
LO: One opens the file in LO, changes the page breaks and saves the file. Then,
after re-opening the saved file in LO, the page breaks are back to as they were
before the change. (Tested with
<a href="https://bugs.documentfoundation.org/attachment.cgi?id=124761&action=edit">https://bugs.documentfoundation.org/attachment.cgi?id=124761&action=edit</a>, after
first seeing the issue on another, small XLSX file apparently created by MS
Excel 2016 according to its file properties.)
The issue occurs only when saving as XLSX, not with XLS or ODS. (Saving to one
of the latter two is the workaround mentioned in the <a href="show_bug.cgi?id=88403#c8">comment 8</a>.)
Reproducible with (these are the only ones I tried):
- Ubuntu 16.10 Mate, 64 bit; LO as provided by Ubuntu's LO 5.2 PPA:
LO 5.2.6 release
- Ubuntu 17.04 Mate, 64 bit; LO as provided by Ubuntu's LO 5.3 PPA:
Version: 5.3.3.2
Build ID: 1:5.3.3~rc2-0ubuntu0.17.04.1~lo0
CPU Threads: 4; OS Version: Linux 4.10; UI Render: default; VCL: gtk3; Layout
Engine: new;
Locale: en-US (en_US.UTF-8); Calc: group
- Ubuntu 17.04 Mate, 64 bit, live ISO; LO as provided by TDF:
Version: 5.5.0.0.alpha0+
Build ID: 066665644b398a882e6cded98af5bb060af41d76
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-06-01_00:32:47
Locale: en-US (en_US.UTF-8); Calc: group
Given the apparent number of people affected I'm taking the liberty of changing
the bug status to NEW. Additional confirmations (other OSes, LO versions, etc.)
are still welcome.</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>