Re: [libreoffice-users] FEATURE REQUEST -- for the Sort options in Calc

2015-03-28 Thread Brian Barker
At 15:22 28/03/2015 +0100, Stefan Weigel wrote: When sorting, it's not recommended to select a range, rather than a single cell. Calc (or Excel) will select the range to be sorted by its own. Selecting a specific range before sorting is only helpful for very special cases, when automatic

[libreoffice-users] Re: FEATURE REQUEST -- for the Sort options in Calc

2015-03-28 Thread Andreas Säger
Am 26.03.2015 um 01:57 schrieb Richard VINCK: For logical and safety reasons, and for compatibility with Microsoft Excel, I suggest that: * The Sort Option Range contains column labels be_unticked by default_. * Allow the sort options to be customized (optional). It is good that

[libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread Andreas Säger
Am 28.03.2015 um 12:00 schrieb Michael Tiernan: On 3/28/15 6:20 AM, Tom Davies wrote: That is exactly the most perfect use-case that would be better in a database than in a spreadsheet. Not really since, while for me the prospect of using a DB back end isn't daunting, for most it is.

Re: [libreoffice-users] LibreOffice Sort Bug ?

2015-03-28 Thread Pertti Rönnberg
Brian, Thanks for your reply and for the articles you linked to – especially the last one is very interesting. I have been aware of that but not so well explained. As I think you are very cunny both on spreadsheets and how to use them and also the mathematics, I am not able to argue. But

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread Michael Tiernan
On 3/28/15 6:20 AM, Tom Davies wrote: That is exactly the most perfect use-case that would be better in a database than in a spreadsheet. Not really since, while for me the prospect of using a DB back end isn't daunting, for most it is. Secondly, this is the perfect use-case where a DB back

Re: [libreoffice-users] FEATURE REQUEST -- for the Sort options in Calc

2015-03-28 Thread Stefan Weigel
Hi, Am 26.03.2015 um 01:57 schrieb Richard VINCK: For logical and safety reasons, and for compatibility with Microsoft Excel, I suggest that: * The Sort Option Range contains column labels be_unticked by default. Your suggestion does *not* establish compatibility with Microsoft Excel.

[libreoffice-users] the Error type of variables in LO Basic

2015-03-28 Thread Lera Goncharuk
Hi, There are two types of variables in LibreOffice Basic, which are not described in the help and the documentation. The Byte type is clear. It is positive integers from 0 to 255. The Error type is not clear. I suppose that this type is useful when working with errors in a code. But, I do not

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread Michael Tiernan
I meant to say, I'd be happy with the menu buttons performing the sort using the last chosen options. -- MCT Michael C Tiernan. http://www.linkedin.com/in/mtiernan Non Impediti Ratione Cogatationis Women and cats will do as they please, and men and dogs should relax and get used

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread Michael Tiernan
On 3/27/15 8:01 AM, Nino Novak wrote: 1) This seems to be an old known problem (see e.g. [1]) It's older than that by a bit, I reported it back in 2012 I think. (I'd have to hunt it down.) However, known isn't as accurate as we'd like if people seem to find this as new on a semi-regular basis.

Re: [libreoffice-users] Re: LibreOffice Sort Bug ?

2015-03-28 Thread Tom Davies
Hi :) That is exactly the most perfect use-case that would be better in a database than in a spreadsheet. What makes it even more perfect is that Base can use the existing spreadsheet as an external back-end. This means that while you struggle to get Base set-up you can keep using the existing