Calc =""+1 shows error #VALUE or err:529
Bug #210153 reported by
Christoph Roeder
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenOffice |
Invalid
|
Undecided
|
Unassigned | ||
libreoffice (Ubuntu) |
Opinion
|
Wishlist
|
Unassigned | ||
openoffice.org (Ubuntu) |
Won't Fix
|
Wishlist
|
Unassigned |
Bug Description
Binary package hint: openoffice.org
Since I upgraded to hardy I can't use the spreadsheet from [1] because I get an error 529 in some cells.
The problem is that you can't get the sum of a cell which is empty (""), this worked in OOo 2.3!
I attached a simple example which should show the problem. (the important cells are: A2 and B2)
PS: I use OOo version: 2.4.0rc2-1ubuntu3
[1] http://
Changed in openoffice.org: | |
importance: | High → Critical |
Changed in openoffice: | |
importance: | Undecided → Unknown |
status: | New → Unknown |
Changed in openoffice: | |
status: | Unknown → Confirmed |
Changed in openoffice: | |
status: | Confirmed → In Progress |
Changed in openoffice: | |
status: | In Progress → Fix Released |
summary: |
- [upstream] calc: sum show #VALUE or err:529 + [upstream] [3.2] calc: sum show #VALUE or err:529 |
Changed in openoffice.org (Ubuntu): | |
status: | Opinion → Won't Fix |
To post a comment you must log in.
Yeap, I've just seen that, so I can confirm.
It has never happened before in any previous versions.
For the moment I've just replaced a few formulas inserting 0 instead of "", but that's not the expected behaviour, isn't it?