RealGrouchy
OOo Enthusiast
Joined: 25 Jan 2006
Posts: 144
Location: Ottawa, Canada
|
 Posted: Sat Aug 05, 2006 12:39 pm Post subject: Help with changing tranposed values to absolute |
 |
|
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... |
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sat Aug 05, 2006 1:34 pm Post subject: |
|
|
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 http://forum.openoffice.org |
|
