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.
"Mark Twenhafel" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 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? > > System Specifics: OOo 2.0 on OS X 10.4.3. > > Thanks, > Mark --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
