On Thu January 12 2006 16:33, + Mark Twenhafel wrote: > [ MODERATED ] *********************** > Hi-- > > Standard Disclaimer: Not on the list, but I check the gmane digest > several times per day. (Proof: Ginormous kudos to the *very* patient > moderators and regular experts on the list....you know what I mean!) > > Okay, here's my problem: I have a spreadsheet with cells that > calculate the account balance as a formula that subtracts the last > transaction amount from the previous balance. I.e., each transaction > is a row and the account grows downward. Works fine, except when I > subsequently want to cut-'n'-paste the *value* (not the formula!) of > the calculated cell, perhaps because I'm doing a snapshot report page > and want the static value. > > Seems that back in the Excel days, I used Excel's "Paste Special" > with the "Values Only" option to do this. Can't find the > functionality in OOo Calc. Am I just not seeing it, or is this > feature really missing?
As you are not subscribed you may not have seen that: On Thu January 12 2006 21:50, Dennis Marks wrote: > Paste special is on the edit menu or SHIFT CONTROL V. Just remove the check > marks that don't apply such as formatting and formulas. It will retain > these setting for the edit session. Please reply to [email protected] only. -- CPH : openoffice.org contributor Maybe your question has been answered already? http://user-faq.openoffice.org/#FAQ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
