https://bugs.documentfoundation.org/show_bug.cgi?id=162521
Bug ID: 162521
Summary: CSV files are read wrong if data is changed externally
(column structure is maintained even though they might
have shifted)
Product: LibreOffice
Version: 7.0 all versions
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Hi,
tis is an easy to reproduce and fix bug, but for us at the office quite fatal
(I do not know how long the problem exists, but at least the last year maybe
forever).
We are using a CSV-Address Database as it's the easiest one that can be auto
exported from our CMR.
It imports fine, BUT whenever the data is externally changed the column
positions are not updated, but instead the data is read again at the old
locations.
Example
When I change
"Pet", "Miller"
"Michael", "Cain"
to
"Peter", "Miller"
The data read changes from
Pet Miller
Michael Cain
to
Pet "Mill
"Micha "Ca
To compensate this I tried to reload the database, dismissing and releasing the
connection (in Basic) etc. but the only thing fixing this is that I create a
new database using the same data (programmatically) and it works again.
I would be fine if the forced re-read would actually reread the data (including
the column update), but even better would be that if the file has changed you
would update automatically. Most companies don't have many DBs so holding a few
file observers is not a big deal.
--
You are receiving this mail because:
You are the assignee for the bug.
