Bug 98062

Summary: Calc's entire column reference breaks column stats calculation
Product: LibreOffice Reporter: Jouni Järvinen <jounijarvis>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED INVALID    
Severity: normal CC: jbfaure
Priority: medium    
Version: 4.4.5.1 rc   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:

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