Hi Leonard,

On Friday, 2007-08-03 18:38:02 +0300, Leonard Mada wrote:

> I have partially rewritten the wiki in the hope to clarify this issue 
> (see 
> http://wiki.services.openoffice.org/wiki/Calc/To-Dos/Usability#Duplicate_Data).

Yes, that in combination with i66817 clarifies.

> What we need is a bidirectional reference that links cells A1 and B1, so 
> that when I change B1, this change is reflected in the value stored in 
> A1, too. This is like a Unix Hard-Link! A1 and B1 should be hard-linked.

Nice idea, but I doubt we'd implement that soon. Apart from that, a hard
link to a cell containing a formula should be prevented, and entering
a formula in A1 would have to break all hard links pointing to A1 and
change them to "soft-linked" usual cell references. To me this appears
as a new source of user confusion.

> Please note, that we may have many B1-cells (copies of the original 
> data), so we need to change every single value (IF we do not have 
> references in place, BUT copied only the data). For different 
> spreadsheets, we may use the link-function. BUT:
> 
> If we link to a cell that contains a formula or a reference, the result 
> is devastating. Lets say, in document 1 we have a column named MySum, 
> where each cell is =SUM(Ax:Bx)
> 
> Now we link from a different document 2 to this column. What we actually 
> get is =SUM(AxBx), but Ax and Bx refer to this new spreadsheet, not the 
> original one, where these values are stored.

I don't follow here. When linking to another document you get copies of
the results of the cells linked to, not the formulas themselfs. So you
still get SUM(Ax:Bx) of the original data.


> I have posted another issue (see 
> http://www.openoffice.org/issues/show_bug.cgi?id=80325) detailing some 
> of the track changes issues.

Surely useful.

  Eike

-- 
 OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
 SunSign   0x87F8D412 : 2F58 5236 DB02 F335 8304  7D6C 65C9 F9B5 87F8 D412
 OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
 Please don't send personal mail to this [EMAIL PROTECTED] account, which I use 
for
 mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] 
Thanks.

Attachment: pgpyUPnZtiBGu.pgp
Description: PGP signature

Reply via email to