« I was thinking about prescription drugs over the weekend | Main| Ctrl-End and Ctrl-Home equivalents in Notes 8.5 »

How do you do absolute cell references in Lotus Symphony Spreadsheet

Category
An absolute cell reference is where the cell looks something like $B$1 instead of B1, absolute cell references allow you to copy the cells around the spreadsheet and still have them point back at the same cell, versus relative cell references which change when you copy and paste cells.

In Excel and 1-2-3 the key for changing absolute cell references to absolute was F4, in Lotus Symphony Spreadsheets is Shift-F4.

F4 doesn't appear to do anything in Symphony so not sure why they changed it.  Anyone that spends any time in Excel doing spreadsheets will find this a hindrance if they switch.

Posted by Carl Tyler On 05/28/2009 | | del.icio.us  Technorati  Digg This 

Comments

Gravatar Image1 - Try Shift+F4

Posted by George Paglia At 10:40:09 AM On 05/28/2009 | - Website - |


Gravatar Image2 - @1 Yes, you need to read the entire blog post Emoticon

Posted by Carl Tyler At 10:46:14 AM On 05/28/2009 | - Website - |


Gravatar Image3 - They probably didn't change it - it works the same way in OpenOffice and if Symphony has the same core ... Anyway, thanks for finding, I was used to write it on my own.
Anyway, do you know how to repeat an action? In Excel you can add one line and press F4 to add another and another. In Symphony?

Posted by Martin At 11:24:45 AM On 05/28/2009 | - Website - |


Gravatar Image4 - @3 You can assign it to a key in OpenOffice, but in Symphony I don't believe you can change/assign key assignments. So there is just the menu option, Edit, Repeat, but if you do thtat using the keystrokes Alt-E-R it clears the cell, so it's broke.

For OpenOffice choose
Tools - Configure - Keyboard and set F4 to edit, repeat

Posted by Carl Tyler At 11:55:13 AM On 05/28/2009 | - Website - |


Post A Comment

:-D:-o:-p:-x:-(:-):-\:angry::cool::cry::emb::grin::huh::laugh::rolleyes:;-)