OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Minor Issue with Interpretation of Expression

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
jcobban
General User
General User


Joined: 20 Apr 2009
Posts: 33

PostPosted: Mon Apr 20, 2009 8:19 am    Post subject: Minor Issue with Interpretation of Expression Reply with quote

My spreadsheet has a column containing expressions of the following format:
=DECIMAL(O75;10)-DECIMAL(O74;10)
where 74 is the current row number. In other words the field is supposed to contain the difference between the next and current row values of column "O".

When I save and re-open this spreadsheet every cell containing this expression displays the value "#MACRO?".

This is only a minor annoyance. I just force OO to reevaluate the expression by modifying one cell and then copying the expression to all of the other cells in the column. However I would appreciate not having to do that step every time I open this spreadsheet.

I am running OO.org.2.4.1 on Ubuntu and Windoze.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Apr 20, 2009 8:34 am    Post subject: Reply with quote

Works for me. I always save ods files. DECIMAL(A1;10) is the same as A1, by the way.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Mon Apr 20, 2009 8:53 am    Post subject: Reply with quote

Looking at my work PC with Excel 2003, I couldn't see the DECIMAL function. Thus If you save as an xls file, then I guess it would be marked in the Excel file as a Macro, then when re-opened, Calc would see it as an Excel Macro and not recognise it.

I'd suggest using some other equivalent but more portable function.

But I might be talking rubbish...
Back to top
View user's profile Send private message
jcobban
General User
General User


Joined: 20 Apr 2009
Posts: 33

PostPosted: Mon Apr 20, 2009 6:53 pm    Post subject: Reply with quote

Villeroy wrote:
Works for me. I always save ods files. DECIMAL(A1;10) is the same as A1, by the way.


I tried just referencing the cells but the subtraction failed. I had to wrap the DECIMAL function to force the value to be interpreted as a number rather than a string. The problem, as pointed out by another user is that the DECIMAL function does not exist in Excel, but I have to save the spreadsheets in .xls format for them to be read by clients without OO. I will just have to keep trying to find a workaround.

Thank you all.
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Mon Apr 20, 2009 9:45 pm    Post subject: Reply with quote

VALUE converts number to string.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group