Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSat, 08 Dec 2018 18:25:14 +0100external data table updating problemhttps://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/ 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 youThu, 06 Dec 2018 12:44:52 +0100https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/Comment by Albert1976 for <p>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?</p>
<p>Thank you</p>
https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175557#post-id-175557Yes, 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.Sat, 08 Dec 2018 18:25:14 +0100https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175557#post-id-175557Comment by m.a.riosv for <p>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?</p>
<p>Thank you</p>
https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175535#post-id-175535Pls can you report a bug with a sample file? [LibreOffice feedback](https://www.libreoffice.org/get-help/feedback/)Sat, 08 Dec 2018 14:14:18 +0100https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175535#post-id-175535Comment by Albert1976 for <p>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?</p>
<p>Thank you</p>
https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175526#post-id-175526Hi 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.Sat, 08 Dec 2018 11:18:56 +0100https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175526#post-id-175526Comment by m.a.riosv for <p>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?</p>
<p>Thank you</p>
https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175377#post-id-175377Please what it's the file type, xlsx?Thu, 06 Dec 2018 22:50:31 +0100https://ask.libreoffice.org/en/question/175308/external-data-table-updating-problem/?comment=175377#post-id-175377