[Libreoffice-bugs] [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)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122347

--- Comment #12 from Jesper Korsholm Brogaard <jesper at brogaard.eu> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200324/6166270d/attachment.htm>