Download it now!
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 (steps in comment 8)
Summary: LibreOffice Calc FILEOPEN: lost PrintArea in last sheet when a formula with a...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-27 18:58 UTC by lori
Modified: 2020-01-20 17:15 UTC (History)
2 users (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
Comment 8 Xisco Faulí 2020-01-20 17:11:23 UTC
I do reproduce it in

Version: 6.5.0.0.alpha0+
Build ID: fc1f85127968d1c2e0a53dace51bf8a78f9e6ca5
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Steps to reproduce it:
1. Open attachment 147931 [details]
2. Remove the last sheet
3. Duplicate one of the existing sheets and put it at the end
4. Save it
5. Open the new created document and check the third sheet -> Printing area is gone
Comment 9 Xisco Faulí 2020-01-20 17:14:06 UTC
Also reproducible in

Version: 5.2.0.0.alpha0+
Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53
Threads 4; Ver: 4.19; Render: default;
Comment 10 Xisco Faulí 2020-01-20 17:15:32 UTC
Also reproducible in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 11 Xisco Faulí 2020-01-20 17:15:57 UTC
@Mike, I thought you might be interested in this issue...