| View previous topic :: View next topic |
| Author |
Message |
pegasus.pete@gmail.com
Newbie
Joined: 22 Apr 2009
Posts: 2
|
 Posted: Wed Apr 22, 2009 5:05 pm Post subject: equivalent of MS Excel "paste special value" |
 |
|
| I have a MS Excel application which makes use of Copy, paste special, value of cells containing formulas where the current value needs to be locked in prior to changing or deleting cells referenced in the formula. In OO Calc the only option presented in paste special is "all". How do I achieve this functionality in OO Calc?[/b] |
|
| Back to top |
|
 |
keme
Moderator
Joined: 30 Aug 2004
Posts: 2745
Location: Egersund, Norway
|
| Posted: Thu Apr 23, 2009 12:58 am Post subject: |
|
|
| If you unselect "all", you will enable the other options. |
|
| Back to top |
|
|
pegasus.pete@gmail.com
Newbie
Joined: 22 Apr 2009
Posts: 2
|
| Posted: Thu Apr 23, 2009 2:03 am Post subject: paste special value |
|
|
| Many thanks for the quick and simple solution. |
|
| Back to top |
|
|
|
