Am 30.11.2010 16:44, MOULIN Camille wrote:
Dear OOo Devs,
During random tests with IBM's Symphony, I realized that three of the most
annoying bugs in Calc's filters were actually fixed there.
Issue 89232 Fill operations should not touch filtered rows.
Issue 12666 autofilter works just on one sheet (only one auto-range per file)
Autofilter can even work with more than one list range on the same
sheet. Just invest the little extra effort to define your list ranges
(Data>Define...)
Issue 85305 Dynamically grow a filtered range for autofilter
I know that Symphony is not an open source project, but do you think it would be
possible to have those fixes upstreamed to OOo ?
Like with any other spreadsheet on the market, insertion/deletion of
rows will update all references to the affected range. This will
grow/shrink your data ranges, all formulas refering to your data ranges,
external references, conditional formatting, validation, form controls
and chart ranges.
As a matter of course, the database component is more adequate to work
with row sets.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
