Bug 156587 - Cell formatting on data from external link lost on update
Summary: Cell formatting on data from external link lost on update
Status: RESOLVED DUPLICATE of bug 150414
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-08-02 17:42 UTC by Kaan Büyükerdem
Modified: 2023-08-03 08:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
External link on top, normal values on bottom (4.27 KB, image/png)
2023-08-02 17:42 UTC, Kaan Büyükerdem 		Details
example csv file (8 bytes, text/csv)
2023-08-03 07:59 UTC, Kaan Büyükerdem 		Details
example ods file (9.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-08-03 08:00 UTC, Kaan Büyükerdem 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Kaan Büyükerdem 2023-08-02 17:42:23 UTC 
Created attachment 188733 [details]
External link on top, normal values on bottom
Comment 1 m_a_riosv 2023-08-03 00:45:03 UTC 
Sorry, but the image doesn't help too much here.
Please attach sample files, reduced as much as possible.
Comment 2 Kaan Büyükerdem 2023-08-03 07:59:19 UTC 
Created attachment 188737 [details]
example csv file
Comment 3 Kaan Büyükerdem 2023-08-03 08:00:17 UTC 
Created attachment 188738 [details]
example ods file
Comment 4 Kaan Büyükerdem 2023-08-03 08:02:13 UTC 
To repreoduce open example.ods add an external link to example.csv, the conditional coloring won't work.
Comment 5 Stéphane Guillou (stragu) 2023-08-03 08:36:43 UTC 
Reproduced, I did the following:
1. Open attached ODS
2. Check that link to CSV file is functional (allow updating linked data; if needed, Edit > Links to external file)
3. Copy conditional format from A2:D2 and apply it to A1:D1
4. Conditional format is applied as expected
6. Save and reload: format still there
7. Allow updating data from external file

Result: conditional format on linked cells is lost

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 47ca3f1f762352b488d58b3bf23d5776576f1cca
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

...and 7.5.5.2.

In 7.4, conditional formatting couldn't even be applied on such a range.
Comment 6 Stéphane Guillou (stragu) 2023-08-03 08:42:30 UTC 
(In reply to Stéphane Guillou (stragu) from comment #5)

> In 7.4, conditional formatting couldn't even be applied on such a range.

Correction: conditional formatting could be applied, but copying the formatting from range A2:D2 and pasting it onto A1:D1 would fail.
Comment 7 Stéphane Guillou (stragu) 2023-08-03 08:56:05 UTC 
Actually, any formatting applied to the cells is lost, and formatting is not even copied when linking from, say, a formatted ODS. Same in 6.0.
Similar issue in bug 150414, with more discussion, so marking as a duplicate.

*** This bug has been marked as a duplicate of bug 150414 ***