https://bugs.documentfoundation.org/show_bug.cgi?id=150414
Cor Nouws <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|6.0.0.3 release |Inherited From OOo --- Comment #16 from Cor Nouws <[email protected]> --- Reading all info and ideas, I clearly support Carstens expectation: - I suggest that refreshing linked data, does not overwrite the applied formatting. - And clarifying the Help would be good to. AFAIK, there are various quite different ways to get 'external' data. 1. Sheet > External Links uses no formatting (plain data) but currently, refreshing overwrites applied cell formatting 2. Edit > Paste Special with data from within the application; (='file:///xx/yy.ods'#$Sheet1.A3:E36 either with or without formatting from the source 3. Navigator > Select different file at bottom > Drag named range (copy or link..) does use the source formatting NB: Edit > Paste Special, with external data, opens the text import dialog (known from CSV) and is not a link (and also without formatting). Some Help (partly additional to what Stéphane mentioned): https://help.libreoffice.org/24.2/en-US/text/shared/01/02180000.html?&DbPAR=CALC&System=UNIX https://help.libreoffice.org/24.2/en-US/text/scalc/01/04090000.html https://help.libreoffice.org/24.2/en-US/text/scalc/guide/cellreferences_url.html?DbPAR=CALC https://help.libreoffice.org/24.2/en-US/text/scalc/guide/cellreference_dragdrop.html?DbPAR=CALC https://help.libreoffice.org/24.2/en-US/text/scalc/guide/webquery.html?&DbPAR=SHARED https://help.libreoffice.org/24.2/en-US/text/shared/00/00000208.html?&DbPAR=SHARED&System=UNIX -- You are receiving this mail because: You are the assignee for the bug.
