https://bugs.documentfoundation.org/show_bug.cgi?id=115150
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #2 from Eike Rathke <[email protected]> ---
You need to use absolute references, otherwise the corresponding reference
(here rows) runs with the cell where the condition is applied. For example the
MAX(B1:B4) in cell B1 is MAX(B1:B4), but in cell B2 it is MAX(B2:B5), and so
on. So use MAX($B$1:$B$4) instead. Actually MAX(B$1:B$4) would be sufficient
which then could be copied to other columns using Copy&PasteSpecial (with
Formats only) or pasting entire cells, but may also be even more confusing.
--
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
