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
  Show dependency tree / graph
 
Reported: 2018-02-10 11:56 UTC by Christian
Modified: 2018-12-25 17:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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
View All Add an attachment (proposed patch, testcase, etc.)

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)