[libreoffice-users] Calc formula for US Thanksgiving date
I need a formula for Calc to determine the US Thanksgiving date for a given year. Thanks -- www.eBookRing.net The designer and maker of the original eBookRing The perfect stand for eReaders, iPads, iPhones, tablet computers and other electronic devices. Patent Pending -- For unsubscribe instructions e-mail to: users+h...@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] built-in help - how to activate it
Hi, I just downloaded the 3.6.3 built-in help and installed it but when I press F1 or help button I still go to the browser/wiki help which I really don't like. Any tip what else one needs to do besides installing it to get Windows style help file - which I assume is what is installed by the built-in help. Thanks for any tips Werner -- For unsubscribe instructions e-mail to: users+h...@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 formula for US Thanksgiving date
You should get a lot of responses on this. US Thanksgiving is always the 4th Thursday in November. So, the first thing you want to do is find out what day of the week November 1, , in a particular year is. (There are functions for this). Then find out how many days later the first Thursday is. (In 2012, the answer is 0.) You'll have to work this out based on how day-of-week is counted. Add that number of days and 21 more to the November 1, date value. That will show you the date of Thanksgiving in year . (For 2012, the correct answer is November 22, 2012.) - Dennis -Original Message- From: . [mailto:l...@ebookring.net] Sent: Monday, December 03, 2012 02:59 To: users@global.libreoffice.org Subject: [libreoffice-users] Calc formula for US Thanksgiving date I need a formula for Calc to determine the US Thanksgiving date for a given year. Thanks -- www.eBookRing.net The designer and maker of the original eBookRing The perfect stand for eReaders, iPads, iPhones, tablet computers and other electronic devices. Patent Pending -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 formula for US Thanksgiving date
2012/12/3 Dennis E. Hamilton dennis.hamil...@acm.org: You should get a lot of responses on this. Actually, I responded quite a few times, but unfortunately I forgot (as usual) about the ”new” nad odd behaviour of this list, so I only responded directly to the OP. That was not my intention, though, so here is a short summary, just in case someone happens to be interested: A1: Year B1: =IF(WEEKDAY(DATE(A1;10;31);2)4;4;11)-WEEKDAY(DATE(A1;10;31);2)+21 The WEEKDAY thing is always calculated twice, which could feel a bit unnecessary. Could be avoided by using a cell for subtotal: A1: Year B1: WEEKDAY(DATE(A1;10;31);2) C1: =IF(B14;4;11)-B1+21 Here's a macro that does the whole thing: REM * BASIC * Function Thanksgiving(Year As Long) As Date Dim DayOfWeek As Long DayOfWeek=WeekDay(DateSerial(Year,10,31)) If DayOfWeek5 Then Thanksgiving=DateSerial(Year,11,26-DayOfWeek) Else Thanksgiving=DateSerial(Year,11,33-DayOfWeek) EndIf End Function REM * END OF BASIC * A1: Year B1: =THANKSGIVING(A1) US Thanksgiving is always the 4th Thursday in November. So, the first thing you want to do is find out what day of the week November 1, , in a particular year is. (There are functions for this). I found the whole thing a bit easier if I started by finding out the weekday of 31 October, but I guess it's just another way of doing it. Then find out how many days later the first Thursday is. (In 2012, the answer is 0.) You'll have to work this out based on how day-of-week is counted. Add that number of days and 21 more to the November 1, date value. That will show you the date of Thanksgiving in year . (For 2012, the correct answer is November 22, 2012.) - Dennis -Original Message- From: . [mailto:l...@ebookring.net] Sent: Monday, December 03, 2012 02:59 To: users@global.libreoffice.org Subject: [libreoffice-users] Calc formula for US Thanksgiving date I need a formula for Calc to determine the US Thanksgiving date for a given year. Thanks -- www.eBookRing.net The designer and maker of the original eBookRing The perfect stand for eReaders, iPads, iPhones, tablet computers and other electronic devices. Patent Pending -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 formula for US Thanksgiving date
At 05:58 03/12/2012 -0500, Dottie Noname wrote: I need a formula for Calc to determine the US Thanksgiving date for a given year. I could have answered this sooner but resisted at first because of the unfriendly - frankly selfish - habit of suppressing any name. How is anyone to refer to you? How is anyone to search for your previous messages? It doesn't matter if you use your real name or not: call yourself Albert Einstein or Mickey Mouse or Algernon Cholmondeley-Featherstonehaugh if you wish, but please remember that you are asking for help and grant everyone the courtesy of giving yourself some sort of usable handle. Thank you. /soapbox It's not exactly clear what you want here: for this year, for example, would you like the result to be the integer 22 or the date value 22 November 2012? (I'm guessing probably the latter.) For the integer: =29-WEEKDAY(DATE(Xn;11;3)) or for the date value: =DATE(Xn;11;29)-WEEKDAY(DATE(Xn;11;3)) In each case, Xn is the cell with the relevant year. In the second case, the result cell will have to be appropriately formatted in order to display as you will wish. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 formula for US Thanksgiving date
2012/12/3 Brian Barker b.m.bar...@btinternet.com: At 05:58 03/12/2012 -0500, Dottie Noname wrote: I need a formula for Calc to determine the US Thanksgiving date for a given year. I could have answered this sooner but resisted at first because of the unfriendly - frankly selfish - habit of suppressing any name. How is anyone to refer to you? How is anyone to search for your previous messages? It doesn't matter if you use your real name or not: call yourself Albert Einstein or Mickey Mouse or Algernon Cholmondeley-Featherstonehaugh if you wish, but please remember that you are asking for help and grant everyone the courtesy of giving yourself some sort of usable handle. Thank you. /soapbox It's not exactly clear what you want here: for this year, for example, would you like the result to be the integer 22 or the date value 22 November 2012? (I'm guessing probably the latter.) For the integer: =29-WEEKDAY(DATE(Xn;11;3)) or for the date value: =DATE(Xn;11;29)-WEEKDAY(DATE(Xn;11;3)) He he he… that was a lot more elegant than my version! Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ In each case, Xn is the cell with the relevant year. In the second case, the result cell will have to be appropriately formatted in order to display as you will wish. I trust this helps. Brian Barker -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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 formula for US Thanksgiving date
Figured it out by using an Excel
formula;Thanksgiving Day
==
=DATE(E5,11,29)-WEEKDAY(DATE(E5,11,24))
In this case “E5” is the cell where
the year number is located)
Thanks, everyone, for your efforts.
!--
@page { margin: 0.79in }
H1 { margin-bottom: 0.08in }
H1.western { font-family: Ubuntu; font-size: 11pt }
H1.cjk { font-family: Droid Sans; font-size: 16pt }
H1.ctl { font-family: Lohit Hindi; font-size: 16pt }
P { margin-bottom: 0.08in }
A:link { so-language: zxx }
--On 12/03/2012 10:47 AM, Dennis E. Hamilton wrote:
You should get a lot of responses on this.
US Thanksgiving is always the 4th Thursday in November.
So, the first thing you want to do is find out what day of the week November 1,
, in a particular year is. (There are functions for this).
Then find out how many days later the first Thursday is. (In 2012, the answer
is 0.) You'll have to work this out based on how day-of-week is counted.
Add that number of days and 21 more to the November 1, date value. That
will show you the date of Thanksgiving in year . (For 2012, the correct
answer is November 22, 2012.)
- Dennis
-Original Message-
From: . [mailto:l...@ebookring.net]
Sent: Monday, December 03, 2012 02:59
To:users@global.libreoffice.orgSubject: [libreoffice-users] Calc formula for US
Thanksgiving date
I need a formula for Calc to determine the US Thanksgiving date for a
given year.
Thanks--www.eBookRing.netThe designer and maker of the original eBookRing
The perfect stand for eReaders, iPads, iPhones, tablet computers and other
electronic devices.
Patent Pending
--
For unsubscribe instructions e-mail to: users+h...@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] Can't print to bypass tray
Hi. Not sure if this is related to the thread with subject Collate print option not working but I don't seem to be able to print to the bypass tray of my Ricoh AP410N. I can select the tray in the options but it won't stick (stay selected). I have tried setting it in printer settings also. Other applications print to this tray ok. Opensuse LO3.5 (403), opensuse 12.2 x64, tried 3 different drivers including manufacturers. Cheers, steve -- For unsubscribe instructions e-mail to: users+h...@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] unsubscribe
-- For unsubscribe instructions e-mail to: users+h...@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] messages returned
(2012/11/24 16:20), Jay Lozier wrote: Your message this time made it through to the list. 5.7.1 is the error code for spam. Good morning Now that the technical problems of sending messages containing the ex word to the list have been mostly clarified, is there maybe also any idea, why my LO crashes in my office computer 100% when using File - Wizard, while this works fine at home? LO = 3.6.3.2, Windows XP on both computers. The number of you know what (sounds like talking about Voldemort in Harry Potter) in my office computer is only half that of what my home computer has. One you know what was a little outdated. But updating did not solve the problem. Neither did the Java thing change anything. So, where else could/should I look for what? As far as I can tell in the moment, no other software has any problem. Thank you in advance. Thomas -- For unsubscribe instructions e-mail to: users+h...@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] query re. LO crashing ...
... all was fine until today; LO no longer opens PDF files or word files ... what could have happened ??? If I up-date [from 3.4] will this clear up the problem? or will the problem persist? AND where is the best place to download the program - updates - without all the bits and pieces separated out; ok, I'm looking for a simplified, non-geek place to upload the updated version [to which ???]. The more I learn of these computers, the stupider I feel ;-) Anyone else in this boat ... anyone able to help the drowning ... or is it time to pitch this 'glorified typewriter' out the window and retrieve the manual typewriter from the attic ... -- For unsubscribe instructions e-mail to: users+h...@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] built-in help - how to activate it
Hi, I had the same problem. If I remember right you need to make sure that the languages set up in Tools - Options - Language settings - Languages match the language of the Help file that you installed. G. On 3 December 2012 16:24, Werner F. Bruhin werner.bru...@free.fr wrote: Hi, I just downloaded the 3.6.3 built-in help and installed it but when I press F1 or help button I still go to the browser/wiki help which I really don't like. Any tip what else one needs to do besides installing it to get Windows style help file - which I assume is what is installed by the built-in help. Thanks for any tips Werner -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted -- For unsubscribe instructions e-mail to: users+h...@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
