Abraham wrote:
I have the latest update for Open Office 3. I am very pleased with it and I
am also fast learning how to use it. I am
E-mailing this contact because, as the subject implies, I need a direct
contact and response to solve this problem. If I am writing to the wrong
contact, I apologize and I would greatly appreciate your navigation of this
e-mail to the proper contact.
Both Lotus and Excel and have a function, Paste Special, which will change a
cell's content from calculations to Value Only (pure numbers or percents).
They can do this for columns, rows or areas of cells in which the content
consists of mixes of numbers and the calculations of numbers, percents (%),
currency, etc, using data from other cells.
Open Office also has Paste Special but I can't get as complete and easily
done a transition to Value Only.
Right now I have a column in an OpenOffice.Org Calc spreadsheet with a mix
such as the one described above. When I scan the column and click on Calc
Paste I get a list of options none of which I can apply to the WHOLE column.
All I can do is convert individual common sets to Value only, one at a time.
And, as I previously said, I have the same problem for mixes in rows and
areas of cells.
Are you saying the following process doesn't do what you want?
1. Select the cells in the desired area, column, or row
2. Copy via Ctrl+C or equivalent
3. Press Shift+Ctrl+V to bring up Past-Special
4. In the left-hand column, only Text, Numbers, and Date&Time should be
checked.
5. In the center column, only None and Don'tShift should be dotted.
6. Press Enter or click OK.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
