[libreoffice-users] Re: [libreoffice-marketing] Lao Open Source Training on LibreOffice
Hello Anousak, Congrats! It is good to see you as active as ever since the old days of OpenOffice! Do you have a pointer we could share publicly? Best, Charles. On 18 juillet 2014 12:03:13 CEST, Anousak Souphavanh anou...@gmail.com wrote: Hi LibreOfficers, I am happy to share some news from Laos. From 14 to 30 of July 2014, we are conducting the first ever Open Source training in public schools for both students and teachers titled 'Free Open Source Software adoption in secondary schools' namely 10 major high schools in the capital of Laos. We have adopted LibreOffice as major office application: Write, Calc, Impress, and Math. We concentrate on 10% technical and the rest is of practical. The Ministry of Post and Telecommunications' Department of Planning and Cooperation received funding from ASEAN ICT and we are the main partner for the training. I am very grateful to people who are very supportive and very kind for the good cause here in Laos and we hope to further our Open Source developments for the great benefit of the people and society. As you might already know, I am the Lao Open Source evangelist and have been working and pushing Lao open source for nearly 15 years now. We are very happy to get thus far and the work is not stopping here, there is no limit to what we can do. Attached are photos of the training. Cheers and long live the Open Source, Anousak Souphavanh Lao Open Source -- To unsubscribe e-mail to: marketing+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/marketing/ All messages sent to this list will be publicly archived and cannot be deleted -- Envoyé de mon téléphone avec Kaiten Mail. Excusez la brièveté. -- 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: base error - no SDBC drive
On Fri, 18 Jul 2014 09:16:49 +0100 Tom Davies tomc...@gmail.com wrote: [snip] Oddly i still see a LOT of job adverts for programmers who can write Java. I'm hoping that is to help companies migrate away or to re-write existing java packages! [snip] How sad :( Java had such great promise. Java was *supposed* to be immune to all this. Instead, due to the realities of market pressures and the scourge of poor design and coding, Java has become at least as bad a word in the I.T. community as ActiveX -- possibly worse. Plus it's a PITA to code in, has horrible load times, and write once, run anywhere never did become fully real. It was bad enough under Sun. Now that Oracle owns it, I think it's doomed. Regards, Jim -- Note: My mail server employs *very* aggressive anti-spam filtering. If you reply to this email and your email is rejected, please accept my apologies and let me know via my web form at http://jimsun.LinxNet.com/contact/scform.php. -- 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] Calc function to return the daynumber weeknumber of the year
Like how MONTH(TODAY()) returns the month$ of the year (ie, 1 for January, 12 for December)... Is their one? Or if not, maybe a simple formula I can use to calculate? Thanks -- 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] Calc function to return the daynumber weeknumber of the year
Hi, Am 19.07.2014 15:25, schrieb Tanstaafl: Is their one? Yes. https://help.libreoffice.org/Calc/WEEKNUM https://help.libreoffice.org/Calc/Date_and_Time_Functions#Functions Cheers, Stefan -- LibreOffice - Die Freiheit nehm' ich mir! -- 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] Calc function to return the daynumber weeknumber of the year
At 09:25 19/07/2014 -0400, Charles Marcus wrote: Calc function to return the daynumber weeknumber of the year Sorry, but I've no idea what a daynumber weeknumber is. Like how MONTH(TODAY()) returns the month$ of the year (ie, 1 for January, 12 for December)... Oddly, you've defined the quantity you don't want but not the one you do. Is there one? Or if not, maybe a simple formula I can use to calculate? Surely one or the other. Here are some possibilities: WEEKDAY(Date; Type) gives the day of the week (as an integer) for the given date value. For Type = 1, Sunday is day 1; for Type = 2, Monday is day 1; for Type = 3, Monday is day 0. WEEKNUM(Date; Mode) gives the number of the week within the year for the given date value. For Type = 1, the week starts on Sunday; for any other value, on Monday. WEEKNUM_ADD(Date; Mode) mimics Excel's WEEKNUM() function. Note that you can also simply format cells as WW to display a week number. You probably need to experiment with these to ensure they do what you need, since definitions of day and week numbers are many and various. Test to ensure that whatever you choose acts as you expect around the end of the year and in years with fifty-three weeks. Which years have fifty-three weeks itself depends on the other definitions. 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] Re: Calc function to return the daynumber weeknumber of the year
For weeks they have been always in LibreOffice: WEEKNUM( ) returns ISO 8601 week numbers. WEEKNUM_ADD( ) returns week number as excel. For days: =DAYS(TODAY();DATE(YEAR(TODAY());1;1)-1) I think the best way to find calc functions it's through function wizard: http://nabble.documentfoundation.org/file/n4116065/Captura.png -- View this message in context: http://nabble.documentfoundation.org/Calc-function-to-return-the-daynumber-weeknumber-of-the-year-tp4116056p4116065.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] Problem with standard filter
Rob Jasper wrote: Hi, I hope someone can help me with this... I have a spreadsheet with around 4000 rows in it. It has an autofilter in de co;umn headings. In column B I have some 10 fields containing aaa, and 3 fields bbb. Now I filter on bbb I clear the 3 fields If I mark all (it is not marked upon opening) in the filter I get indeed the whole list If I now repeat this for the aaa fields: upon opening the all and aaa is ticked If I unselect ALL, aaa gets unselected too (reasonable, since that the gebaviour for more the one slection values too) If I now select aaa, the ALL mark is also automatically selected!! This looks plain wrong to me since no filtering is different then filtering on 1 value, since there are also empty fields. It does seem to make setting up the filters somewhat confusing. Basically, deselecting All and then selecting all specific values (but not empty) acts the same as selecting All (which includes empty). With more than one value, plus some empty cells, in the column: - e.g. some cells with aaa, some with bbb, some empty. - Filter on aaa shows only rows containing aaa (not bbb or empty) - Filter on bbb shows only rows containing bbb (not aaa or empty) - Filter on Empty shows only rows with empty cell (not aaa or bbb) - Filter on All shows all rows (aaa, bbb and empty) - Attempting to filter for aaa or bbb automatically selects All, and includes the empty cells. With only one value, plus some empty cells, in the column: - e.g. some cells with aaa, some empty. - Filter on Empty shows only rows with empty cell (not aaa) - Filter on All shows all rows (aaa and empty) - Attempting to filter for aaa automatically selects All, and includes the empty cells. I've checked this using LO 4.0.4, which is admittedly quite an old version, on Windows. OK, the workaround is selecting on 'not empty' Now the tick on 'aaa' is cleared, which seems wrong too! This does seem to work as a workaround. I think the tick boxes are intended as a quick was to set up basic filters, and don't accurately reflect more complex filters. Although they don't look right after selecting Not Empty, clicking Standard Filter... does show that the filter is currently set to show Not Empty values. Now I clear the values Now the tick is set at ALL, and I can't clear the filter anymore... (the button is blue) Select Standard Filter..., set the Field name to - none - and click OK. Workaround: enter a bogus value in the column Select all (the select mark goes off) Now delete the value Working on Mac OSX 10.7.5, LO 4.2.4.2 (build 63150712c6d317d27ce2db16eb94c2f3d7b699f8) Am I missing something here? I couldn't see any open bugs with a quick search. I'd suggest upgrading to the latest version in the 4.2 branch (i.e. 4.2.5) and see if the problem still occurs. If it does, search again for any existing bugs and, assuming none are found, report either using the bug submission assistant at https://www.libreoffice.org/get-help/bug/ or the full bug tracker at https://bugs.libreoffice.org/. Mark. -- 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: Problem with standard filter
Rob Jasper: If I unselect ALL, aaa gets unselected too (reasonable, since that the gebaviour for more the one slection values too) If I now select aaa, the ALL mark is also automatically selected!! This looks plain wrong to me since no filtering is different then filtering on 1 value, since there are also empty fields. https://bugs.freedesktop.org/show_bug.cgi?id=46062 -- 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] formula years since date
I want the years since a date and today. I tried this function: =YEARS(7/16/2012,TODAY(),1) but it returns 1900. -- 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: formula years since date
JAMES-2 wrote =YEARS(7/16/2012,TODAY(),1) The literal date needs to be quoted: =YEARS(7/16/2012,TODAY(),1) Best wishes, Owen. -- View this message in context: http://nabble.documentfoundation.org/formula-years-since-date-tp4116088p4116090.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] formula years since date
At 20:27 19/07/2014 -0400, James Lockie wrote: I want the years since a date and today. I tried this function: =YEARS(7/16/2012,TODAY(),1) but it returns 1900. Your first argument is 7 divided by 16 divided by 2,012. This is approximately 0.00022, representing - as a date and time - nineteen seconds after midnight on the date origin. So I'd expect the result to be 115. But in any case it won't have anything to do with a date in July 2012. The arguments of YEARS() need to be numeric dates, so I think you need something like =YEARS(DATE(2012,7,16),TODAY(),1) or =YEARS(DATEVALUE(7/16/2012),TODAY(),1) 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
Re: [libreoffice-users] formula years since date
On 07/19/14 21:34, Brian Barker wrote: At 20:27 19/07/2014 -0400, James Lockie wrote: I want the years since a date and today. I tried this function: =YEARS(7/16/2012,TODAY(),1) but it returns 1900. Your first argument is 7 divided by 16 divided by 2,012. This is approximately 0.00022, representing - as a date and time - nineteen seconds after midnight on the date origin. So I'd expect the result to be 115. But in any case it won't have anything to do with a date in July 2012. The arguments of YEARS() need to be numeric dates, so I think you need something like =YEARS(DATE(2012,7,16),TODAY(),1) or =YEARS(DATEVALUE(7/16/2012),TODAY(),1) I trust this helps. Brian Barker I tried: =YEARS(DATE(2012,7,16),TODAY(),1) I still get 1900. The cell format is . -- 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] formula years since date
On 07/19/14 22:44, James wrote: On 07/19/14 21:34, Brian Barker wrote: At 20:27 19/07/2014 -0400, James Lockie wrote: I want the years since a date and today. I tried this function: =YEARS(7/16/2012,TODAY(),1) but it returns 1900. Your first argument is 7 divided by 16 divided by 2,012. This is approximately 0.00022, representing - as a date and time - nineteen seconds after midnight on the date origin. So I'd expect the result to be 115. But in any case it won't have anything to do with a date in July 2012. The arguments of YEARS() need to be numeric dates, so I think you need something like =YEARS(DATE(2012,7,16),TODAY(),1) or =YEARS(DATEVALUE(7/16/2012),TODAY(),1) I trust this helps. Brian Barker I tried: =YEARS(DATE(2012,7,16),TODAY(),1) I still get 1900. The cell format is . I set the cell format to numeric and got what I want. :-) -- 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