http://openoffice.org/bugzilla/show_bug.cgi?id=117462
Issue Type: DEFECT
Summary: "Linked to file" OLE Calc sheet does not behave
correctly when inserted more than once.
Classification: Application
Product: Word processor
Version: OOo 3.2.1 RC2
Platform: PC
OS/Version: Windows XP
Status: UNCONFIRMED
Priority: P3
Component: open-import
AssignedTo: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
1. Steps to reproduce
- create new Calc document;
- fill at least two cells in it with different content;
- save it;
- close Calc;
- open new writer document;
- insert OLE linked object, as "create from file" and "link to file" pointing
to saved Calc document;
- do it again. Now you have two views of the same sheet.
- double click on the first one and adjust view are so that only one of
filled cells is visible;
- click somewhere else to stop editing;
- double click on the second document. Observe what is now visible here;
- click somewhere else to stop editing;
- double click on the second one and adjust view are so that both cells are
visible;
- click somewhere else to stop editing;
- go back to editing first inserted view and observe how it moved and
re-sized;
- close writer;
- open Calc document;
- fill some far off cell;
- save;
- open Writer document and observe what happen to views.
2. Current behavior:
- Adjusting size or a visible part of sheet of any of views affects all
others;
- Any change to inserted and linked Calc document made through Calc will break
settings of what is visible in a Writer document;
- It seems that all linked object share the same viewport description.
Viewport description seems to be stored in Calc document not in Writer. All
linked views do share:
- visible origin;
- visible sheet;
- number of visible rows and columns;
- change to Calc document content made in one view do not propagate to other
views.
2.Expected behavior:
- each inserted linked to file object should have stored own viewport
parameters in Writer file. Accessing linked sheet source file in Calc or via
other inserted view must NOT change other views. Currently accessing document
in Calc moves all inserted views in all Writer documents when links are updated
(what means - on open and when one is willing to see changes made);
- update made in one of linked views should trigger "Update link" event on all
other views linking to the same document. Currently editing in one view
requires double click or manual update to see changes propagation. This handles
only one level of dependency but should be helpful in most cases and easy to
do;
- it would be nice to have "lock viewport" function to disallow users of
document to move it. Similar as we have "protect cell", "protected paragraphs",
"protected sections";
4. Background
In effect one can't have a large sheet with complex calculation embedded as a
part of an interactive Writer document.
This kind of operation was needed by me to create a "Guide & Report from an
Experiment". This kind of document document is mainly a lot of text telling
step-by-step how to perform experiment with numerous places to be filled by an
employee doing actual experiment. Values used in calculations in each step do
depend on values entered earlier.
Finally I was forced to move to Calc and loose a lot of esthetic
functionality. For example nice headers, save & print time tracking, table of
content, styles in text, footnotes.
Level of math complexity needed in such a report is far off from Writer own
capabilities.
Level of esthetic required for printed reports is difficult to achieve in
Calc. Or at least much more time consuming.
5.Workaround attempts:
- Attempt to go around on Linux test with sym and hard links does not help;
- Attempt to go around on Windows with "create link" .lnk file do not work;
Especially hard link failure strongly suggests that viewport parameters are
stored inside a Calc document instead of inside a Writer. This is UNACCEPTABLE
even for a single view per linked sheet.
- End of bug report -
Thanks for a great tool! I do really appreciate the effort & time You guys have
put in OpenOffice to make it work as well as it does. It is well above 8 years
now since I needed to use another office program!
Regards,
Tomasz Sztejka.
--
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
---------------------------------------------------------------------
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
