> I will look in my archive to see if I > saved it but you might be able to search the list archives and get > lucky. >
Found the following. Hope it helps. -------- Forwarded Message -------- From: Eike Rathke <[EMAIL PROTECTED]> Reply-To: [email protected] To: [email protected] Cc: [EMAIL PROTECTED] Subject: Re: [users] Range names in an url-linked calc spreadsheet Date: Fri, 11 Mar 2005 19:09:14 +0100 Hi Ennio-Sr, On Wed, Mar 09, 2005 at 19:13:11 +0100, Ennio-Sr wrote: > Now, if I add a new item in the original web-table (and do not make > space for this new row in the OOo table), that's what happens: > > Original web table, stage 2: > ______________________________________________________________ > | | A | B |.......... > -------------------------------------------------------------- > 1|Item a | | 10.15 | > 1a|item b | | 33.33 |--> new row in web table > 2|item c | | 22.30 | > 3|item d | | 3.12 | > > OOo.1.1.4 table resulting from Insert > External Data: stage 2 > ______________________________________________________________ > | | A | B |.......... > -------------------------------------------------------------- > 1|Item a | | 10.15 |--> appears as being rn_1 > 1a|item b | | 33.33 |--> " " rn_2 > 2|item c | | 22.30 |--> " " rn_3 > 3|item d | | 3.12 |--> former rn_3, now shown as B4 > > As you can see, the new row 1a takes the place formerly assigned to row > 2 and, of course, B2 priorly defined as rn_2, doesn't correspond to the > new value. I see.. but how should Calc know that suddenly in the web file the content of row3 now appears in a different row? > As I said it can be corrected inserting a blank row in the place that > will be occupied by 'item b' before updating the link. That's the only direct way. Or you'd have to write some wizard that compares already existing spreadsheet data with the web page and then applies some magic where it differs. However, you might try to import the web page into a second temporary spreadsheet document, save it to disk and close it, and then from the original document use menu Edit.CompareDocument and select the new document created. This results in a list of changes, of which you _reject_ changes to apply them to the original document, which also shifts ranges when rows are deleted/inserted. This method might give the right results or not, depending on the complexity of the data you import, try it out. Eike -- PLEASE KEEP MESSAGES ON THE LIST. OpenOffice.org Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
