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

Spreadsheet problem

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


Joined: 01 Feb 2005
Posts: 11
Location: UK

PostPosted: Sun Feb 18, 2007 4:22 pm    Post subject: Spreadsheet problem Reply with quote

Probably very simple to those who actually know how to use spreadsheets properly - I'm trying to do the following:

Select a range of cells that contain fixed numeric values.
Update all those values by a fixed percentage, defined in a given cell, so that the updated values appear in the original cells.

I don't want to add extra cells to hold the updated values - I know that this is the simple solution but for various reasons I must have the original values replaced in the original cells.

I assume I need to use some sort of macro to do it, but cannot actually see how to make this happen.

All advice, guidance or solutions gratefully received.
Back to top
View user's profile Send private message
purbeck
General User
General User


Joined: 01 Feb 2005
Posts: 11
Location: UK

PostPosted: Sun Feb 18, 2007 4:25 pm    Post subject: Reply with quote

Please ignore - posted in the wrong forum because it's late and I'm tired... now reposted in Calc.
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 Writer 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