Bug 98062 - Calc's entire column reference breaks column stats calculation
Summary: Calc's entire column reference breaks column stats calculation
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.5.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-21 19:48 UTC by Jouni Järvinen
Modified: 2016-02-22 08:25 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jouni Järvinen 2016-02-21 19:48:03 UTC
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.
Comment 1 Jean-Baptiste Faure 2016-02-22 08:25:04 UTC
Closing as INVALID.
Please, feel free to file another bug report if you are willing to do that in a civilized way. Don't forget to explain clearly what is the problem and give a step by step scenario to reproduce it. Finally attach a test document.

Best regards. JBF