Bug 169542 - Data Provider upper left field missing if imported CSV is missing
Summary: Data Provider upper left field missing if imported CSV is missing
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
26.2.0.0 alpha0+ master
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Data-Provider
  Show dependency treegraph
 
Reported: 2025-11-19 17:11 UTC by Michael Otto
Modified: 2025-11-27 22:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
abc123.csv imported with Data Provider (9.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-11-19 17:11 UTC, Michael Otto
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Michael Otto 2025-11-19 17:11:31 UTC
Created attachment 204102 [details]
abc123.csv imported with Data Provider

PRECONDITION:
new Calc spreadsheet
Data > Define Range 
Data > Data Provider
  select Range, CSV, URL=abc123.csv 
  OK to import data
Save file --> attached abc123.ods

abc123.csv = simple 3 lines CSV file (from from #169541
https://bugs.documentfoundation.org/attachment.cgi?id=204101):
a1,a2,a3
b1,b2,b3
c1,c2,c3


PROBLEM DESCRIPTION:

remove or move abc123.csv to a different name
open saved file --> the upper left field is empty (NOK)

Data > Refresh Data Provider --> no message about missing file (NOK), 
    field A1 still missing (NOK)

move abc123.csv back to its original name
Data > Refresh Data Provider --> field A1 is recovered (OK) 


EXPECTED BEHAVIOR:
imported data shall still be visible if import source is not available


Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 480ef73deef62c458e5735cd496a1d74ef408ed8
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
Comment 1 Regina Henschel 2025-11-27 22:00:06 UTC
I see the missing content in the top-left cell too. It is missing although the table in the file has the content.

A refresh is done on opening the file without interaction with the user. In case the source is not available a warning should be shown to the user and the content should be shown as contained in the <table:table> element in file.

[BTW, the path to the csv file is always written as absolute path. That makes is impossible to exchange documents and it should be changed somehow. But that would be a separate issue.]