https://bugs.documentfoundation.org/show_bug.cgi?id=163192
Bug ID: 163192
Summary: Default options of database ranges
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
When you drag a database query or table into a spreadsheet, Calc generates a
database range "Import1" with both options "Keep formatting" and "Insert/Remove
Cells" unchecked.
"Keep formatting" takes care that your spreadsheet formatting survives the next
refresh.
"Insert/Remove Cells" prevents that adjacent data are overwritten on refresh
when the database row set has increased. And it prevents that adjacent data are
left in empty sheet space when the row set has decreased.
You always want these two options being checked. I can not imagine any scenario
where it would make sense to uncheck any of them.
These options are checked by default when you create a database range manually.
How does this make any sense with an unlinked (not refreshable) db range?
Answer: When you copy the result of a sort or filter operation to another
sheet, option "Insert/Remove Cells" makes a difference. Again, you never want
to turn this off. I can't find any effect of "Keep Formatting" with unlinked db
ranges.
Please, check these options for linked import ranges per default. IMHO, they
should not exist anyway.
--
You are receiving this mail because:
You are the assignee for the bug.
