https://bugs.documentfoundation.org/show_bug.cgi?id=98062
Bug ID: 98062
Summary: Calc's entire column reference breaks column stats
calculation
Product: LibreOffice
Version: 4.4.5.1 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
I always create column stats directly under the column name (not the header) if
possible, like §=SUM(D3:D)§ in Google Sheets format which sums the colum D
starting from row 3 until the end, which in Google Sheets' case is limited by
count of rows unlike, likely, every other spreadsheet software; D1 is the
column name and D2 is the column stats cell.
This is absolutely broken by the absolutely stupidly thought entire column
reference system which seemingly comes from the OpenDocument Format itself; the
standard needs fixing. It wouldn't be much of an issue to reverse-engineer
Google Sheets' behaviour, and I'm sure it's nothing illegal to do either since
Calc is basically a reverse-engineered Excel without price tag.
--
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
