Bug 43350 - A calc spreadsheet alters a .csv file it is linked to, changing the data in the file to incorrect values.
Summary: A calc spreadsheet alters a .csv file it is linked to, changing the data in t...
Status: CLOSED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-29 14:29 UTC by alexander_thesoso
Modified: 2012-04-04 15:33 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description alexander_thesoso 2011-11-29 14:29:40 UTC
1) There is a .csv file (about 2000 lines long, each line containing N,M).  
2) There is an .ods spreadsheet with an automatically updated link, 2x5000, linked to the .csv file. 
3) With the calc program closed, and no libreoffice processes running, some data in the .csv file are deliberately changed, and the file saved.  The new data are verified. 
4) When the .ods file is opened, mysteriously, the data in the .csv file are changed to old historic values.  
5) If the data in the .csv file is externally changed, and the link updated, the .ods file shows the new data.  Both files have the new data.  
6)  See (4) Both files show up with old historical data anytime the .ods file is opened.  
7)  When new data is appended to the .csv file, it properly propagates into the .ods file.
8) Link:  
Application: soffice
File: C:\money\data\summarygraph.csv
Category: Sheet1.A1:B5000
9)  There is nothing in the spreadsheet that should alter the input data.
Comment 1 Eike Rathke 2012-04-04 15:33:25 UTC
Not reproducible using LibO 3.5.2 on Linux, assuming that with "linked" you meant using DDE() spreadsheet formulas, e.g.
=DDE("soffice","C:\money\data\summarygraph.csv","Sheet1.A1:B5000")

Closing as worksforme. If you can reproduce in LibO 3.5.x feel free to reopen and provide a test case document.