Bug 64642 - FORMATTING: Print Ranges properties not saved properly on ODS
Summary: FORMATTING: Print Ranges properties not saved properly on ODS
Status: RESOLVED DUPLICATE of bug 62938
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-15 16:57 UTC by J-C MEROTH
Modified: 2013-05-18 03:45 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
attachment-32186-0.html (2.96 KB, text/html)
2013-05-16 09:32 UTC, J-C MEROTH
Details
attachment-32186-1.dat (1 bytes, multipart/alternative)
2013-05-16 09:32 UTC, J-C MEROTH
Details
TestPbEnTeteZoneImpr_01.ods (8.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-16 09:32 UTC, J-C MEROTH
Details
attachment-3107-0.html (1.55 KB, text/html)
2013-05-16 13:09 UTC, J-C MEROTH
Details
attachment-3107-1.dat (1 bytes, multipart/alternative)
2013-05-16 13:09 UTC, J-C MEROTH
Details
DlgEditZones_1.jpg (101.99 KB, image/jpeg)
2013-05-16 13:09 UTC, J-C MEROTH
Details
DlgEditZones_2.jpg (99.16 KB, image/jpeg)
2013-05-16 13:09 UTC, J-C MEROTH
Details

Note You need to log in before you can comment on or make changes to this bug.
Description J-C MEROTH 2013-05-15 16:57:40 UTC
Using hearder on spreadsheet, the first line of the header is lost when saving file
Comment 1 ign_christian 2013-05-16 02:40:48 UTC
It seems nothing wrong on header with LO 4.0.3.3 (Win7 Home Premium 32bit)

Could you attach a sample doc & how to reproduce that problem? Using default Header setting?
Comment 2 J-C MEROTH 2013-05-16 09:32:19 UTC
Created attachment 79394 [details]
attachment-32186-0.html

Bonjour,

I am afraid I didn't explain correctly then problem : It concernes then 
Printed Aera Definition.
I join a simple demo sheet with a header of 2 lines : You should see 
that then first line of the header of the printed aera is not kept on 
printed page 2.
So, you could define again a header of 2 lines, check the result, and 
save the doc. Open it again, and you can see that the second
line of the header is lost on page 2.
Excuse my poor english ! ;-)
__________________________________________________________________________________
Le 16/05/2013 04:40, bugzilla-daemon@freedesktop.org a écrit :
> ign_christian <mailto:ign_christian@yahoo.com> changed bug 64642 
> <https://bugs.freedesktop.org/show_bug.cgi?id=64642>
> What 	Removed 	Added
> Status 	NEW 	NEEDINFO
>
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=64642#c1> 
> on bug 64642 <https://bugs.freedesktop.org/show_bug.cgi?id=64642> from 
> ign_christian <mailto:ign_christian@yahoo.com> *
> It seems nothing wrong on header with LO 4.0.3.3 (Win7 Home Premium 32bit)
>
> Could you attach a sample doc & how to reproduce that problem? Using default
> Header setting?
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 3 J-C MEROTH 2013-05-16 09:32:19 UTC
Created attachment 79395 [details]
attachment-32186-1.dat
Comment 4 J-C MEROTH 2013-05-16 09:32:19 UTC
Created attachment 79396 [details]
TestPbEnTeteZoneImpr_01.ods
Comment 5 ign_christian 2013-05-16 10:25:59 UTC
Don't worry my english is uglier than poor :)
Next time if your replying from email, please remove previous message.

I see..you mean using function from menu: Format > Print Ranges > Edit
Is that correct? 

If yes, what I found from your attached file:
-> Rows to repeat: $2 (should be $1:$2)
Comment 6 J-C MEROTH 2013-05-16 13:09:46 UTC
Created attachment 79414 [details]
attachment-3107-0.html

Ok, with my calc example, you have to restore an header of 2 lines, 
(check with the preview : it's OK). Then, save the file, AND CLOSE IT. 
After you reload it, you can see that on page2, the 1st line of the 
header has disappeared.
2 pictures of the dialog box joined.

Le 16/05/2013 12:25, bugzilla-daemon@freedesktop.org a écrit :
>
> *Comment # 5 <https://bugs.freedesktop.org/show_bug.cgi?id=64642#c5> 
> on bug 64642 <https://bugs.freedesktop.org/show_bug.cgi?id=64642> from 
> ign_christian <mailto:ign_christian@yahoo.com>*
> ------------------------------------------------------------------------
Comment 7 J-C MEROTH 2013-05-16 13:09:46 UTC
Created attachment 79415 [details]
attachment-3107-1.dat
Comment 8 J-C MEROTH 2013-05-16 13:09:46 UTC
Created attachment 79416 [details]
DlgEditZones_1.jpg
Comment 9 J-C MEROTH 2013-05-16 13:09:46 UTC
Created attachment 79417 [details]
DlgEditZones_2.jpg
Comment 10 ign_christian 2013-05-17 02:38:21 UTC
I see...confirmed reproducible on LO 4.0.3.3 (Win7 Home Premium 32bit)

Steps to reproduce:
1. Open attached ODS file
2. Menu: Format > Print Ranges > Edit
3. Rows to repeat: $1:$2 > OK
4. Menu: File > Page Preview (see that Page1 & Page2 have identical Row1 & Row2 as headers)
5. Save & close file
6. Reopen that file, then Page Preview (see that Row1 not shown as header on Page2)

Found another facts:
- Save the attached ODS as XLS then repeat step 2-6 -> that problem not occur
- Save the attached ODS as XLSX then repeat step 2-6 -> both Row1 & Row2 not shown as headers on Page2

Seems that Print Ranges properties not saved properly on ODS & XLSX.
Comment 11 ign_christian 2013-05-18 03:45:23 UTC
J-C, I mark your bug as duplicate of Bug 62938 because that bug previously reported & confirmed. You can reopen this bug if you found another issue other than Bug 62938.

*** This bug has been marked as a duplicate of bug 62938 ***