You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2015/12/14 04:20:41 UTC
[Issue 126734] New: Allow Open Office to take A:A style input, which
select the entire row/column
https://bz.apache.org/ooo/show_bug.cgi?id=126734
Issue ID: 126734
Issue Type: DEFECT
Summary: Allow Open Office to take A:A style input, which
select the entire row/column
Product: Calc
Version: 4.2.0-dev
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: code
Assignee: issues@openoffice.apache.org
Reporter: jatinshr001@e.ntu.edu.sg
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
Pathangi Jatinshravan <ja...@e.ntu.edu.sg> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jatinshr001@e.ntu.edu.sg
--- Comment #1 from Pathangi Jatinshravan <ja...@e.ntu.edu.sg> ---
Created attachment 85209
--> https://bz.apache.org/ooo/attachment.cgi?id=85209&action=edit
Patch to allow Open Office to accept full row/column input.
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
--- Comment #4 from orcmid <or...@apache.org> ---
The content of attachment 85209 has been deleted for the following reason:
IP provenance misunderstanding
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
Pathangi Jatinshravan <ja...@e.ntu.edu.sg> changed:
What |Removed |Added
----------------------------------------------------------------------------
Issue Type|DEFECT |PATCH
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Group| |security
CC|jatinshr001@e.ntu.edu.sg, |
|orcmid@apache.org, |
|strideroflands@yahoo.com |
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Reporter|1 |0
accessible| |
CC list accessible|1 |0
--
You are receiving this mail because:
You are the assignee for the issue.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by 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.
[Issue 126734] Allow Open Office to take A:A style input, which
select the entire row/column
Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126734
orcmid <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |orcmid@apache.org
Attachment #85209|1 |0
is patch| |
Attachment #85209|0 |1
is obsolete| |
--- Comment #3 from orcmid <or...@apache.org> ---
Comment on attachment 85209
--> https://bz.apache.org/ooo/attachment.cgi?id=85209
Patch to allow Open Office to accept full row/column input.
Following preliminary review, this patch has been archived pending future
reconsideration.
--
You are receiving this mail because:
You are the assignee for the issue.