https://issues.apache.org/ooo/show_bug.cgi?id=125867
Issue ID: 125867
Issue Type: DEFECT
Summary: formulae with inverted cell range not
corrected/resolved until file is saved and reopened
Product: Calc
Version: 4.1.0
Hardware: PC
OS: Linux64
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: editing
Assignee: [email protected]
Reporter: [email protected]
formulae with inverted cell range not corrected/resolved until file is saved
and reopened;
- create a new spreadsheet
- create column A containing random text some of which is repeated, eg cells
A1:A10; sdcsdv, dfv, dfv, fdv, dfv, dfv, dvffd, dfv, dvffd, dvffd
- add this formulae to B2: =IF(MATCH(A2;A1:A$1;0);1;0) [issue doesn't occur
with =IF(MATCH(A2;A$1:A1;0);1;0)]
- copy and paste (or drag) formulae into remaining B cells
- note that the values in the formula have been correctly incremented for each
cell (and the red and blue coloured boxes are highlighting these correctly)
- note the formula is not however being resolved correctly in any cell (in
column B)
- save calc file (eg file.ods) and reload file
- note the formulae cell range definitions have have been corrected (inverted)
in all B cells except B2; eg =IF(MATCH(A3;A2:A$1;0);1;0) has become
=IF(MATCH(A3;A1:A$2;0);1;0)
- note the formula is now being resolved correctly in all cells (in column B)
I recall encountering this issue in the past without the MATCH function, so it
is probably a more general issue. Possibly calc functions do not accept
inverted cell range input? If this is the case then shouldn't calc throw an
error?
Note the issue does not occur the same way when the formula is created in B3;
- create a new spreadsheet
- create column A containing random text some of which is repeated, eg cells
A1:A10; sdcsdv, dfv, dfv, fdv, dfv, dfv, dvffd, dfv, dvffd, dvffd
- add this formulae to B3: =IF(MATCH(A3;A1:A$2;0);1;0)
- copy and paste (or drag) formulae into remaining B cells
- note the formula is not being resolved correctly in any cell (in column B)
- save calc file (eg file.ods) and reload file
- note that no changes to the formulae have been made by calc
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
