https://bugs.documentfoundation.org/show_bug.cgi?id=163192
--- Comment #9 from Andreas Säger <[email protected]> --- Let me put it this way: In no practical use case, there is any reason to not check these options. IMHO, these 2 options should not even exist. When "Keep formatting" is off, every refresh of the database range removes the spreadsheet formatting. Adding some formatting to linked database data (including csv) is one reason why anybody drags a record set into Calc. When "Insert/Remove" is off, every refresh of the database range will not resize any references to the database range, possibly overwriting adjacent data and formulas. The automatic adjustment of import ranges makes this way of linking superior to all the other ways of linking. With this option turned on, your spreadsheet remains fully intact when the size of your refreshed record set has changed. No "totals row" will be overwritten, making that option obsolete as well. -- You are receiving this mail because: You are the assignee for the bug.
