[Issue 126734] Allow Open Office to take A:A style input, which select the entire row/column

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126734

CodeLurker <st...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |strideroflands@yahoo.com

--- Comment #2 from CodeLurker <st...@yahoo.com> ---
This is an important issue.  As pointed out here,

https://bugs.documentfoundation.org/show_bug.cgi?id=44419

"See OpenFormula 5.8. This is a valid reference according to OpenFormula/ODF
1.2:

B:B, 3:15, ...".

This means that it is part of the open document specification.  The chat there
points out that in importing an Excel spreadsheet with such a formula,
LibreOffice had been changing such references into either formulas with errors
in them, or worse yet, formulas with different meanings, which yielded
different results with no warning.  They ask, would you edit your tax records
in LibreOffice in such a condition, and then send it on to your accountant?

This is marked as lowest priority; but it is a failure to be ODS compatible! 
It seems a higher priority is in order.

Note that the problem was fixed 2015-12-15 on the Libre Office side.  I haven't
compared with LibreOffice bugs before, but this seemed important.

TO CONFIRM:
1. Go to cell A1.
2. Type in "=SUM(B:B)".

RESULT:
#NAME?

EXPECTED RESULT:
The sum of any numbers in the B column

Note that this also includes things like clicking on a column header when in a
formula, and getting e.g. "B:B" in your formula, and things like "=SUM(A:E)". 
If this patch does this, I suggest it be applied.

-- 
You are receiving this mail because:
You are the assignee for the issue.