[libreoffice-users]
-- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: LibreOffice Sort Bug ?
Am 25.03.2015 um 23:42 schrieb Richard VINCK: > This is undoubtedly a serious bug... and nobody has detected this > before? How strange. > Hi, With older versions of LO and with OpenOffice you can define named ranges which remember their sort orders, filter arguments and options, so called database ranges. Somewhere in the LO development process the feature got lost. You can still select a cell range, call menu:Data>Define... and specify that this should be the list named "List" and that it has no column labels on top. But this setting has no effect. As soon as you push any of the sort buttons or call menu:Data>Sort, the automatic detection identifies a first row of text values as column labels. This is how the auto-sort buttons [A-Z] and [Z-A] work: > https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=72449&p=326195 And like always: Even the most simple list is way easier to handle in a dBase connected database. Lists saved in a database integreate almost seamlessly in spreadsheets if you still find some reason why you want to process your text data in an arithmetic calculator. Hope this helps a litte. As a work-around I would simply add column labels on top of every list. Cheers, Andreas -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice Sort Bug ?
At 12:38 27/03/2015 +0200, Pertti Rönnberg wrote: A spreadsheet program that cannot be fully trusted is totally worthless!! It's perhaps worth a reminder that, in the sense that you mean it, spreadsheets can never be "trusted". Since much of their essential functionality is hidden (formulae, formatting, significant options) and they are untestable, you should never rely on the results of a spreadsheet. Your judgement, then (but not mine) is that spreadsheet programs generally are "totally worthless". See, for example: http://lemire.me/blog/archives/2014/05/23/you-shouldnt-use-a-spreadsheet-for-important-work-i-mean-it/ "I will happily use a spreadsheet to estimate the grades of my students, my retirement savings, or how much tax I paid last year but I will not use Microsoft Excel to run a bank or to compute the trajectory of the space shuttle. Spreadsheets are convenient but error prone." http://baselinescenario.com/2013/02/09/the-importance-of-excel/ "But while Excel the program is reasonably robust, the spreadsheets that people create with Excel are incredibly fragile." http://mba.tuck.dartmouth.edu/spreadsheet/product_pubs_files/Literature.pdf "Among those who study spreadsheet use, it is widely accepted that errors are prevalent in operational spreadsheets and that errors can lead to poor decisions and cost millions of dollars." "Panko summarized this literature by reporting that 94% of spreadsheets have errors, with an average cell error rate of 5.2%." Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Request for resoure suggestions.
Hi Michael, Michael Tiernan schrieb: On 3/27/15 6:03 AM, Regina Henschel wrote: You are looking for a numbering of headings. For that purpose "List" is always wrong. (*WHEW*) i feel better. :) Thanks for the answer. Do you have already download the tutorials? Got them now and am going to get started on them If you are not very advanced, you should not try to do it by changing the style. The way to go is via menu Tools and item "Outline numbering". This is helpful. Because I've not been intimidated by screwing with styles, I'm inclined to ask what is it about changing a style that is so much harder? (Just for my own future reference.) With the predefined way you get automatic adapting numbering and paragraph style when demote or promote level. If you manually set an outline level and numbering style in the paragraph style, you need to adapt the paragraph style and the numbering style manually, when you demote or promote the chapter in the Navigator. For the self-made outline styles is no way inside the style to bind the level of the outline to the level of the numbering and no way to automatically set a certain paragraph style if the paragraph changes its outline level by promoting or demoting. You can workaround this problem by using conditional styles, but that works less nice than the "Outline numbering" tool. Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: LibreOffice Sort Bug ?
opinion FWIW: I tend to use sort on an entire sheet (using data>sort), and I nearly always have a column headings row at the top; I get narked when, coming to repeat a sort on a sheet, I find that LO has "forgotten" that I have previously checked the "has headings" box and ends up sorting the headings into the data - so I definitely prefer the "has headings" to be default. (It mightn't be *quite* so bad if one didn't have to go to an options tab in order to see what the current setting is - it's just too easy for feeble-minded people like me to forget to do that!). So it would definitely be good to be able to rely upon the setting being unchanged since the last sort. It would also be good to have the possibility to set the required behaviour on a per-sheet basis. OTOH, sorting a selected range, as has been the case in this thread, is a different kettle of fish - in that case, the default should definitely be to assume no column headings and to sort everything that's given. A thought for future development: maybe best of all would be good to be able to mark a row (or column) as being a headings row (or column) and hence be excluded from any sort automatically. This would have the advantage that more than one row (or column) could be used for this purpose. It would also have the advantage of making that "contains headings" checkbox redundant, whilst avoiding problems of the kind that have been experienced here. Just some thoughts... /Gary From: Tom Davies To: Nino Novak Cc: "users@global.libreoffice.org" Sent: Friday, 27 March 2015, 12:18 Subject: Re: [libreoffice-users] Re: LibreOffice Sort Bug ? Hi :) Personally i think that it is quite annoying. If i select something to sort i tend to leave out any stuff i don't want sorted. Similarly if i want to make some things bold. I select the things i want to make bold and leave out the rest! Regards from Tom :) On 27 March 2015 at 12:01, Nino Novak wrote: > Pertti, all, > > 1) This seems to be an old known problem (see e.g. [1]) > > 2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO it's > inherited from OOo > > 3) an easy Workaround exists (go over Data > Sort, choose proper column > label Options) > > So IMO the next questions are, > - how important is this bug? > - is there general agreement about a default behavior / column label > recognition algorithm? > > Then the bug could be pushed to a higher prio / dev visibility. > > Nino > > [1] https://bugs.documentfoundation.org/show_bug.cgi?id=77681 > > > Am 27.03.2015 um 11:38 schrieb Pertti Rönnberg: > > Tim Lloyd's comment is not acceptable! > > This is not a question of a (unpaid) programmer's likings or priorities > -- > > this is a serious question of Libre Office's liability, > > because both of the the sort buttons in the toolbar (asc & desc) give > wrong > > results as well as there is no clear explanation why and how the sort > command > > in Data=> sort must be "customized" if yopu want a correct result. > > > > A spreadsheet program that cannot be fully trusted is totally worthless!! > > > > These "bugs" are a result of very bad planning and an obviously total > lack > > of control & testing of the programming before it was accepted > > as a feature in Calc and the complete LibreOffice suite. > > > > Neither is this really not a "game" -- anyone who goes for to programming > > something for LibreOffice must feel the responsibility for the result -- > as > > well as > > the controlling team (if any?). > > > > The sort feature is a very important feature why these faults have to be > > corrected immediately > >>> the function of both the sort buttons set to "normal" sort of a > > selected range > >>> all selections set to blanc in Data=>sort=>options > > Pertti Rönnberg > > > > > > > > On 26.3.2015 2:12, Tim Lloyd wrote: > >> Hi, > >> > >> while LO does allow a certain amount of customisation, at this point in > >> the game this particular menu option can not be changed. > >> > >> This then becomes a feature request, either > >> > >> * change the default > >> * allow the sort options to be customised > >> > >> Once a feature request is submitted it is really up to a (unpaid) > >> programmer to step forward and take on the action. I can't see this > being > >> high on the programmer's list of priorities but it may be deemed an > "easy > >> hack" which an aspiring young person could field. > >> > >> Cheers > >> > >> > >> > >> > >> On 26/03/15 10:58, Richard VINCK wrote: > >>> Tim Lloyd > >>> Thank you for pointing this. Indeed, unticking it works then correctly. > >>> But it should be the default, and should remain unticked. (and should > be > >>> more visible, as it is hidden in the Option tab) > >>> Can we make it as default? > >>> > >>> On 2015-03-26 00:42, Tim Lloyd wrote: > A quick look at the doco reveals... > > Range contains column/row labels > – omits the first row or the first column in the selection from
Re: [libreoffice-users] Re: LibreOffice Sort Bug ?
Hi :) Personally i think that it is quite annoying. If i select something to sort i tend to leave out any stuff i don't want sorted. Similarly if i want to make some things bold. I select the things i want to make bold and leave out the rest! Regards from Tom :) On 27 March 2015 at 12:01, Nino Novak wrote: > Pertti, all, > > 1) This seems to be an old known problem (see e.g. [1]) > > 2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO it's > inherited from OOo > > 3) an easy Workaround exists (go over Data > Sort, choose proper column > label Options) > > So IMO the next questions are, > - how important is this bug? > - is there general agreement about a default behavior / column label > recognition algorithm? > > Then the bug could be pushed to a higher prio / dev visibility. > > Nino > > [1] https://bugs.documentfoundation.org/show_bug.cgi?id=77681 > > > Am 27.03.2015 um 11:38 schrieb Pertti Rönnberg: > > Tim Lloyd's comment is not acceptable! > > This is not a question of a (unpaid) programmer's likings or priorities > -- > > this is a serious question of Libre Office's liability, > > because both of the the sort buttons in the toolbar (asc & desc) give > wrong > > results as well as there is no clear explanation why and how the sort > command > > in Data=> sort must be "customized" if yopu want a correct result. > > > > A spreadsheet program that cannot be fully trusted is totally worthless!! > > > > These "bugs" are a result of very bad planning and an obviously total > lack > > of control & testing of the programming before it was accepted > > as a feature in Calc and the complete LibreOffice suite. > > > > Neither is this really not a "game" -- anyone who goes for to programming > > something for LibreOffice must feel the responsibility for the result -- > as > > well as > > the controlling team (if any?). > > > > The sort feature is a very important feature why these faults have to be > > corrected immediately > >>>the function of both the sort buttons set to "normal" sort of a > > selected range > >>>all selections set to blanc in Data=>sort=>options > > Pertti Rönnberg > > > > > > > > On 26.3.2015 2:12, Tim Lloyd wrote: > >> Hi, > >> > >> while LO does allow a certain amount of customisation, at this point in > >> the game this particular menu option can not be changed. > >> > >> This then becomes a feature request, either > >> > >> * change the default > >> * allow the sort options to be customised > >> > >> Once a feature request is submitted it is really up to a (unpaid) > >> programmer to step forward and take on the action. I can't see this > being > >> high on the programmer's list of priorities but it may be deemed an > "easy > >> hack" which an aspiring young person could field. > >> > >> Cheers > >> > >> > >> > >> > >> On 26/03/15 10:58, Richard VINCK wrote: > >>> Tim Lloyd > >>> Thank you for pointing this. Indeed, unticking it works then correctly. > >>> But it should be the default, and should remain unticked. (and should > be > >>> more visible, as it is hidden in the Option tab) > >>> Can we make it as default? > >>> > >>> On 2015-03-26 00:42, Tim Lloyd wrote: > A quick look at the doco reveals... > > Range contains column/row labels > – omits the first row or the first column in the selection from the > sort > > Untick this box and you are sorted. > > Cheers > > On 26/03/15 10:06, Wade Smart wrote: > > Hmm I just tried to sort going through the > > sort menu and I still cant get it to sort > > properly. > > > > It does numbers just fine though. > > -- > > Registered Linux User: #480675 > > Registered Linux Machine: #408606 > > Linux since June 2005 > > > > > > On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart > wrote: > >> **cough cough** .. feature understood. > >> -- > >> Registered Linux User: #480675 > >> Registered Linux Machine: #408606 > >> Linux since June 2005 > >> > >> > >> On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan > >> wrote: > >>> On 3/25/15 6:53 PM, Wade Smart wrote: > I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not > working. > >>> When I reported it, I provided a great deal of information about > it and > >>> was told "Not a bug" and "works for me" by those who have the > power to > >>> close bugs. > >>> > >>> My argument was/is that if you use the sort arrows (as you have > done > >>> here) then you're asking/telling LO to sort the selected rows with > no > >>> options. > >>> > >>> Instead it was deemed correct that instead, LO assumes the first > cell > >>> found is used as a label regardless of any other settings. > >>> > >>> This "feature" (*cough*) cost me a number of hours of work to get > around > >>> and avoid. > >>> > >>> The argument is that since you can use the "Sort" menu option and > c
Re: [libreoffice-users] LibreOffice Sort Bug ?
Hi :) Err the fading dominance of MS formats is good but the "dominance" part is really annoying and causes a lot of unnecessary agro. Regards from Tom :) On 27 March 2015 at 12:01, Tom Davies wrote: > Hi :) > I think you meant that the background behind Tim's answer is not > acceptable. His actual answer seems very honest, truthful and useful. It > is not a voice of arbitrary authority but one of wisdom and counsel. One > problem with emails is that we don't hear the tone of voice nor any clues > from body-language. Of course a lot of us in IT don't process that sort of > stuff in face-to-face communications either but that's another story. > > On this mailing list we have absolutely no control over what the devs do > nor how this project is run and we are almost never asked for our opinions > on what might be a good way. We can only give answers to try to help users > figure out how to use the suite as it is, and maybe grumble about oddities > and issues related, such as the fading dominance of the MS formats. We are > free to join other lists such as Discuss@ and the social media channels > but most of us on this mailing-list are only interested in just helping > people directly. > > Several answers in this thread have been 'brutally' honest with no false > apologies or soft-pedalling the truth or giving it any spin (err, except > with a blatant cough rather than my usual sarcastic quotes ' ). From my > own experience i suspect many of the answers so far have been answered > off-list by one of the "higher ups" berating them and possibly threatening > to ban them from the lists. > > To me Tim's answer seems a bit heroic, not quite on the scale of children > in any war-torn area, but still admirable. He makes a stand for truth and > honesty and that might have got him in trouble already. > > > However just because something is not done quite the same way as it's done > in MS Office or/and is not intuitive to some people does not necessarily > make it wrong. > > The main problem here, in my opinion, is that it wasn't easy to figure out > and documentation may not have been easy enough to get to. Of course now > that we have had this answer on the list it will probably crop up again > quite soon and we have a quick answer ready. > > Regards from > Tom :) > > > > > > > On 27 March 2015 at 10:38, Pertti Rönnberg wrote: > >> Tim Lloyd's comment is not acceptable! >> This is not a question of a (unpaid) programmer's likings or priorities >> -- this is a serious question of Libre Office's liability, >> because both of the the sort buttons in the toolbar (asc & desc) give >> wrong results as well as there is no clear explanation why and how the sort >> command >> in Data=> sort must be "customized" if yopu want a correct result. >> >> A spreadsheet program that cannot be fully trusted is totally worthless!! >> >> These "bugs" are a result of very bad planning and an obviously total >> lack of control & testing of the programming before it was accepted >> as a feature in Calc and the complete LibreOffice suite. >> >> Neither is this really not a "game" -- anyone who goes for to programming >> something for LibreOffice must feel the responsibility for the result -- as >> well as >> the controlling team (if any?). >> >> The sort feature is a very important feature why these faults have to be >> corrected immediately >> >>the function of both the sort buttons set to "normal" sort of a >> selected range >> >>all selections set to blanc in Data=>sort=>options >> Pertti Rönnberg >> >> >> >> >> On 26.3.2015 2:12, Tim Lloyd wrote: >> >>> Hi, >>> >>> while LO does allow a certain amount of customisation, at this point in >>> the game this particular menu option can not be changed. >>> >>> This then becomes a feature request, either >>> >>> * change the default >>> * allow the sort options to be customised >>> >>> Once a feature request is submitted it is really up to a (unpaid) >>> programmer to step forward and take on the action. I can't see this being >>> high on the programmer's list of priorities but it may be deemed an "easy >>> hack" which an aspiring young person could field. >>> >>> Cheers >>> >>> >>> >>> >>> On 26/03/15 10:58, Richard VINCK wrote: >>> Tim Lloyd Thank you for pointing this. Indeed, unticking it works then correctly. But it should be the default, and should remain unticked. (and should be more visible, as it is hidden in the Option tab) Can we make it as default? On 2015-03-26 00:42, Tim Lloyd wrote: > A quick look at the doco reveals... > > Range contains column/row labels > – omits the first row or the first column in the selection from the > sort > > Untick this box and you are sorted. > > Cheers > > On 26/03/15 10:06, Wade Smart wrote: > >> Hmm I just tried to sort going through the >> sort menu and I still cant get it to sort >> properly. >> >> It does numbers jus
[libreoffice-users] Re: LibreOffice Sort Bug ?
Pertti, all, 1) This seems to be an old known problem (see e.g. [1]) 2) I just tested 3.4.1 (LibO+AOO) - its already present there, so IMHO it's inherited from OOo 3) an easy Workaround exists (go over Data > Sort, choose proper column label Options) So IMO the next questions are, - how important is this bug? - is there general agreement about a default behavior / column label recognition algorithm? Then the bug could be pushed to a higher prio / dev visibility. Nino [1] https://bugs.documentfoundation.org/show_bug.cgi?id=77681 Am 27.03.2015 um 11:38 schrieb Pertti Rönnberg: > Tim Lloyd's comment is not acceptable! > This is not a question of a (unpaid) programmer's likings or priorities -- > this is a serious question of Libre Office's liability, > because both of the the sort buttons in the toolbar (asc & desc) give wrong > results as well as there is no clear explanation why and how the sort command > in Data=> sort must be "customized" if yopu want a correct result. > > A spreadsheet program that cannot be fully trusted is totally worthless!! > > These "bugs" are a result of very bad planning and an obviously total lack > of control & testing of the programming before it was accepted > as a feature in Calc and the complete LibreOffice suite. > > Neither is this really not a "game" -- anyone who goes for to programming > something for LibreOffice must feel the responsibility for the result -- as > well as > the controlling team (if any?). > > The sort feature is a very important feature why these faults have to be > corrected immediately >>>the function of both the sort buttons set to "normal" sort of a > selected range >>>all selections set to blanc in Data=>sort=>options > Pertti Rönnberg > > > > On 26.3.2015 2:12, Tim Lloyd wrote: >> Hi, >> >> while LO does allow a certain amount of customisation, at this point in >> the game this particular menu option can not be changed. >> >> This then becomes a feature request, either >> >> * change the default >> * allow the sort options to be customised >> >> Once a feature request is submitted it is really up to a (unpaid) >> programmer to step forward and take on the action. I can't see this being >> high on the programmer's list of priorities but it may be deemed an "easy >> hack" which an aspiring young person could field. >> >> Cheers >> >> >> >> >> On 26/03/15 10:58, Richard VINCK wrote: >>> Tim Lloyd >>> Thank you for pointing this. Indeed, unticking it works then correctly. >>> But it should be the default, and should remain unticked. (and should be >>> more visible, as it is hidden in the Option tab) >>> Can we make it as default? >>> >>> On 2015-03-26 00:42, Tim Lloyd wrote: A quick look at the doco reveals... Range contains column/row labels – omits the first row or the first column in the selection from the sort Untick this box and you are sorted. Cheers On 26/03/15 10:06, Wade Smart wrote: > Hmm I just tried to sort going through the > sort menu and I still cant get it to sort > properly. > > It does numbers just fine though. > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > > On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart wrote: >> **cough cough** .. feature understood. >> -- >> Registered Linux User: #480675 >> Registered Linux Machine: #408606 >> Linux since June 2005 >> >> >> On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan >> wrote: >>> On 3/25/15 6:53 PM, Wade Smart wrote: I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working. >>> When I reported it, I provided a great deal of information about it and >>> was told "Not a bug" and "works for me" by those who have the power to >>> close bugs. >>> >>> My argument was/is that if you use the sort arrows (as you have done >>> here) then you're asking/telling LO to sort the selected rows with no >>> options. >>> >>> Instead it was deemed correct that instead, LO assumes the first cell >>> found is used as a label regardless of any other settings. >>> >>> This "feature" (*cough*) cost me a number of hours of work to get around >>> and avoid. >>> >>> The argument is that since you can use the "Sort" menu option and change >>> this behavior *for each sort occurrence* then there's a work around for >>> the "feature" and we should be happy with that. >>> >>> -- >>><< 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 to the idea. -Robert A. Heinlein >>> >>> >>> -- >>> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org >>> Problems? >>> http://www.libreoffice.org/get-help/mai
Re: [libreoffice-users] LibreOffice Sort Bug ?
Hi :) I think you meant that the background behind Tim's answer is not acceptable. His actual answer seems very honest, truthful and useful. It is not a voice of arbitrary authority but one of wisdom and counsel. One problem with emails is that we don't hear the tone of voice nor any clues from body-language. Of course a lot of us in IT don't process that sort of stuff in face-to-face communications either but that's another story. On this mailing list we have absolutely no control over what the devs do nor how this project is run and we are almost never asked for our opinions on what might be a good way. We can only give answers to try to help users figure out how to use the suite as it is, and maybe grumble about oddities and issues related, such as the fading dominance of the MS formats. We are free to join other lists such as Discuss@ and the social media channels but most of us on this mailing-list are only interested in just helping people directly. Several answers in this thread have been 'brutally' honest with no false apologies or soft-pedalling the truth or giving it any spin (err, except with a blatant cough rather than my usual sarcastic quotes ' ). From my own experience i suspect many of the answers so far have been answered off-list by one of the "higher ups" berating them and possibly threatening to ban them from the lists. To me Tim's answer seems a bit heroic, not quite on the scale of children in any war-torn area, but still admirable. He makes a stand for truth and honesty and that might have got him in trouble already. However just because something is not done quite the same way as it's done in MS Office or/and is not intuitive to some people does not necessarily make it wrong. The main problem here, in my opinion, is that it wasn't easy to figure out and documentation may not have been easy enough to get to. Of course now that we have had this answer on the list it will probably crop up again quite soon and we have a quick answer ready. Regards from Tom :) On 27 March 2015 at 10:38, Pertti Rönnberg wrote: > Tim Lloyd's comment is not acceptable! > This is not a question of a (unpaid) programmer's likings or priorities -- > this is a serious question of Libre Office's liability, > because both of the the sort buttons in the toolbar (asc & desc) give > wrong results as well as there is no clear explanation why and how the sort > command > in Data=> sort must be "customized" if yopu want a correct result. > > A spreadsheet program that cannot be fully trusted is totally worthless!! > > These "bugs" are a result of very bad planning and an obviously total lack > of control & testing of the programming before it was accepted > as a feature in Calc and the complete LibreOffice suite. > > Neither is this really not a "game" -- anyone who goes for to programming > something for LibreOffice must feel the responsibility for the result -- as > well as > the controlling team (if any?). > > The sort feature is a very important feature why these faults have to be > corrected immediately > >>the function of both the sort buttons set to "normal" sort of a > selected range > >>all selections set to blanc in Data=>sort=>options > Pertti Rönnberg > > > > > On 26.3.2015 2:12, Tim Lloyd wrote: > >> Hi, >> >> while LO does allow a certain amount of customisation, at this point in >> the game this particular menu option can not be changed. >> >> This then becomes a feature request, either >> >> * change the default >> * allow the sort options to be customised >> >> Once a feature request is submitted it is really up to a (unpaid) >> programmer to step forward and take on the action. I can't see this being >> high on the programmer's list of priorities but it may be deemed an "easy >> hack" which an aspiring young person could field. >> >> Cheers >> >> >> >> >> On 26/03/15 10:58, Richard VINCK wrote: >> >>> Tim Lloyd >>> Thank you for pointing this. Indeed, unticking it works then correctly. >>> But it should be the default, and should remain unticked. (and should be >>> more visible, as it is hidden in the Option tab) >>> Can we make it as default? >>> >>> On 2015-03-26 00:42, Tim Lloyd wrote: >>> A quick look at the doco reveals... Range contains column/row labels – omits the first row or the first column in the selection from the sort Untick this box and you are sorted. Cheers On 26/03/15 10:06, Wade Smart wrote: > Hmm I just tried to sort going through the > sort menu and I still cant get it to sort > properly. > > It does numbers just fine though. > -- > Registered Linux User: #480675 > Registered Linux Machine: #408606 > Linux since June 2005 > > > On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart > wrote: > >> **cough cough** .. feature understood. >> -- >> Registered Linux User: #480675 >> Registered Linux Machine: #408606 >> Linux since June
Re: [libreoffice-users] Request for resoure suggestions.
On 3/27/15 6:03 AM, Regina Henschel wrote: > You are looking for a numbering of headings. For that purpose "List" > is always wrong. (*WHEW*) i feel better. :) Thanks for the answer. > Do you have already download the tutorials? Got them now and am going to get started on them > If you are not very advanced, you should not try to do it by changing > the style. The way to go is via menu Tools and item "Outline numbering". This is helpful. Because I've not been intimidated by screwing with styles, I'm inclined to ask what is it about changing a style that is so much harder? (Just for my own future reference.) And thank you to everyone for the answers. I'm opening all the links and sucking in what I can. -- << 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 to the idea. -Robert A. Heinlein -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Re: Request for resoure suggestions.
Hi :) Probably the best place to find links to various types of documentation is; https://wiki.documentfoundation.org/Documentation as it also links to video tutorials such as this one; http://spoken-tutorial.org/ for a wide range of Open Source projects. It also has links to the archives and pre-release versions of the guides that Regina gave a link to although it has so much stuff available that the page may look a bit daunting or confusing at first. The "Get Help" link that Regina gave tries to make it simpler but i think you are already beyond that since you have already managed to reach this mailing list! Sadly it doesn't give a link to the guide Andreas linked to and there is an ultra new guide that also doesn't seem to be linked yet. Regards from Tom :) On 27 March 2015 at 11:13, Andreas Säger wrote: > Best resource I'm aware of if your requiements are similar to those of a > student: > > > https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students > > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Request for resoure suggestions.
Best resource I'm aware of if your requiements are similar to those of a student: > https://wiki.openoffice.org/wiki/Documentation/Writer_for_Students -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] LibreOffice Sort Bug ?
Tim Lloyd's comment is not acceptable! This is not a question of a (unpaid) programmer's likings or priorities -- this is a serious question of Libre Office's liability, because both of the the sort buttons in the toolbar (asc & desc) give wrong results as well as there is no clear explanation why and how the sort command in Data=> sort must be "customized" if yopu want a correct result. A spreadsheet program that cannot be fully trusted is totally worthless!! These "bugs" are a result of very bad planning and an obviously total lack of control & testing of the programming before it was accepted as a feature in Calc and the complete LibreOffice suite. Neither is this really not a "game" -- anyone who goes for to programming something for LibreOffice must feel the responsibility for the result -- as well as the controlling team (if any?). The sort feature is a very important feature why these faults have to be corrected immediately >>the function of both the sort buttons set to "normal" sort of a selected range >>all selections set to blanc in Data=>sort=>options Pertti Rönnberg On 26.3.2015 2:12, Tim Lloyd wrote: Hi, while LO does allow a certain amount of customisation, at this point in the game this particular menu option can not be changed. This then becomes a feature request, either * change the default * allow the sort options to be customised Once a feature request is submitted it is really up to a (unpaid) programmer to step forward and take on the action. I can't see this being high on the programmer's list of priorities but it may be deemed an "easy hack" which an aspiring young person could field. Cheers On 26/03/15 10:58, Richard VINCK wrote: Tim Lloyd Thank you for pointing this. Indeed, unticking it works then correctly. But it should be the default, and should remain unticked. (and should be more visible, as it is hidden in the Option tab) Can we make it as default? On 2015-03-26 00:42, Tim Lloyd wrote: A quick look at the doco reveals... Range contains column/row labels – omits the first row or the first column in the selection from the sort Untick this box and you are sorted. Cheers On 26/03/15 10:06, Wade Smart wrote: Hmm I just tried to sort going through the sort menu and I still cant get it to sort properly. It does numbers just fine though. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Wed, Mar 25, 2015 at 6:04 PM, Wade Smart wrote: **cough cough** .. feature understood. -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 On Wed, Mar 25, 2015 at 6:02 PM, Michael Tiernan wrote: On 3/25/15 6:53 PM, Wade Smart wrote: I have 4.2.7.2 on Ubuntu 14.04 and you are correct, sort is not working. When I reported it, I provided a great deal of information about it and was told "Not a bug" and "works for me" by those who have the power to close bugs. My argument was/is that if you use the sort arrows (as you have done here) then you're asking/telling LO to sort the selected rows with no options. Instead it was deemed correct that instead, LO assumes the first cell found is used as a label regardless of any other settings. This "feature" (*cough*) cost me a number of hours of work to get around and avoid. The argument is that since you can use the "Sort" menu option and change this behavior *for each sort occurrence* then there's a work around for the "feature" and we should be happy with that. -- << 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 to the idea. -Robert A. Heinlein -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Request for resoure suggestions.
Hi Michael, Michael Tiernan schrieb: I'm working on improving my formatting skills. I'm using a ~10pg document as my test. My first problem is to figure out a specific part of styles. I can format the document to have a heading (specifically heading 2) at the start of each section. Looks nice. Copied the existing style, made a few mods, very pleased. NOW, I want to try to add a number to each section and I'm having trouble understanding the correct route for this. I have already gotten: John George Paul Ringo and it worked fine. Now I want to change the style to be like: I John II George III Paul IV Ringo So, I can't tell if I should be trying to modify the "Heading 2" style or if I should be trying to add a "List" format to the mix. I'm looking for suggestions on where I can read about the uses of each and learn the differences. You are looking for a numbering of headings. For that purpose "List" is always wrong. If you are not very advanced, you should not try to do it by changing the style. The way to go is via menu Tools and item "Outline numbering". Do you have already download the tutorials? http://www.libreoffice.org/get-help/documentation/ Kind regards Regina -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Request for resoure suggestions.
I'm working on improving my formatting skills. I'm using a ~10pg document as my test. My first problem is to figure out a specific part of styles. I can format the document to have a heading (specifically heading 2) at the start of each section. Looks nice. Copied the existing style, made a few mods, very pleased. NOW, I want to try to add a number to each section and I'm having trouble understanding the correct route for this. I have already gotten: John George Paul Ringo and it worked fine. Now I want to change the style to be like: I John II George III Paul IV Ringo So, I can't tell if I should be trying to modify the "Heading 2" style or if I should be trying to add a "List" format to the mix. I'm looking for suggestions on where I can read about the uses of each and learn the differences. Thanks for any suggestion! -- << 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 to the idea. -Robert A. Heinlein -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] how to put images into a report
Hi, how can I put images into a report? I have a query on a database that, amongst others, has a field with the file name of an image. All images are stored in a particular directory, so the relevant table in the database holds the file name of the image, for example "abc.jpg". I need the image that has the particular file name displayed in the report. The images are of different sizes, and in the first step, I'd like to have them scaled to fit into the report, and their aspect ratio must not be changed. In a second step, I might use some external tool to make all images the same size eventually. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted