Hi Ennio-Sr, On Tue, Mar 08, 2005 at 01:38:06 +0100, Ennio-Sr wrote:
> 1st problem: > I copied a list of shares in Sheet1 of a new spreadsheet (ss) and > established a link to an url (which gives the latest quotation) in Sheet > 2 of the same ss. > All works very nicely but ... > If I assign named ranges to each of the cells where the quotations are > and then add a new share (a new row) in the original URL table, when > sheet2 refreshes the link the new row disrupts the old ranges. > May be I found a way to avoid this: first insert a new blank row in > sheet 2 and then refresh the link, but perhaps there is a better way... I don't quite understand what you mean by "the new row disrupts the old ranges". Could you please give an example of what happens exactly, and the names you defined and the formulas you use? > 2nd problem: > When the link in sheet2 is refreshed, the new table will be copied on > the old one in such a way that this remains as a one-column table > underneath the freshly copied one: ? Please give an example. > deletion of that column causes, of > course, the left shifting of all range names! [So, one reason more to > find a way to refer to a cell in another sheet (on the same ss) by range > name instead of by cell ref (ColumnRow)] (*) If you don't want references of named ranges be adapted according to deletions and insertions, use relative addressing instead of absolute. For example, define a named range as $Sheet2.A1:B4 instead of $Sheet2.$A$1:$B$4 > Before doing the link-refresh I saved-closed the ss and re-opened it > answering 'yes, do refresh the link'. Didn't find a way to do that > without re-opening the file. Menu Edit.Links, Update. Eike -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
