Please do *not* start a new question by replying to an old one as this causes
several problems:
1) most email software will correctly think that your email is a response to
the email you are "replying" to, and will indicate this by displaying your
email as a child of the original email
2) because of this, people not interested in the original email may ignore
your question
3) people may think that the original email has a reply(yours) so that they do
not have to give it a reply
So in conclusion, more people will read your email if it looks like the start
of a new thread rather than the reply to an old one.
On Mon December 11 2006 20:59, James Busser wrote:
> Hi,
>
> Using OpenOffice (Sheet) I am trying to copy a grid (14 columns x 13
> rows) of information from an Excel (Mac) spreadsheet and Paste
> Special (just the values) into another Excel(Mac) spreadsheet. The
> data includes calculated results, dates, text strings.
>
> I want to Paste Special in Sheet, so I can remove any dependence on
> the original data, but I want to keep the formatting and results of
> calculations. However the only way that I seem able to do it is by
> having to check-box the Link option which gives me dependence of
> which I sought to rid myself!
>
> Sort will not work on any selection within this pasted data. How can
> I sort?
>
> For now I have had to do my Paste Special inside an Excel document,
> save that document, then open it in OO and because Sheet is then
> seeing and working with unreferenced (raw) data is will sort in the
> ay that I want it to.
>
> I don't know if these are Mac-specific problems, I am using a new
> MacBook (Intel Core Duo) 10.4.8 with
> OOo_2.0.4_MacOSXIntel_install.dmg under X11.
--
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]
