mariopena33 wrote:
I am using version 1.1 of OpenOffice.org. My problem is excel spread sheet
files .XLS : We have microsoft excel 2000 at work. The Open Office software
opens the excel file, but some of the formula boxes in the spread sheet
displays an ERR:503
After entering the needed information, the calctulations should automatically
appear in the space i get the err:503. So upon openning the file I get an
err:503 on some of my spread sheet boxs. When I enter any numbers to be
calculated the err:503 dissapears and a value of $1,500.17 apears in the
box.Where that number comes from. I don't know. Is there a fix for this? If so
please explain How i can fix this issue.
Mario
Unfortunately it is hard to answer since you did not provide the formula.
Help on Err503: Division by 0, or another calculation that results in an
overflow of the defined value range.
So you don't have a number in the referred cell. Excel is much too
tolerant with this, whereas Calc treats all text as such, which
evaluates to zero in arithmetic context. I consider calculated numbers
as text as bad spreadsheet design.
Solution 1:
Change the reference to the text cell A1 to VALUE(A1) in order to
enforce an explicit conversion of text.
Solution 2:
Convert the text-values to numbers:
Select the range(s) to be converted
Make shure the cell are not formatted as text:
Format>Cells>Numbers>"Default" or any other numeric format.
Edit>Find/Replace
Button "More Options"
Check "Current Selection"
Check "Regular Expressions"
Search: .+ [wich stands for anything not empty]
Replace: & [which stands for the matched item itself]
This "retypes" any existing cell-value within the current selection.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
