external data table updating problem [closed]

asked 2018-12-06 12:44:52 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have a sheet created in excel on windows and then exported to .ods, on a Linux PC I modified this file importing external tables taken from a website, if I save and update this data on the linux pc no problem, if I pass the file to a pc windows libreoffice I open the file and update everything ok, I save and I go out, the next reopening of the file when I update the tables lose the formatting or are moved lines or some lines totally deleted. What can you depend on? is there any incompatibility between win and linux version or could the original excel file be the one to create this problem?

Thank you

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-04 17:26:54.145536


Please what it's the file type, xlsx?

m.a.riosv gravatar imagem.a.riosv ( 2018-12-06 22:50:31 +0100 )edit

Hi Marisov ,

thank you for your answer,

no I tried saving in any format xsl, xlsx, ods. But I did a further test, or recreated the sheet with libreoffice of windows .ods files and even so the tables when they are updated lose the formatting and are deleted or moved. I think it's a defect of the windows version, because this is not the case on linux.

Albert1976 gravatar imageAlbert1976 ( 2018-12-08 11:18:56 +0100 )edit

Pls can you report a bug with a sample file? LibreOffice feedback

m.a.riosv gravatar imagem.a.riosv ( 2018-12-08 14:14:18 +0100 )edit

Yes, where can I upload the file?

one more question , is possible create a macro that only updates the external links on the corresponding page and not all those on the sheet. example: cell B2 is a list of the type Sheet_1, Sheet_2, Sheet_3, depending on what you have in B2 the button updates the external links of the corresponding sheet.

Albert1976 gravatar imageAlbert1976 ( 2018-12-08 18:25:14 +0100 )edit