[Libreoffice-bugs] [Bug 88403] can not save the xlsx file page break information.

[bugzilla-daemon at bugs.documentfoundation.org]

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

Johnny_M <klasse at partyheld.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |klasse at partyheld.de

--- Comment #16 from Johnny_M <klasse at partyheld.de> ---
Created attachment 133828
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133828&action=edit
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
https://bugs.documentfoundation.org/attachment.cgi?id=124761&action=edit, 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 comment 8.)


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 at 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.

-- 
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/20170603/68871554/attachment-0001.html>