https://bz.apache.org/ooo/show_bug.cgi?id=126734
CodeLurker <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #2 from CodeLurker <[email protected]> --- 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.
