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

Help with changing tranposed values to absolute

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


Joined: 25 Jan 2006
Posts: 144
Location: Ottawa, Canada

PostPosted: Sat Aug 05, 2006 12:39 pm    Post subject: Help with changing tranposed values to absolute Reply with quote

My treasurer has transposed a spreadsheet, but when he tries to shift-F4 to change the values from "=TRANSPOSE()" to what they actually are, it says that it can't change part of an array. I'm not sure what this means. Is it a bug? Is there a workaround?

We went back and pressed Shift-F4 as soon as we did the transpose function, so that the entire array was selected, but no luck.

Any help?

Thanks,

- RG>
_________________
Quite simply, OOo Impress, does not.

XPsp2, OOo 2.3, SeaMonkey 1.1.7, IE v.6.6.6...
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat Aug 05, 2006 1:34 pm    Post subject: Reply with quote

An array function is a single formula. In this case it spreads over the entire range. You can not edit a single cell of this block.
Shift F4 toggles the relative/absolute/mixed status of all references in the active cell only. Try with simple formula =A1 or any other single formula. In edit mode you may toggle a selected part of a formula.
If you want to edit or delete an array you need to select a range including the entire array. Then you are able to edit the formula of the active cell and re-enter with Ctrl+Shift+Enter.
Select the array around the active cell: Ctrl + / on num pad
However, changing relative/absolute/mixed status of an array is pointless. A1:B5 is the same as $A$1:$B$5 in every element of the array.
_________________
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