Bug 43350

Summary: A calc spreadsheet alters a .csv file it is linked to, changing the data in the file to incorrect values.
Product: LibreOffice Reporter: alexander_thesoso
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED WORKSFORME QA Contact:
Severity: major    
Priority: medium    
Version: 3.3.2 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
i915 platform: i915 features:

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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.