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 Thu August 3 2006 01:24, Jojo Wan wrote:
> Hi,
>
> I had been an Excel user and wanted to shift to OpenOffice. I first
> tried a Kubuntu LiveCD and was impressed that OO-Spreadsheet (which is
> Calc) is quite good. It got the auto-filter and some simple formula
> functions which I often use in Excel.
>
> Unfortunately, when I installed OO 2.0.3 under Windows, the auto-filter
> isn't the same as what I experience under the LiveCD.
>
> Here are the issues which I hope you guys can help:
>
> MULTIPLE FILTER
> - I do auto-filter under column A, B. With these data... Column A
> (1,1,2,2,3,3,4,4) Column B (A,B,C,D,E,F,G,H). When I filter column A
> to show all 1s it shows 1,1 and A,B which is correct, but when I click
> on the down arrow for the filtering under column B, it showed me A to
> H. Under LiveCD and Excel, it should show me only A and B.
>
> FILTER CONDITION
> - under LiveCD and Excel, I can do custom filter and choose all entries
> that BEGINS with, ENDS with, CONTAIN specific characters, but under
> OO2.0.3 Windows, I don't have these options.
>
> FILTER GONE
> - there are times when I do filter, all the headers rows went out or
> hidden. I have to undo and redo to make it NOT disappear.
>
> I do need help on this one.
>
> Jojo W.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
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]