Re: [libreoffice-users] calc filter?

2016-03-01 Thread tonybsa
> Hi, > My understanding is you want to re-display the list in the order you provided. Set B2 to B17 to your list Then set A2 to A17 to your required order. Note in column A you are telling the numbers in column B where they should appear in the sorted list i.e Number 16 (sixteen) in column B

Re: [libreoffice-users] calc filter?

2016-02-29 Thread Brian Barker
At 15:01 29/02/2016 -0600, Beau Thompson wrote: im working on a calc sheet where i have a list of 16 names 1 to 16 B2 TO B17 I like to filter the list in this order 1 16 8 9 4 13 5 12 2 15 7 10 3 14 6 11 Filtering in a spreadsheet arranges that only some rows are displayed and possibly that on

Re: [libreoffice-users] calc filter?

2016-02-29 Thread Remy Gauthier
Hi, My understanding is you want to re-display the list in the order you provided. If you can calculate the odd indices (the even numbered ones are always equal to the number of elements minus the odd index plus 1 in your list), replace the number in the sequence by that calculation. Otherwise, you

[libreoffice-users] calc filter?

2016-02-29 Thread Beau Thompson
HI all, im working on a calc sheet where i have a list of 16 names 1 to 16 B2 TO B17 I lie to filter the list in this order 1 16 8 9 4 13 5 12 2 15 7 10 3 14 6 11 thanks beau -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/ma

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread drew
On Wed, 2012-02-22 at 16:43 -0500, Steven Shelton wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 2/22/2012 4:32 PM, drew wrote: > > This is using the mysql connector, yes? > > No. Connecting to an HSQL file using the java connector. I just filed a > bug on it, *Bug 46480* >

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread Steven Shelton
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2/22/2012 4:32 PM, drew wrote: > This is using the mysql connector, yes? No. Connecting to an HSQL file using the java connector. I just filed a bug on it, *Bug 46480* , after not finding anythi

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread drew
On Wed, 2012-02-22 at 16:32 -0500, drew wrote: > On Wed, 2012-02-22 at 16:26 -0500, Steven Shelton wrote: > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > On 2/22/2012 3:59 PM, Dan Lewis wrote: > > > Yes, this is a bug. I use Ubuntu, and I get the same results. The > > filtering work

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread drew
On Wed, 2012-02-22 at 16:26 -0500, Steven Shelton wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 2/22/2012 3:59 PM, Dan Lewis wrote: > > Yes, this is a bug. I use Ubuntu, and I get the same results. The > filtering works when using 3.4.5 but does not work using 3.5.0. --Dan > >

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread Steven Shelton
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2/22/2012 3:59 PM, Dan Lewis wrote: > Yes, this is a bug. I use Ubuntu, and I get the same results. The filtering works when using 3.4.5 but does not work using 3.5.0. --Dan Do you know if this has been filed in Bugzilla, and if so, what the bug

Re: [libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread Dan Lewis
On Wed, 2012-02-22 at 15:19 -0500, Steven Shelton wrote: > Has anyone encountered a bug in LibO 3.5's calc wherein filters refuse > to work? > > I want to get some data from my database, so I establish the connection > to the correct table from the "Data Sources" panel. The data from the > table a

[libreoffice-users] Calc filter bug in 3.5.0?

2012-02-22 Thread Steven Shelton
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has anyone encountered a bug in LibO 3.5's calc wherein filters refuse to work? I want to get some data from my database, so I establish the connection to the correct table from the "Data Sources" panel. The data from the table all shows up. So I hi