Cannot calculate wildcards in MS excel sheets
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
In Progress
|
Unknown
|
|||
libreoffice (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Low
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
When opening an MS excel sheet with wildcards used in an IF statement the Microsoft version recognises it and uses it in the calculation, but OpenOffice.org doesn't, with the result the value been set to 0. Here's an example:
In row 2 we've got a number of cells with codes in it, let's say B2...L2. In an other cell there's the formula =(COUNTIF(
This bug also includes the =(COUNTIF(
An example sheet is listed here:
http://
To get OpenOffice more compatible with importing MS Office documents these options should be implemented.
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → New |
Changed in openoffice: | |
status: | Unknown → In Progress |
Changed in openoffice.org: | |
status: | Confirmed → Triaged |
tags: | added: hardy |
Changed in openoffice.org (Ubuntu): | |
status: | Incomplete → Won't Fix |
summary: |
- [Upstream] [hardy] OpenOffice.org isn't able to calculate wildcards in - MS excel sheets + Cannot calculate wildcards in MS excel sheets |
Confirmed on Ubuntu Hardy with openoffice.org 1:2.3.1-3ubuntu3