Hi Leonard, On Sunday, 2007-08-12 00:40:21 +0300, Leonard Mada wrote:
> [... hard links ...] > Implementing this is surely a complex task, but I am sure it is doable. Almost everything is implementable, it's a matter of resources, time and prioritization. > There are two ways to link to external data: > 1.) The Menu-entry : 'Insert' -> 'Link to External Data...' > - this does NOT work with formulas. Maybe I am doing something > wrong, but I could not get it to work. > - tried it with OOo 2.3 dev (222?) and still no success. > - formulas (and named ranges) point to current document cells, > and NOT to the original-document cells, > therefore they are non-functional True, the formulas are imported, which I think is wrong. Instead, the results should be imported, IMHO, or the formulas only if they refer to data entirely within the copied range. Not sure at the moment though if and why, if at all, it was specified this way. > 2.) Linking directly through writing a reference to the particular > cell in the original document, e.g. > type in a cell in the new document: '= > _original_document_#_cell_to_be_referenced_' > - this works, but is more cumbersome This is what I was talking about. It should be enhanced to work with ranges as well, which requires some major refactoring the way external references are handled in their entirety though. 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.
pgpTYkDcj882H.pgp
Description: PGP signature
