https://issues.apache.org/ooo/show_bug.cgi?id=125788
Andreas Säger <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Andreas Säger <[email protected]> --- Tables are "database ranges". But database ranges are not fully implemented. 1. Database ranges should expand calculated fields on insertion. 2. Database ranges should insert and delete rows within their own area. 3. Database ranges should obsolete Tools>Options>Calc>General "Expand references ..." 4. Database ranges should NOT copy the header formatting when inserting below the header row. 5. Database ranges should remember their filter settings even when you turn off the filter temporarily (like Base does). On the other hand there is the most useful Base component which gives a lot more than alleged table ranges on spreadsheets. When a database range in Calc is linked to a true database row set, point 1 and 2 are well implemented, 3 and 4 are not issues anymore and for point 5 there are additional ways to filter and unfilter a list (and use them in Calc or not). Since virtually "nobody" is able to develop even the most simplistic database, I developed a macro driven solution for the spreadsheet addicted: https://forum.openoffice.org/en/forum/viewtopic.php?f=21&t=2350 (Expand list ranges) which covers point 1, 2 and 3 even when no database range has been defined using the concept of "current region". I have another unpublished macro which addresses point 5 which makes use of the fact that the range address of a criteria range is preserved in the FilterDescriptor of a db-range after you removed the filtering. -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
