Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
Martin Thanks a lot ...it's solved... thanks Regards, Sudha Bharathan On Fri, 1 Mar, 2019, 8:45 PM Martin Groenescheij, wrote: > I mean > > Try filter 1: F = Irity > AND 2: N = 0 > OR3: F = Irity > AND 4: N = 10 > > > > > On 1 Mar 2019, at 16:13, Martin Groenescheij > w

Re: Multiple column filter

2019-03-01 Thread Brian Barker
At 17:50 01/03/2019 +0530, Sudha Bharathan wrote: I am unable to get the desired result ... I don't read minds: it would help if you explained what is your desired result! ... after the third filter is added on open office calc.(open office 4.1.6) 1. filter in column F 2.filter in column N 3.

Re: Macro Protected Spreadsheet

2019-03-01 Thread Andrew Pitonyak
Cannot see the image, I think that images are removed by the email list. I do not understand your problem, can you clarify (be more precise)? Now let me be more precise: When you say "password protected area", does this mean that portions of the spreadsheet are password protected so that you c

Spreadsheet option greyed out in Open Office

2019-03-01 Thread Richard Stephan
I've installed Open Office 4. Per the screenshot below, I see options for "Text Document," "Spreadsheet," "Presentation," "Drawing," etc. All of these options are grey out (and inaccessible) except for the "Text Document" option. I would like to use the spreadsheet option. Is there something I n

Re: Multiple column filter

2019-03-01 Thread Martin Groenescheij
I mean > Try filter 1: F = Irity > AND 2: N = 0 > OR3: F = Irity > AND 4: N = 10 > On 1 Mar 2019, at 16:13, Martin Groenescheij wrote: > > Try filter 1: F = Irity > 2: N = 0 > 3: F = Irity > 4: N = 10 > > > >> On 1 Mar 20

Re: Multiple column filter

2019-03-01 Thread Martin Groenescheij
Try filter 1: F = Irity 2: N = 0 3: F = Irity 4: N = 10 > On 1 Mar 2019, at 13:20, Sudha Bharathan wrote: > > Hi > I am unable to get the desired result after the third filter is added on open > office calc.(open office 4.1.6) > 1. filter in col

Macro Protected Spreadsheet

2019-03-01 Thread Mark Hodgen
Good Afternoon, We have been using Open Office spreadsheets for a few years. Our document manager who created the spreadsheet with Macros has since left, and now we have no access to update the passwords that the Macros set. Please advise if there is a workaround to accessing the Macro password

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Hmmm I am wrong. I can get either 0 or 10 but not both. I had mistyped when I looked at my sample data. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 8:37 AM Wade Smart wrote: > > I just recreated your list and without formatting

Re: Multiple column filter

2019-03-01 Thread Wade Smart
I just recreated your list and without formatting, it worked fine. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 > I had understood what you meant..It is formatted as number and not text. > > Regards, > > Sudha Bharathan ---

Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
Hi I had understood what you meant..It is formatted as number and not text. Regards, Sudha Bharathan On Fri, 1 Mar, 2019, 7:20 PM Wade Smart, wrote: > Sorry, that wasnt clear on my part, > is the cell formatted to number or text? > -- > Registered Linux User: #480675 > Registered Linux Machin

Re: zh_PINYIN

2019-03-01 Thread Keith N. McKenna
On 3/1/2019 1:15 AM, Andrea Vt wrote: > Just for interest: > > - What is zh_PINYIN? > > - What is RFE? > > abbreviations are almost funny: > > Google gives me: > > - Radio free Europe > > - Reason for encounter > > - Rat für Erwachsenenbildung > > ... ah - request for evidence, request for

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Sorry, that wasnt clear on my part, is the cell formatted to number or text? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 7:30 AM Sudha Bharathan wrote: > 10 is a number not text > > On Fri, Mar 1, 2019 at 6:31 PM Wade Smart

Re: Multiple column filter

2019-03-01 Thread Sudha Bharathan
10 is a number not text On Fri, Mar 1, 2019 at 6:31 PM Wade Smart wrote: > Is 10 a number or is it formatted as text? > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > > On Fri, Mar 1, 2019 at 6:29 AM Sudha Bharathan > wrote: > >> Hi >> I am u

Re: Multiple column filter

2019-03-01 Thread Wade Smart
Is 10 a number or is it formatted as text? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Fri, Mar 1, 2019 at 6:29 AM Sudha Bharathan wrote: > Hi > I am unable to get the desired result after the third filter is added on > open office calc.(open of