https://bugs.documentfoundation.org/show_bug.cgi?id=147592
Bug ID: 147592
Summary: In Writer all inserted linked OLE spreadsheets do
share the same view, which is recently opened view in
Calc.
Product: LibreOffice
Version: 6.4.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
If a Calc speadsheet is inserted in Writer as OLE object with "Create from
file"->"Link to file" to existing file the view (show columns/rows range and
position) is inherited from the Calc file. If the same spreadsheet is inserted
in that way multiple times (that is linking to same file) all do show the same
range of cells.
Result:
1.Opening Calc sheet and just moving around affects the Writer document
referencing it.
2.There is no possibility to show two separate portions of the same spreadsheet
in Writer document.
Steps to Reproduce:
1.Create the Calc spreadsheet, fill two separate fragments of it with two data
block so that You could see which one is visible and which one is not. Make
each block to contain at least two columns.
2.Save it, close.
2.Create a Writer document.
3.Select Insert->Object->OLE Object. Choose "Create From File" and "Libre...
Spreadsheet".
4.In dialog "Insert OLE Object" check the box "Link to file" and use search to
navigate to the spreadsheet created in point 1.
5.Repeat second time inserting another view of THE SAME file.
6.Activate first view and navigate to FIRST data block. Make at least two
columns visible.
7.Activate second view and navigate to SECOND data block. Make at least two
columns visible.
8.Save document and close. This may be wise to make a screenshot before
closing.
Since that moment effects may vary, but are always following some scheme.
9.Open Writer document. When it asks about updating all links say "No".
10.Observe that both views do show their set up fragments of Calc sheet. This
is a correct behavior.
11.Close document without saving.
12.Open Calc inserted sheet.
13.Navigate to FIRST data block and modify first cell of this region. Leave
cursor there.
14.Save it and close.
15.Open again Writer document. This time say "Yes" when it ask about updating
all links.
16.Observe, that now:
a) BOTH views of the spreadsheet do show THE SAME data block;
b) BOTH views are just one column wide.
17.Try it again adding some data below the block.
THIS IS WRONG.
Actual Results:
1.After update both views do show the same fragment.
2.After update what is shown in view seems to calculated from:
- location of cursor and sheet in which cursor was during save;
- some auto-ranging selecting what is shown.
instead of what was visible BEFORE update.
Expected Results:
The view should show exactly the same cells range regardless of any edits in
spreadsheet, any other views of the same spreadsheet and any update process.
Reproducible: Always
User Profile Reset: No
Additional Info:
It seems to be inherently related to limitations of OLE technology AND Calc
since I:
a) could not replicate it on Linux where OLE is not used;
b) could not replicate in on Windows with inserted Writer documents as OLE
objects.
This bug is present since many years. I am not sure how far in time, but it may
be since before LibreOffice forked from OpenOffice.
I would be pleased to find it somehow fixed (or at least have a good work
around).
I wished to use the "multiple views of the same sheet" functionality to be able
to create a printable, paged, good looking report template which on one page
contains input data and on others some computation results. I was thinking
about linking those views to different regions of the same Calc sheet document
so the computations could be run in Calc while elementary data could be entered
in Writer just in place where the reader reads the "how to do it" text.
--
You are receiving this mail because:
You are the assignee for the bug.
