To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66817
Issue #|66817
Summary|HARD LINKS as References
Component|Spreadsheet
Version|OOo 2.0.2
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|ENHANCEMENT
Priority|P3
Subcomponent|code
Assigned to|spreadsheet
Reported by|discoleo
------- Additional comments from [EMAIL PROTECTED] Wed Jun 28 03:40:58 -0700
2006 -------
References and HARD LINKS
-------------------------
Most of the time I only need to work with a subset of the data from a worksheet.
To ease the work with very complex sheets, I copy that particular portion to a
new sheet. In addition, if the original data might change, making references to
the original data (instead of copying) is needed.
However, one limitation of this strategy is, that I cannot make changes within
the copies AND have the changes saved in the original record.
Suppose, we have a master sheet containing 10 subsets of (overlapping) data. I
will create 10 sheets to analyse those subsets, but I may detect an error
somewhere or need to recalculate some cells. It becomes a mess to make the
changes everywhere, even if we've used references to the original data in those
10 new sheets (as I still would need to find the specific cell in the original
mastersheet).
Another limitation is when referencing a cell containing a formula:
-- suppose we write a formula in A1:
= SUM(...) and we reference cell B1 to point to A1 (=A1). What we have in B1 is
the value from evaluating the SUM, NOT the formula itself. If we copied the cell
A1 to B1, any changes in B1 still wouldn't be reflected in the original formula
(in the A1 cell).
A very nice feature would be to have HARD LINKS the same way as under UNIX. The
advantage over usual references would be, that this is indeed an alias to the
original cell and any changes in a hard linked cell would be (actually) applied
to the original cell. (The features I will discuss would position it somewhere
more between true hard links and soft links.)
Some useful commands with hard linked cells would be:
- delete hard link: remove the hard link (without deleting the original cell)
- edit hard link: change the location the reference is pointing to
- make local copy: remove hard link AND copy the content of the original cell
to the local cell ("make a simple reference to the cell (=cell)"/ "copy the
value of the cell" (like in paste special) / or "copy the formula", depending
on an additional option)
- jump to original: move cursor to the original cell
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
