Re: [libreoffice-users] Mapping Styles usage
On 24/03/2016 13:58, Ralf Kersanach wrote: > I have an question to all, I'm developing an classroom management system > adjusted to our university system in Calc. That probably would be more appropriately done as a database, not a spreadsheet. > One of the facilities I use massively is conditional formatting. My main > difficulty with conditional formatting is > keeping track of what style is in use and what style is not in use. AFAIK, the only way to track styles when conditional formatting is used, is to do so manually. jonathon -- 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] New LibreOffice Book
On Thursday, March 24, 2016 08:04:58 AM CVAlkan wrote: > The book is also featured on Jean Hollis Weber's site > http://www.taming-libreoffice.com/2016/03/new-book-designing-with-libreoffic > e/ since she appears to be one of the editors/reviewers. Thanks for the kind words! Jean commissioned the book through her nonprofit, Friends of OpenDocument. She has also worked long hours to copy edit and proofread, and, more recently, to promote. I couldn't have had a better editor, and the book is much improved for her involvement. -- Bruce Byfield 604-421-7189 (on Pacific time) Writer of "Designing with LibreOffice" http://designingwithlibreoffice.com -- 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: date display in Calc Linux/Windows
On 2016/03/24 20:08, Bruce Hohl wrote: What format is used to save the file: ods, xlsx, xls? Sometimes the filters used to save in formats other than ods fail to retain all formatting. Good evening Nativ ODS format, since I use this file ONLY with LibreOffice. -- 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: No indent in footnotes
On 23/03/16 13:54, Urmas wrote: "anne-ology": How can this be the fault of the USofA ??? In Europe, footnotes have the same indent as the text body, and their markers are superscripted. It was LO behavior too, until some American changed it into the mess we have today. Without commenting on either PoV, does this not suggest that footnote formatting (and probably other similar issues) should have a default controlled by the locale? -- Mike Scott Harlow, Essex, England -- 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] Libre Office - older version
At 11:15 24/03/2016 -0400, Charles Meyer wrote: Does anyone know where I can download a trusted/official older version of Libre Office specifically version 3.6.4.3 ? https://downloadarchive.documentfoundation.org/libreoffice/old/3.6.4.3/ I trust this helps. 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
[libreoffice-users] Libre Office - older version
Hi Folks, Does anyone know where I can download a trusted/official older version of Libre Office – specifically version 3.6.4.3 ? Thanks so much. Charles. -- 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] New LibreOffice Book
For those who may have missed it, I would like to recommend a new book by Bruce Byfield called "Designing with LibreOffice." I have absolutely no connection whatever to this author or book, by the way. As with the normal LibreOffice manuals, the book can be purchased as a paperback or downloaded free as a pdf or odt document (with an optional contribution, of course) at http://designingwithlibreoffice.com/download-buy/ Bruce approaches LibreOffice not from the standpoint of menu functions and such, as the manuals do and should do, but as a document design and creation tutorial. This approach serves to show the purpose of LO's features and how to use them effectively. There are numerous tips throughout the book that are obviously the result of much use of the product's components. His discussion of styles, their importance, and their use is as good as any I've run across. This results-driven approach is also valuable because the author not only isn't shy about suggesting which features of LO are best avoided for one reason or another, but offers alternatives to achieving the desired objectives in such cases. The best compliment I can give the book is to say that I learned quite a bit about some of the capabilities of Writer and Calc that I wasn't aware of at all, and ended up with a much better understanding of how to take greater advantage of features I've been using for years. The book is also featured on Jean Hollis Weber's site http://www.taming-libreoffice.com/2016/03/new-book-designing-with-libreoffice/ since she appears to be one of the editors/reviewers. -- View this message in context: http://nabble.documentfoundation.org/New-LibreOffice-Book-tp4179434.html Sent from the Users mailing list archive at Nabble.com. -- 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] how to use coding and labelling in a spreadsheet
At 07:15 24/03/2016 +, Som Noname wrote: calc is a powerful spreadsheet program and i want to use this for data analysis. It may be more powerful than you think! let's say, one study has a variable named "malnutrition" measuring the nutritional status of under-five children. this variable has two value levels - "1=malnutrition" and "2=normal" If "normal" means *not* malnourished, surely the category should be "nutrition", not "malnutrition", and the possible value needs to be "malnourished", not "malnutrition" (as well as "normal")? present scenario: if data in entered as "1"/"2", spreadsheet will show it as "1"/"2". Why do people think all data needs to be represented as numbers? The numbers 1 and 2 have two properties that are inappropriate here. First there is a collating order: 1 comes before 2 - but there is no sense in which "malnourished" comes first in preference to "normal". Second, numbers have value: 2 is exactly twice the size of 1 - but there is no sense in which "normal" is exactly (or only) twice as good as "malnourished". If you see a malnourished child, you don't remark "Oh, look how 1 he is"! These are what are called non-parametric statistics, and you should avoid complication and confusion by ascribing numbers to them. (Don't believe any mathematicians who tell you everything has to be thought of in terms of numbers.) if it is entered as "malnutrition"/"normal", it will be shown in that manner. You are lucky that - unlike in mathematics - spreadsheets are happy handling text values such as these. So using values such as "malnourished" and "normal" - or perhaps just "m" and "n" - will suit your purpose better than 1 and 2. It would be a very simple matter to make mistakes by confusing which condition was 1 and which was 2 - something much less likely with meaningful labels such as "m" and "n". possibilities: renaming the cell. [...] cell A2 has a code of "1" and is renamed to "malnutrition" (upper left corner). No, you misunderstand what names are about. You give a name to a *cell* (or, generally, a cell range), so the name becomes an alternative way of identifying the cell (or range) and has nothing to do with the value or values contained. And you obviously cannot name more than one cell with the same name! my question finally comes to this - is there any way to do this in a spreadsheet program? There are many techniques to help you here. o If you wanted to, you could format relevant columns to expand "m" to "malnourished" and so on - as has already been explained. o Alternatively, it would be a simple job to create a parallel column with formulae which would show the full word derived from the single input letter. You could exclude your input column from any print range to suppress its output. o If you use the full words, as soon as you have entered the two values at least once each somewhere in a column, just typing the first letter (since they are conveniently different) will automatically show the full word as a suggestion. You need only press Enter or down-arrow or click the green arrow to complete the full word as the entry. o Again, once both values appear somewhere in a column, you can press Ctrl+D to show a selection list. The arrow keys and the Enter key enable you to select the required value quickly. o Best of all, you should consider using Data | Validity... to restrict values in the column to those listed in a cell range set up elsewhere in the spreadsheet. Now any selected cell comes with a drop-down menu of the permitted values and the arrangement ensures that only recognised values can be entered. Apart from the convenience, this prevents the possibility of spelling mistakes in input - which would otherwise be quite likely in a large set of data. I trust this helps. 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
[libreoffice-users] Mapping Styles usage
Hi folks, I have an question to all, I'm developing an classroom management system adjusted to our university system in Calc. I've rewritten it from an previous version I had, I use it to learn Calc. One of the facilities I use massively is conditional formatting. My main difficulty with conditional formatting is keeping track of what style is in use and what style is not in use. Question: Is there a way to keep track of style usage? Thanks, Ralf -- 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: date display in Calc Linux/Windows
What format is used to save the file: ods, xlsx, xls? Sometimes the filters used to save in formats other than ods fail to retain all formatting. On Thu, Mar 24, 2016 at 6:45 AM, Thomas Blasejewicz wrote: > On 2016/03/07 0:10, Pedro wrote: > >> Thomas Blasejewicz-3 wrote >> >>> I assume, there is a trick to do that? >>> >>> Fonts: as far as I can see, there are no fonts with the same name in >>> Linux/Windows. >>> Does that then mean, I cannot work on the same file using both Linux and >>> Windows? >>> >> Open the file in the Windows machine, go to File > Properties, switch to >> the >> Font tab and check the "Embed fonts in the document" box. >> In theory the fonts are cross platform and should work on both OSes... >> Please be warned that the file will increase substantially in size. >> LibreOffice currently has a bug that causes some unneeded fonts to be >> embedded >> https://bugs.documentfoundation.org/show_bug.cgi?id=65353 >> >> Hope this helps. >> > Good evening > I am afraid, I still have problems with this trick. > I have a "schedule" file on a Windows 10 machine. > On the left edge are dates. I specified the format for that column "number > -> date -> (Japanese) date format". > However on opening the file today, everything was garbled up. > Resetting the format to date -> closing the file -> reopening it => again > everything is messed up. > I tried this several time with different formats, removing the "language" > argument from that column etc. ... > so far the ONLY thing that seems to help is setting the date to > alphanumeric style. > That is basically OK, but I am wondering why all of a sudden I am not > permitted to use something that has been working for years ... > Thomas > > -- > 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] Re: date display in Calc Linux/Windows
On 2016/03/07 0:10, Pedro wrote: Thomas Blasejewicz-3 wrote I assume, there is a trick to do that? Fonts: as far as I can see, there are no fonts with the same name in Linux/Windows. Does that then mean, I cannot work on the same file using both Linux and Windows? Open the file in the Windows machine, go to File > Properties, switch to the Font tab and check the "Embed fonts in the document" box. In theory the fonts are cross platform and should work on both OSes... Please be warned that the file will increase substantially in size. LibreOffice currently has a bug that causes some unneeded fonts to be embedded https://bugs.documentfoundation.org/show_bug.cgi?id=65353 Hope this helps. Good evening I am afraid, I still have problems with this trick. I have a "schedule" file on a Windows 10 machine. On the left edge are dates. I specified the format for that column "number -> date -> (Japanese) date format". However on opening the file today, everything was garbled up. Resetting the format to date -> closing the file -> reopening it => again everything is messed up. I tried this several time with different formats, removing the "language" argument from that column etc. ... so far the ONLY thing that seems to help is setting the date to alphanumeric style. That is basically OK, but I am wondering why all of a sudden I am not permitted to use something that has been working for years ... Thomas -- 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] how to use coding and labelling in a spreadsheet
thank you regina. that is exactly what i was trying to achieve. addition of red was a nice touch too. thank you very much for your help. regards, som On Thursday 24 March 2016 01:56 PM, Regina Henschel wrote: Hi som, you can use format codes. Format codes do not change the value of the cell, but only how this value is shown. So the content of the cell would be still the number 1 or 2, but you would read "malnutrition" and "normal". Open Style&Formatting dialog, right-click cell style 'default', select 'New'. Enter a name for the new style in tab 'Organizer',e.g. 'myLabels'. In tab 'Numbers' select 'User-defined'. Then write the following into the input field 'Format' [=1]"malnutrition";[=2]"normal";[RED]Standard You can click on the "edit comment" icon to define an identifier for this format. Then click the green check mark to add it. OK. Now mark the area where you will enter the data and assign the newly created cell style. When you now enter a 1 into a cell, the input line shows a 1 and you can calculate with the content 1, but in the cell itself you will see 'malnutrition'. I have included the part [RED]Standard, so that all other numbers will be in red to show, that this entry is not correct. Find more about Format codes in the help. Kind regards Regina som schrieb: > hello friends, > calc is a powerful spreadsheet program and i want to use this for data > analysis. let's say, one study has a variable named "malnutrition" > measuring the nutritional status of under-five children. this variable > has two value levels - "1=malnutrition" and "2=normal" (ods file > link=http://s000.tinyupload.com/?file_id=01897194432026825577). > present scenario: > if data in entered as "1"/"2", spreadsheet will show it as "1"/"2". if > it is entered as "malnutrition"/"normal", it will be shown in that > manner. > what I expect: > after doing value labeling (i.e., telling calc that "1=malnutrition" > and "2=normal"), data will be entered as "1"/"2" and it'll appear as > "malnutrition"/"normal"). > possibilities: > renaming the cell. > as could be seen in this image > (http://s000.tinyupload.com/?file_id=03212213468569832926), cell A2 > has a code of "1" and is renamed to "malnutrition" (upper left corner). > problem: need to select each cell containing "1" and rename it to > malnutrition. otherwise cell A4 is not showing malnutrition for code 1 > (http://s000.tinyupload.com/?file_id=37582743697322862277).so i guess, > my question finally comes to this- is there any way to do this in a > spreadsheet program? > waiting for your responses. thanks in advance. > > regards, > > som > -- 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] how to use coding and labelling in a spreadsheet
Hi som, you can use format codes. Format codes do not change the value of the cell, but only how this value is shown. So the content of the cell would be still the number 1 or 2, but you would read "malnutrition" and "normal". Open Style&Formatting dialog, right-click cell style 'default', select 'New'. Enter a name for the new style in tab 'Organizer',e.g. 'myLabels'. In tab 'Numbers' select 'User-defined'. Then write the following into the input field 'Format' [=1]"malnutrition";[=2]"normal";[RED]Standard You can click on the "edit comment" icon to define an identifier for this format. Then click the green check mark to add it. OK. Now mark the area where you will enter the data and assign the newly created cell style. When you now enter a 1 into a cell, the input line shows a 1 and you can calculate with the content 1, but in the cell itself you will see 'malnutrition'. I have included the part [RED]Standard, so that all other numbers will be in red to show, that this entry is not correct. Find more about Format codes in the help. Kind regards Regina som schrieb: hello friends, calc is a powerful spreadsheet program and i want to use this for data analysis. let's say, one study has a variable named "malnutrition" measuring the nutritional status of under-five children. this variable has two value levels - "1=malnutrition" and "2=normal" (ods file link=http://s000.tinyupload.com/?file_id=01897194432026825577). present scenario: if data in entered as "1"/"2", spreadsheet will show it as "1"/"2". if it is entered as "malnutrition"/"normal", it will be shown in that manner. what I expect: after doing value labeling (i.e., telling calc that "1=malnutrition" and "2=normal"), data will be entered as "1"/"2" and it'll appear as "malnutrition"/"normal"). possibilities: renaming the cell. as could be seen in this image (http://s000.tinyupload.com/?file_id=03212213468569832926), cell A2 has a code of "1" and is renamed to "malnutrition" (upper left corner). problem: need to select each cell containing "1" and rename it to malnutrition. otherwise cell A4 is not showing malnutrition for code 1 (http://s000.tinyupload.com/?file_id=37582743697322862277).so i guess, my question finally comes to this- is there any way to do this in a spreadsheet program? waiting for your responses. thanks in advance. regards, som -- 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 use coding and labelling in a spreadsheet
hello friends, calc is a powerful spreadsheet program and i want to use this for data analysis. let's say, one study has a variable named "malnutrition" measuring the nutritional status of under-five children. this variable has two value levels - "1=malnutrition" and "2=normal" (ods file link=http://s000.tinyupload.com/?file_id=01897194432026825577). present scenario: if data in entered as "1"/"2", spreadsheet will show it as "1"/"2". if it is entered as "malnutrition"/"normal", it will be shown in that manner. what I expect: after doing value labeling (i.e., telling calc that "1=malnutrition" and "2=normal"), data will be entered as "1"/"2" and it'll appear as "malnutrition"/"normal"). possibilities: renaming the cell. as could be seen in this image (http://s000.tinyupload.com/?file_id=03212213468569832926), cell A2 has a code of "1" and is renamed to "malnutrition" (upper left corner). problem: need to select each cell containing "1" and rename it to malnutrition. otherwise cell A4 is not showing malnutrition for code 1 (http://s000.tinyupload.com/?file_id=37582743697322862277).so i guess, my question finally comes to this- is there any way to do this in a spreadsheet program? waiting for your responses. thanks in advance. regards, som -- 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
