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: RESOLVED FIXED
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: Print-Range
  Show dependency tree / graph
 
Reported: 2018-12-27 18:58 UTC by lori
Modified: 2023-11-13 21:42 UTC (History)
4 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
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 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 Comment hidden (obsolete)
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 Comment hidden (obsolete)
Comment 6 Xisco Faulí 2019-07-05 10:26:00 UTC Comment hidden (obsolete)
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 Comment hidden (obsolete)
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 Comment hidden (obsolete)
Comment 12 Jesper Korsholm Brogaard 2020-03-24 07:51:34 UTC 
I have reproduced the error in 6.4.2.2 with some other steps:

1. Create a spreadsheet_1 with a value in A1

2. Create a spreadsheet_2 with two or more sheets. Insert some data in each sheet, some text is enough, so they will be printed. Wait to create link to spreadsheet_1.

3. Select Print, choosing 'Print All Sheets' in option 'From which:'. All sheets is printed.

4. close and reopen spreadsheet_2

5. Print again as before. All sheets are printed

6. Now Insert link to A1 in spreadsheet_1 in any of the sheets in spreadsheet_2 (like ='file:///C:/Users/Jesper/Documents/spreadsheet_1.ods'#$Sheet1.A1)

7. Select Print, choosing 'Print All Sheets' in option 'From which:'. All sheets is printed.

8. Close spreadsheet_2 and reopen it.

9. When printing spreadsheet_2, all sheets except the last one are printed.

Observations: 
a. It is the last sheet created, that is not printed, no matter which order there are placed in the spreadsheet.

b. If you remove the link, the last sheet is still not printed. But if you insert a sheet more, it will be printed. The sheet previously unable to print is still unable to print.
Comment 13 QA Administrators 2022-03-25 03:39:02 UTC Comment hidden (obsolete)
Comment 14 Andreas Heinisch 2023-11-13 21:42:04 UTC 
Repro in:
Version: 6.3.3.2 (x64)
Build-ID: a64200df03143b798afd1ec74a12ab50359878ed
CPU-Threads: 6; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc: CL

Cannot be reproduced anymore in:
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 0b8fd4aa900ac1e6102f4b2581cabbb1b81a7b13
CPU threads: 6; OS: Windows 10.0 Build 19045; UI render: default; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL threaded