https://bugs.documentfoundation.org/show_bug.cgi?id=117600
Bug ID: 117600
Summary: CALC AutoFilter Breaks line count affecting print
preview, physical print and row count for a user
selected block
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: that.man.co...@gmail.com
Description:
Enabling AutoFilter and then selecting some filter parameters sets what appears
to be a random page break both in the on-screen print preview and the actual
printed document. I suspect the false page break is related to where it should
have been if the data had not been filtered. When the filtration is applied,
the "valid" page breaks become anchored to the new on-screen virtual row
locations of the filtered data.
When the filter is removed, the page breaks remain anchored in the wrong
locations, resulting in variable depth pages.
The effect can then be seen by switching to print preview mode and scrolling
through the pages.
Printed output is similarly erroneous.
Additionally, if a filter is applied, the line numbers are adjusted to reflect
the true line positions in the table but if a contiguous block of data elements
is selected by cursor marquee then the count of rows indicated at the foot of
the display identifies the number of rows in the table between the first and
last element as opposed to the number of visible rows physically selected.
Steps to Reproduce:
Build a data table and view it in print preview to ensure the page breaks are
correctly located. Physically printing will confirm the integrity
Select top row of the data table and AutoFilter
Apply any filtration on any column(s) that will change the order of the data
Observe that the physical table line numbers are still reproduced in the row
numbers alongside the table. eg 1,3,7,11,99,125,156,175, etc,.
Select contiguous columnar cells in the visible table and verify that the
indicated count of rows is the number of rows between all the records in the
table NOT the selected group. The above example would produce 175 as opposed to
8.
Nullify the filter by whatever method best pleases you - re-sort on column one,
cancel all filtration in the menu, select the filtered column and "undo" the
filter.
I have attached a CALC sheet with the same data table replicated on two tabs.
The first tab has had the filter applied and removed and demonstrates the false
anchoring.
The second tab shows the data in never filtered form.
Print preview will demonstrate the effect.
Interestingly if the source data on the affected tab is cut and pasted to a new
tab then the filter anomaly is expunged. This permits the easy replication of a
"clean" table for experimentation.
Actual Results:
The page breaks become inconsistent with the actual number of lines on a page
and are variable - presumably based upon the relocation of the original correct
row page breaks
Expected Results:
Print preview to show properly configured pages.
Physical print to produce properly configured pages
Selection of contiguous rows to show the count of rows selected NOT the count
of rows between first and last record number in the selection
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.0.3.2 (x64)
Build ID: 8f48d515416608e3a835360314dac7e47fd0b821
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: sv-SE (en_GB); Calc: group
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:60.0) Gecko/20100101
Firefox/60.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
