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.
pgpyUPnZtiBGu.pgp
Description: PGP signature