https://bugs.documentfoundation.org/show_bug.cgi?id=39109
Mark Hedges <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|CLOSED |REOPENED
Resolution|WORKSFORME |---
Ever confirmed|0 |1
--- Comment #2 from Mark Hedges <[email protected]> ---
The problem seems to be if the "empty pages" actually have cells with formulas
in them that yield empty strings.
Take a sheet with A1=1, A2=2, A3=3; B1-B100 => =IF(Ax,Ax,"") where x is row
num.
Result is B1, B2, B3 contain A1, A2, A3 and B4-B100 contain empty strings.
However, all rows B1-B100 will be printed.
Only B1-B3 should be printed because the rest are empty. Empty string means
empty. There is no content there.
Or, if they were zeros, then they should not be printed if "print zeros" is not
selected.
This is useful to create a general calculator sheet template that has room for
several hundred entries, for example, with the formula already pasted in for
each row ... but maybe on this copied instance of the sheet I only have 5
entries. Categorized profit and loss statements or other financial
projections, for instance.
Thanks.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
