Bug 115610 - print range: "rows/columns to repeat" does not conform to the specification (xlsx files)
Summary: print range: "rows/columns to repeat" does not conform to the specification (...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-External-Generators
  Show dependency treegraph
 
Reported: 2018-02-10 11:56 UTC by Christian
Modified: 2021-07-14 11:40 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
example file with first row repeated for printing (8.13 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-02-10 11:57 UTC, Christian
Details
2nd page print preview screen-shot (19.15 KB, image/jpeg)
2018-03-07 17:23 UTC, Christian
Details
2nd page print preview screen-shot in LibreOffice (22.10 KB, image/jpeg)
2018-03-07 17:26 UTC, Christian
Details
The example file in Excel 13 and LO7.1 nightly (111.34 KB, image/png)
2020-10-05 06:43 UTC, NISZ LibreOffice Team
Details
The example file resaved in Excel 2019 and opened in Calc (41.98 KB, image/png)
2021-07-13 16:37 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christian 2018-02-10 11:56:02 UTC
Description:
The "rows/columns to repeat" does not conform to the specification as you can see in the attached file, generated with openpyxl.

Steps to Reproduce:
1. generate an xlsx (for example with python and openpyxl) file using rows or columns to repeat when printing (print range in calc)

Actual Results:  
open the file in calc, click on print preview, rows or columns do not get repeated

Expected Results:
open the file in calc, click on print preview, rows or columns get repeated


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101 Firefox/60.0
Comment 1 Christian 2018-02-10 11:57:32 UTC
Created attachment 139756 [details]
example file with first row repeated for printing

xlsx file generated with openpyxl, conforming to the specification
Comment 2 Xisco Faulí 2018-02-12 18:49:43 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 3 Buovjaga 2018-03-06 14:45:51 UTC
(In reply to Christian from comment #0)
> Expected Results:
> open the file in calc, click on print preview, rows or columns get repeated

I don't understand, it looks the same in MSO 2013. Please explain better, preferably with a screenshot from MSO showing how it should look like.
Comment 4 Christian 2018-03-07 17:23:22 UTC
Created attachment 140448 [details]
2nd page print preview screen-shot

You either have to print it or open the print preview and look at page 2. The first row is not repeated in OO, but it should be.

2nd page print preview screen-shot is attached.
Comment 5 Christian 2018-03-07 17:26:35 UTC
Created attachment 140449 [details]
2nd page print preview screen-shot in LibreOffice

Same 2nd page print preview in LO: the first row is not repeated, but should be.
Comment 6 Buovjaga 2018-03-07 17:27:26 UTC
Ah, right, so the row with the numbers does not appear on the second print preview page.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: 856c57f20f9b07c686a854e0ccbb6ee3b0ee4791
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on March 7th 2018

Arch Linux 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 7 Christian 2018-03-07 17:29:31 UTC
(In reply to Buovjaga from comment #6)
> Ah, right, so the row with the numbers does not appear on the second print
> preview page.
> 
> Arch Linux 64-bit
> Version: 6.1.0.0.alpha0+
> Build ID: 856c57f20f9b07c686a854e0ccbb6ee3b0ee4791
> CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: kde4; 
> Locale: fi-FI (fi_FI.UTF-8); Calc: group
> Built on March 7th 2018
> 
> Arch Linux 64-bit
> LibreOffice 3.3.0 
> OOO330m19 (Build:6)
> tag libreoffice-3.3.0.4

Correct.
ps: I wrote OO but meant LO
Comment 8 Christian 2018-12-25 17:07:44 UTC Comment hidden (obsolete)
Comment 9 Buovjaga 2018-12-25 17:19:56 UTC Comment hidden (obsolete)
Comment 10 NISZ LibreOffice Team 2020-10-05 06:43:10 UTC
Created attachment 166076 [details]
The example file in Excel 13 and LO7.1 nightly

Still happens in:

Version: 7.1.0.0.alpha0+ (x64)
Build ID: dda71436b8594fb0669b3ac06c02a3997a0674be
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Calc: CL

The Edit Print Ranges dialog is empty and the Manage Names dialog gives this (false) information.
Comment 11 NISZ LibreOffice Team 2021-07-13 16:37:38 UTC
Created attachment 173537 [details]
The example file resaved in Excel 2019 and opened in Calc

Resaving it in Excel fixes the print range import in:
 
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0fc020fb73c86a20608e8dff12af607e60327379
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

while the original is still broken.