Bug 122347 - LibreOffice Calc FILEOPEN: lost PrintArea in last sheet when a formula with a link to external file exists in any sheet of that file
Summary: LibreOffice Calc FILEOPEN: lost PrintArea in last sheet when a formula with a...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-27 18:58 UTC by lori
Modified: 2019-07-10 07:01 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
sample file without bug, but necessary for the next file with link to this one. (8.46 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-02 09:58 UTC, lori
Details
sample file with bug (and with a cell containing the link to the first file (Print_Area_Bug.ods). (8.85 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-02 10:00 UTC, lori
Details

Note You need to log in before you can comment on or make changes to this bug.
Description lori 2018-12-27 18:58:35 UTC
Description:
When I re-open a .ods file with external link, I loose the print area in very last sheet. Each time I re-define a print area and save the .ods file, the file size increases a little bit. After re-open and saviing again with any changes, the file size decreases - so I assume the file is saved correctly but looses the print area while opening the file.

Steps to Reproduce:
1.create file with at least one external link in any sheet
2.add Print Area on very last sheet
3.save file
4.re-open the saved file

Actual Results:
on the very last sheet, the Print Area got lost.

Expected Results:
on the very last sheet, the Print Area still exists


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.0.4.2 (x64)
Build-ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf
CPU-Threads: 8; BS: Windows 6.3; UI-Render: Standard; 
Gebietsschema: de-CH (de_CH); Calc: group
Comment 1 Timur 2018-12-31 16:27:41 UTC
Please attach example file and write exact steps and cells to define Print Area.
Comment 2 lori 2019-01-02 09:58:53 UTC
Created attachment 147930 [details]
sample file without bug, but necessary for the next file with link to this one.
Comment 3 lori 2019-01-02 10:00:01 UTC
Created attachment 147931 [details]
sample file with bug (and with a cell containing the link to the first file (Print_Area_Bug.ods).
Comment 4 lori 2019-01-02 10:05:21 UTC
attachment contains 2 files:
Print_Area_Bug.ods
Print_Area_Bug_2.ods


the file Print_Area_Bug_2.ods contains the links to Print_Area_Bug.ods. And it contains 3 similar print areas on each sheet. When opening the file Print_Area_Bug_2.ods, the defined "Print Area" in the very last sheet ("Tab3") got lost. Each time, I set a print area on the very last sheet ("Tab3), save the file and re-open the file, the print area get lost.
Comment 5 Xisco Faulí 2019-07-02 15:53:10 UTC
Dear Lori,
A new major release of LibreOffice is available since this bug was reported.
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 Xisco Faulí 2019-07-05 10:26:00 UTC
Could you please paste the info from Help - about LibreOffice ?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' once the information has been provided
Comment 7 lori 2019-07-10 07:01:08 UTC
here the "About LibreOffice" info:

Version: 6.2.4.2 (x64)
Build-ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU-Threads: 16; BS: Windows 6.1; UI-Render: Standard; VCL: win; 
Gebietsschema: de-CH (de_CH); UI-Sprache: de-DE
Calc: CL