https://bugs.documentfoundation.org/show_bug.cgi?id=150414
--- Comment #4 from m.a.riosv <[email protected]> --- (In reply to Heiko Tietze from comment #3) > (In reply to m.a.riosv from comment #1) > > It is how it works. > It's at least surprising. In most cases you load just numbers but if I think > of rich text or html, overwriting the cell format sounds reasonable. But > should reloading external data also affect the formatting? I guess no, but it can be depended on the cases. > > > Or create a request for enhancement. > Two solutions come in mind: a checkbox "[ ] Keep cell format" and dedicated > cell style being kept. And I wonder if Data > Link To External Data and the > new Data Provider should behave the same. Third option is to apply a cell > style as an additional operation via the Data Provider. And last but not > least we could keep the formatting on reloading. The behavior it's the same as with Menu/Sheet/Insert sheet/ or 'Insert sheet at end' or 'Insert sheet from file', that check for 'Keep cell format' would really nice. -- You are receiving this mail because: You are the assignee for the bug.
