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

Extend Range Syntax

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


Joined: 02 Nov 2006
Posts: 2

PostPosted: Thu Nov 02, 2006 5:45 pm    Post subject: Extend Range Syntax Reply with quote

I'd like to be able to express
PRODUCT(1+A1/100;1+A2/100;1+A3/100;1+A4/100)
as
PRODUCT(1+A1/100:1+A4/100)
(notice change from semicolon to colon).
The purpose is twofold: simpler expression and automatic function change if a new row is inserted.
I think this would be a useful extention for future releases of oocalc.
Is there any way something similar to this can be accomplished now, without being more trouble than it's worth?
Back to top
View user's profile Send private message
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Fri Nov 03, 2006 12:17 am    Post subject: Reply with quote

I think you could try:

=PRODUCT(1+A1:A4/100)

but instead of pressing Enter, press Ctrl-Shift-Enter, and this enters it as an array function, and automatically adds the { and } around it.

I'm not sure if this is what you want, or if it actually works.

(My usual approach would be to add another column with 1+A1/100, fill donw, then get the product of the new column.)
Back to top
View user's profile Send private message
ChrisMaple
Newbie
Newbie


Joined: 02 Nov 2006
Posts: 2

PostPosted: Fri Nov 03, 2006 10:40 am    Post subject: Reply with quote

Thanks, this works perfectly, and greatly enhances my understanding of how to do things in oocalc.
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