On Thu August 17 2006 00:40, + mariopena33 wrote: > [ MODERATED ] ******************** > 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
As you are not subscribed you may not have seen that: On Thu August 17 2006 21:53, Andreas Saeger wrote: > > 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. > Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
