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 -- 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]
