* Eike Rathke <[EMAIL PROTECTED]> [110305, 19:09]:
> 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
> > [...]
> I see.. but how should Calc know that suddenly in the web file the
> content of row3 now appears in a different row?
>
Ok, that's my fault in thinking it could: it was a long time I didn't
use a spreadsheet that way and I'd forgotten that the correct way is to
make space for the new row (as I did with Lotus ME).
> > 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.
>
Ok, thanks for the hint: I'll use it sometime ...
Regards,
Ennio.
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
