[users] Re: Date ??
2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
I live in the Eastern USA. Many thanks for the replies, but someone contacted me privately and showed me the way to correct the problem. Thanks for all your help. Irv. On Sun, Sep 4, 2011 at 11:56 AM, Irv [K3IRV] McWherter irv4...@gmail.comwrote: I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.comwrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
In Calc: FormatCells... (or right-click in the cell to be formatted) to open the cell formatting dialog box. Scroll down to Date and select the format. Otherwise key in your own format in the 'Format code' box. M On Sun, Sep 4, 2011 at 11:02 AM, Irv [K3IRV] McWherter irv4...@gmail.comwrote: I live in the Eastern USA. Many thanks for the replies, but someone contacted me privately and showed me the way to correct the problem. Thanks for all your help. Irv. On Sun, Sep 4, 2011 at 11:56 AM, Irv [K3IRV] McWherter irv4...@gmail.comwrote: I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- Martin du Saire Biological Sciences Technician USDA-ARS 470 Borlaug Hall 1991 Upper Buford Circle St. Paul, Minnesota 55108 612-625-9747 mdusa...@umn.edu -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
Thank you Martin. Irv. 2011/9/4 Martin du Saire mdusa...@umn.edu In Calc: FormatCells... (or right-click in the cell to be formatted) to open the cell formatting dialog box. Scroll down to Date and select the format. Otherwise key in your own format in the 'Format code' box. M On Sun, Sep 4, 2011 at 11:02 AM, Irv [K3IRV] McWherter irv4...@gmail.comwrote: I live in the Eastern USA. Many thanks for the replies, but someone contacted me privately and showed me the way to correct the problem. Thanks for all your help. Irv. On Sun, Sep 4, 2011 at 11:56 AM, Irv [K3IRV] McWherter irv4...@gmail.com wrote: I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? What are your language settings? Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ Many thanks, Irv. -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- Martin du Saire Biological Sciences Technician USDA-ARS 470 Borlaug Hall 1991 Upper Buford Circle St. Paul, Minnesota 55108 612-625-9747 mdusa...@umn.edu -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
On 09/04/2011 12:02 PM, Irv [K3IRV] McWherter wrote: I live in the Eastern USA. Many thanks for the replies, but someone contacted me privately and showed me the way to correct the problem. Thanks for all your help. Irv. On Sun, Sep 4, 2011 at 11:56 AM, Irv [K3IRV] McWherter irv4...@gmail.com mailto:irv4...@gmail.com wrote: I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.com mailto:gurus.knu...@gmail.com wrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com mailto:irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? /snip/ Irv, one of the purposes of these lists is to help *everyone* who is reading them. Your problem is very likely to be somebody else's also. Could you share your solution with the rest of us, please? --doug -- Blessed are the peacemakers...for they shall be shot at from both sides. --A. M. Greeley -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date ??
Hello Doug: The answer to the date problem can be solved in two ways. My particular problem was in the spreadsheet program The software has the ability to accept different date formats other than those that appear in the drop down menu. The following can be applied to a single cell, or to a group of highlighted cells. 1. Click on cell, or highlighted group of cells. 2. Click on Format. 3. Click on date under Category. 4. Go to bottom of window and there is window with a title Format Code. Highlight over whatever is there and type in the format needed DD/MM/YY and then hit OK at the bottom of the page and it worked. Wheww! Thanks for all the help and interest with my problem. Irv. On Sun, Sep 4, 2011 at 2:05 PM, Doug dmcgarr...@optonline.net wrote: ** On 09/04/2011 12:02 PM, Irv [K3IRV] McWherter wrote: I live in the Eastern USA. Many thanks for the replies, but someone contacted me privately and showed me the way to correct the problem. Thanks for all your help. Irv. On Sun, Sep 4, 2011 at 11:56 AM, Irv [K3IRV] McWherter irv4...@gmail.comwrote: I am using Default - English (USA) Irv. On Sun, Sep 4, 2011 at 11:46 AM, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2011/9/4 Irv [K3IRV] McWherter irv4...@gmail.com: Hi All: I have a date problem. The OO ensemble does not seem to allow a date choice of DD/MM/YY. I have some documents that I must submit in this format, but I cannot find it in the cell format selection, nor can I figure out how to do it otherwise. Can anyone out there help me before you leave? /snip/ Irv, one of the purposes of these lists is to help *everyone* who is reading them. Your problem is very likely to be somebody else's also. Could you share your solution with the rest of us, please? --doug -- Blessed are the peacemakers...for they shall be shot at from both sides. --A. M. Greeley -- “Experience hath shewn, that even under the best forms (of government) those entrusted with power have, in time, and by slow operations, perverted it into tyranny” Thomas Jefferson -- - To unsubscribe send email to users-unsubscr...@openoffice.org For additional commands send email to sy...@openoffice.org with Subject: help
[users] Re: Date changes in openoffice
2011/4/1 Open Office openoff...@renukaenergy.com: Dear All; Can anybody help me out in this issue..I m using Openoffice 3.3..But whenever i dump some data in open office from software which supports only xls format the dates changes for example 01-04-2011 will be shown as 04/01/2015..So i have to to this manually..Can anyone give some solution it will be of great help to me.. Regards; Niket Kalamkar Hello Niket, See Preferences OOo Calc Calculate (3rd option) Date There you find 3 options, the difference between the 3rd and the 1st/2nd option explains why your dates change when you import from xls. It used to be a difference I stumbled upon when I imported xls from Windows into xls in Mac. -- Guy using LibO 3.3.2/OOo 3.3.0 on a iMac Intel DualCore Snow Leopard -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
[users] Re: Date functions
On 3/4/2011 6:00 PM, Michael wrote: OO 3.0 I have a text document that I would like to have display a number that represents the number of days difference between two dates. For example: There are XX days until Kevin retires. I would like the XX to represent a particular date in the future minus the current date in days. I see how to insert the current date under the FIELDS option but I don't see any options for manipulating that date. Thanks for any suggestions. Michael Spreadsheet cells will work wonderfully for this. For instance: A1 = today() A2 = your birth date A3 = A2-A1 will give you the number for how many days old you are. Joe Conner, Poulsbo, WA USA -- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: sy...@openoffice.org with Subject: help
Re: [users] Re: Date Interpretation - Calc
On 1 April 2010 17:16, Andreas Saeger saege...@onlinehome.de wrote: Harold Fuchs wrote: OOo 3.1.1 on Win XP Pro. I have a column of dates in a text (.txt) file and want to copy them into a column of a Calc sheet. I can't because Calc insists on changing the values. The first few lines of the .txt file look like this: Fri Apr 30 Fri Apr 30 Sat May 1 Sat May 1 ToolsOptions...LangSettingLanguages: Application locale English (US) Do the import of the US figures. Switch back to your prefered locale once you've got the right values. Thanks, Andreas. That works. I didn't realise that Fri Apr 30 is US English and *not* British English. Looks perfectly OK to this Brit. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
[users] Re: Date Interpretation - Calc
Harold Fuchs wrote: Thanks, Andreas. That works. I didn't realise that Fri Apr 30 is US English and *not* British English. Looks perfectly OK to this Brit. Well, as a German I think that the computer program interpretes these expressions as US dates simply because the month portion is followed by the day portion as in 12/31/1999. When importing csv into Calc you can also specify most of the gory details within the text import wizard where you can select single columns or all columns (clicking the top-left corner) and assign some evaluation method. Standard means: Just treat the text strings between as if I would type them into unformatted cells Option Text turns everything into literal text values. Numeric evaluation is supressed for all numeric expressions (indicated by a leading apostroph in the formula bar which is not part of the text value). Then there are 3 different flavours of date evaluation: DMY,MDY and YMD Plus a setting for English(US) which is useful with comma locales like German where the comma is the decimal separator as in 3,1459 Unforturnately, all this is not properly documented. The F1-help says: Date (MDY) Applies a date format (Month, Day, Year) to the imported data in a column. Which is misleading because the applied number format (the one you see on the sheet) is simply the default one for any unformatted cell in a blank new sheet. This depends on the currently active applicationlocale. It should read like: Date (MDY) Evaluates a column of dates as sequence of Month, Day and Year (12/31/1999, 12-31-99, Dec 12 99 and alikes) Spreadsheet documentation is pointless since nobody reads it anyway. Have a nice Easter weekend, Andreas Säger - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Date Interpretation - Calc
Harold Fuchs wrote: OOo 3.1.1 on Win XP Pro. I have a column of dates in a text (.txt) file and want to copy them into a column of a Calc sheet. I can't because Calc insists on changing the values. The first few lines of the .txt file look like this: Fri Apr 30 Fri Apr 30 Sat May 1 Sat May 1 ToolsOptions...LangSettingLanguages: Application locale English (US) Do the import of the US figures. Switch back to your prefered locale once you've got the right values. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Date changes
On 05/24/2009 10:13 AM, H.S.Rai wrote: http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 when opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: 29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 06/01/2009 EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is correct), that mean 1st of June is shown as 6th of Jan. Such error is there for many rows in same spreadsheet. Where is problem? With excel spreadsheet or with OpenOffice? Look at the 'A' cell values: 360: 30/6/2009 361: '27/5/2009 362: '29/5/2009 363: 01/06/2009 In Excel: 360: Format is 'Date' '*3/14/1001' 361: Format is 'Custom' 'd-mmm' 362: Format is 'Custom' 'd-mmm' 363: Format is 'Date' '*3/14/1001' The problem is in Excel. Fix your inconsistent cell formats in Excel. OOo is interpreting the data correctly... GIGO. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Date changes
On 05/24/2009 02:24 PM, NoOp wrote: On 05/24/2009 10:13 AM, H.S.Rai wrote: http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 when opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: 29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 06/01/2009 EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is correct), that mean 1st of June is shown as 6th of Jan. Such error is there for many rows in same spreadsheet. Where is problem? With excel spreadsheet or with OpenOffice? Look at the 'A' cell values: 360: 30/6/2009 361: '27/5/2009 362: '29/5/2009 363: 01/06/2009 In Excel: 360: Format is 'Date' '*3/14/1001' 361: Format is 'Custom' 'd-mmm' 362: Format is 'Custom' 'd-mmm' 363: Format is 'Date' '*3/14/1001' The problem is in Excel. Fix your inconsistent cell formats in Excel. OOo is interpreting the data correctly... GIGO. Sorry, forgot to mention; the easiest way to spot which cells have screwed up formating is to simply select column's A B and format the cells enmass for 'Date 31. December 1999' or 'December 31, 1999'. You'll then easily see which convert to that format which one's do not. - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
[users] Re: Date changes
On 05/24/2009 03:09 PM, Brian Barker wrote: One extra thing I didn't mention before: there is an easy way in Calc to show the difference between the two sorts of data you have in column A. Go to View | Value Highlighting (or Ctrl+F8). The text entries - the majority of your values - will remain black, but the values entered as dates - with which you are having the problem and which are numbers - will turn blue. This way you will more easily see the problem and perhaps be able to decide on your best way forward. Cool! Nice tip, thanks - I like that better than my method of reformating to date w/text! - To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
Re: [users] Re: Date format: filing an issue, avoiding a dupe
2008/12/7 NoOp [EMAIL PROTECTED]: Of course the screenshot will not have made it through to the list. Sorry, here is the screenshot: http://dotancohen.com/images/ooo_calc_date.png Are you talking about when she enters and displays -mm-dd and after it displays correctly, and then clicking on the date and all of a sudden it automagically appears as mm-dd-? But after editing it reappears in the correct format in the cell? That's what mine does if I set the language to Hebrew with a US english locale. The US date shows as mm/dd/ as opposed to mm-dd- but in essence, yes. It will be helpful if you can provide more details: 1. What are the locale settings on her machine? Ouf! She had it set to US_en. I was five nine certain that her locale was en_DK. It seems that I was misconfiguring her locale, when I set the locale in /etc/environment the setting was respected by OOo. So either OOo disregards the user's locale and goes right for the system locale, or I don't know what I'm doing (most likely the second!). 2. What OS? Kubuntu 8.04, sorry. 3. What are the settings in: Tools|Options|Language Settings|Languages It was: Locale Setting: Hebrew Now it is (and I will leave it this way): Danish 4. What are the settings in Format|Cell|Date -mm-dd This is the problem! When editing a cell, I want the editing format to be the same as the display format. Not the same as the locale format. 5. What bugs you _think_ may be related. Now that I have better identified the problem (what I answered in the previous question) I see that none of the bugs that I have open 100% address the issue. I will go through the Calc options very carefully and google tonight. If I cannot find out how to set Calc to use the display format as the edit format, then I will file a new issue. Thanks, Greg, I always appreciate your help. Now that I see that I was sloppy about the locale I am better armed to google my way out of this. Have a great night. -- Dotan Cohen http://what-is-what.com http://gibberish.co.il א-ב-ג-ד-ה-ו-ז-ח-ט-י-ך-כ-ל-ם-מ-ן-נ-ס-ע-ף-פ-ץ-צ-ק-ר-ש-ת ا-ب-ت-ث-ج-ح-خ-د-ذ-ر-ز-س-ش-ص-ض-ط-ظ-ع-غ-ف-ق-ك-ل-م-ن-ه-و-ي А-Б-В-Г-Д-Е-Ё-Ж-З-И-Й-К-Л-М-Н-О-П-Р-С-Т-У-Ф-Х-Ц-Ч-Ш-Щ-Ъ-Ы-Ь-Э-Ю-Я а-б-в-г-д-е-ё-ж-з-и-й-к-л-м-н-о-п-р-с-т-у-ф-х-ц-ч-ш-щ-ъ-ы-ь-э-ю-я ä-ö-ü-ß-Ä-Ö-Ü
[users] Re: Date format: filing an issue, avoiding a dupe
On 12/06/2008 05:49 AM, Dotan Cohen wrote: I have a user suffering from the known issue of Calc presenting date formats in American format (mm/dd/) instead of the user-defined format (In my case -mm-dd) when editing cells. I am going through the OOo issue tracker and I am finding tens of date-related issues, but I cannot find this one particular issue. I would like to avoid filing a dupe so I ask here: 1) Does anyone know of the exact issue number that relates to this issue? 2) Are there any known workarounds / solutions? Is this a misconfiguration issue on our part? Please see attached screenshot that illustrates the -mm-dd format that the user has defined for her cells, yet when editing Calc forces me her use mm/dd/. The software is OOo 3.0 as downloaded from the official OOo website and no configuration settings changed. Thanks. Of course the screenshot will not have made it through to the list. Are you talking about when she enters and displays -mm-dd and after it displays correctly, and then clicking on the date and all of a sudden it automagically appears as mm-dd-? But after editing it reappears in the correct format in the cell? That's what mine does if I set the language to Hebrew with a US english locale. It will be helpful if you can provide more details: 1. What are the locale settings on her machine? 2. What OS? 3. What are the settings in: Tools|Options|Language Settings|Languages 4. What are the settings in Format|Cell|Date 5. What bugs you _think_ may be related. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date formatting in writer
On 04/07/2008 05:56 PM, Joe Hopkins wrote: How can I get Writer to automatiically insert the date into my documents with the desired format. I want the date to be inserted as January 1, 2008 instead of 1/1/2008. No matter what I try, the date format that is automatically inserted is the 1/1/2008 format. Can I change some option to accomplish this? Thanks... Joe Yes. Insert|Fields|Other|Document|Date|Date (not Date (fixed))|Format Then select December 31, 1999 and click the Insert button. That will use your format and automatically update the date. If you want a fixed date in that format, then select Date (fixed) instead. From there on out, that _document_ will have that date format in _that_ field - even if you open on another system. What I don't know how to do is to set that date format as the default. It was discussed on the list sometime back, but I can't recall if anyone ever figured it out. -- You have been cc'd on this reply as you have posted to an open OOo mailing list. Please see: http://www.openoffice.org/mail_list.html for details and how to subscribe or view the archives so that you may see responses from other OOo users. Please *only* reply to users@openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date formatting in writer
On 09/04/2008 00:50, NoOp wrote: On 04/07/2008 05:56 PM, Joe Hopkins wrote: How can I get Writer to automatiically insert the date into my documents with the desired format. I want the date to be inserted as January 1, 2008 instead of 1/1/2008. No matter what I try, the date format that is automatically inserted is the 1/1/2008 format. Can I change some option to accomplish this? Thanks... Joe Yes. Insert|Fields|Other|Document|Date|Date (not Date (fixed))|Format Then select December 31, 1999 and click the Insert button. That will use your format and automatically update the date. If you want a fixed date in that format, then select Date (fixed) instead. From there on out, that _document_ will have that date format in _that_ field - even if you open on another system. What I don't know how to do is to set that date format as the default. It was discussed on the list sometime back, but I can't recall if anyone ever figured it out. I think the default date format is taken from your Locale settings (attribute defined within the Operating System). On Windows: Control PanelRegional and Language OptionsRegional OptionsShort Date. -- Harold Fuchs London, England Please reply *only* to users@openoffice.org
Re: [users] Re: Date formatting in writer
On Wed, 2008-04-09 at 01:01 +0100, Harold Fuchs wrote: On 09/04/2008 00:50, NoOp wrote: On 04/07/2008 05:56 PM, Joe Hopkins wrote: How can I get Writer to automatiically insert the date into my documents with the desired format. I want the date to be inserted as January 1, 2008 instead of 1/1/2008. No matter what I try, the date format that is automatically inserted is the 1/1/2008 format. Can I change some option to accomplish this? Thanks... Joe Hello Joe, This is another of those historical issues opened in 2004: http://qa.openoffice.org/issues/show_bug.cgi?id=30216 which in fact is a child of this issue opened in 2002: http://qa.openoffice.org/issues/show_bug.cgi?id=6180 Issue 30216 has got 20 votes (not bad) but of course if you could add your vote it has a better chance of getting in the top 100 (or whatever number) issues and grab the developers' attention. Cheers, Michele - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date formatting in writer
On 04/08/2008 04:50 PM, NoOp wrote: On 04/07/2008 05:56 PM, Joe Hopkins wrote: How can I get Writer to automatiically insert the date into my documents with the desired format. I want the date to be inserted as January 1, 2008 instead of 1/1/2008. No matter what I try, the date format that is automatically inserted is the 1/1/2008 format. Can I change some option to accomplish this? Thanks... Joe Yes. Insert|Fields|Other|Document|Date|Date (not Date (fixed))|Format Then select December 31, 1999 and click the Insert button. That will use your format and automatically update the date. If you want a fixed date in that format, then select Date (fixed) instead. From there on out, that _document_ will have that date format in _that_ field - even if you open on another system. What I don't know how to do is to set that date format as the default. It was discussed on the list sometime back, but I can't recall if anyone ever figured it out. Sorry - I missed Mike Scott's msgs before I replied. Also Michele Zarri has pointed to the bug/Feature enhancements that have been around for several years... However, to take this a step further, you can use the Autotext feature in OOo to do this: Once you've inserted your date field with the format using Insert|Fields|Other|Document|Date| (use Date(fixed) for this example), select the field with the mouse and then: Edit|Autotext That will open a window for the Autotext dialog should open to My AutoText. - Give it a Name: Today's Date - Give it a shortcut: today - Click AutoText and New - Click Close That will save that autotext format to your autotext path/folder, and it will be available for as long as you have that profile on your computer. So that you don't have to replicate on multiple computers, you can copy the mytexts.bau file in your profile to the other computers as well. Now, let's test it out: - in the doc type: today - and then press F3 You'll see that today's date with the correct format is inserted as a field. Now let's test it in a new doc: - Close the existing document, and if you wish, OOo. Open OOo and open up a new, or any existing document you have handy. - in the doc type: today - and then press F3 The date gets inserted in the format you wish. You can adjust according to what you are comfortable with and also create one for Date (fixed) and Date auto. You can also shorten the shortcut to 't' for today's date, and 'd' for auto date etc. Whatever you think your students will be comfortable with. Again, please *only* reply to [EMAIL PROTECTED] -- You have been cc'd on this reply as you have posted to an open OOo mailing list. Please see: http://www.openoffice.org/mail_list.html for details and how to subscribe or view the archives so that you may see responses from other OOo users. Please *only* reply to users@openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/03/2007 03:57 PM, NoOp wrote: On 10/03/2007 12:25 PM, Sudheer Satyanarayana wrote: Oops! Didn't notice this message first. Here's the info from /opt/openoffice.org2.3/program/versionrc: I don't know what else to suggest other than perhaps add to the bug that Kirill mentioned: http://www.openoffice.org/issues/show_bug.cgi?id=76623 Sudheer/Kirill et al, did you guys ever figure out a fix for this? This seems to be a rather serious bug. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Display Problem
Hello NoOp, On the formula bar I see: A2 - A11: 10/01/2007 A12 - A14: 10/02/2007 A15 : 10/03/2007 On the cell I see: A2 - A11: Sep 30, 07 A12 - A14: Oct 1, 07 A15: Oct 2, 07 When I place the cursor on the A2 and press F2 and then the Esc key, it shows Oct 1, 07. When I switch to another window and then back to OO Calc, Sep 30, 07 displays on cells A2 - A11. The dates displayed on formula bar is correct but not on the cells. NoOp wrote: On 10/02/2007 10:20 PM, NoOp wrote: On 10/02/2007 09:14 PM, Sudheer Satyanarayana wrote: Hello NoOp, Thanks for the reply. I searched the archives but didn't find any information to fix it. I have no clue how to troubleshoot this problem. Can anybody suggest wow I would further investigate this problem? How would I know if it is a local problem? The same is happening on my colleague's computer who is using Ubuntu 7.04. I'm attaching the document with personal data removed. Can somebody try replicate the problem please? Any help would be appreciated, A2 - A11 I see Oct 1, 07 A12 - A14 I see Oct 2, 07 A15 I see Oct 3, 07 I see the same in the formula bar for each. Is that what you get? Correction: in the formula bar I see: A2 - A11 I see 10/01/07 A12 - A14 I see 10/02/07 A15 I see 10/03/07 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- With Warm Regards, Sudheer. S http://www.binaryvibes.co.in - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Display Problem
Hello On 2.3/NL_nl on my iMac, all the dates in your sample file are shown correctly. In this case (contrary to another case on the list today) I cannot confirm the problems you report. -- Guy using dutch OOo 2.3 m221 on a iMac Intel DualCore Tiger and brazilian OOo 2.3 RC 3 on a G4 PPC Powerbook Tiger -- please reply only to users@openoffice.org -- Dodoes can't afford to have headaches - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/03/2007 06:20 AM, Sudheer Satyanarayana wrote: Hello, Any hints to solve this problem? I'm ok with another locale/build/version. Please suggest possible workarounds. I would appreciate any information to temporarily or permanently resolve this issue. Guy Voets wrote: Hello On 2.3/NL_nl on my iMac, all the dates in your sample file are shown correctly. In this case (contrary to another case on the list today) I cannot confirm the problems you report. Can you try the OOo build directly from OOo (http://download.openoffice.org/2.3.0/index.html) see if that makes a difference? Or is that the one that you are using now? Another thing that you might try is to rename your ./openoffice.org2 directory and let OOo rebuild a new one to see if perhaps it is something in your OOo profile. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/03/2007 09:18 AM, NoOp wrote: On 10/03/2007 06:20 AM, Sudheer Satyanarayana wrote: Hello, Any hints to solve this problem? I'm ok with another locale/build/version. Please suggest possible workarounds. I would appreciate any information to temporarily or permanently resolve this issue. Guy Voets wrote: Hello On 2.3/NL_nl on my iMac, all the dates in your sample file are shown correctly. In this case (contrary to another case on the list today) I cannot confirm the problems you report. Can you try the OOo build directly from OOo (http://download.openoffice.org/2.3.0/index.html) see if that makes a difference? Or is that the one that you are using now? Another thing that you might try is to rename your ./openoffice.org2 directory and let OOo rebuild a new one to see if perhaps it is something in your OOo profile. Sorry, clicked send to quickly... can you also provide the version build of your OOo? You can find this two ways: 1. Versions and Build Numbers 1.Choose Help - About OpenOffice.org. This opens a dialog containing document information. 2.To obtain further information, hold down Ctrl and press the letters S D T in succession. At the beginning you will find information about the version and build number. This is followed by a list of contributors. To stop the information before the end, press Esc. 2. In your directory where OOo is installed (for instance mine is in /opt) open: /opt/openoffice.org2.3/program/versionrc in a text editor. That will show you the info. Mine is: [Version] buildid=680m5(Build:9221) ProductPatch= ProductSource=OOG680 ProductMajor=680 ProductMinor=5 ProductBuildid=9221 AllLanguages=en-US UpdateURL=http://update23.services.openoffice.org/ProductUpdateService/check.Update UpdateID=OpenOffice.org_2_en-US UpdateUserAgent=OpenOffice.org 2.3 (680m5(Build:9221); $_OS; $_ARCH; BundledLanguages=en-US) OOOBaseVersion=2.3 ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update and in my Ubuntu'ized OOo 2.3 version (installed in /usr/lib/openoffice/program on another machine): [Version] buildid=680m5(Build:9221) ProductPatch= ProductSource=OOG680 ProductMajor=680 ProductMinor=5 ProductBuildid=9221 AllLanguages=en-US UpdateURL= UpdateID=OpenOffice.org_2_en-US UpdateUserAgent=OpenOffice.org 2.3 (680m5(Build:9221); $_OS; $_ARCH; BundledLanguages=en-US) OOOBaseVersion=2.3 ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update Vendor=Debian and Ubuntu BuildVersion=openoffice.org-core 1:2.3.0-1ubuntu2, Fri Sep 28 13:40:23 GMT 2007 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Display Problem
Hello NoOp, Thanks, but I have already tried them. I was using OO that came with FC6. In an attempt to fix the issue, I uninstalled it and am now using the build from openoffice.org. I have also tried removing the ./openoffice.org2 directory. None of them helped. Could you suggest any other troubleshooting steps? NoOp wrote: On 10/03/2007 06:20 AM, Sudheer Satyanarayana wrote: Hello, Any hints to solve this problem? I'm ok with another locale/build/version. Please suggest possible workarounds. I would appreciate any information to temporarily or permanently resolve this issue. Guy Voets wrote: Hello On 2.3/NL_nl on my iMac, all the dates in your sample file are shown correctly. In this case (contrary to another case on the list today) I cannot confirm the problems you report. Can you try the OOo build directly from OOo (http://download.openoffice.org/2.3.0/index.html) see if that makes a difference? Or is that the one that you are using now? Another thing that you might try is to rename your ./openoffice.org2 directory and let OOo rebuild a new one to see if perhaps it is something in your OOo profile. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- With Warm Regards, Sudheer. S http://www.binaryvibes.co.in - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Display Problem
Oops! Didn't notice this message first. Here's the info from /opt/openoffice.org2.3/program/versionrc: Display all 305 possibilities? (y or n) [EMAIL PROTECTED] ~]# cat /opt/openoffice.org2.3/program/versionrc [Version] buildid=680m5(Build:9221) ProductPatch= ProductSource=OOG680 ProductMajor=680 ProductMinor=5 ProductBuildid=9221 AllLanguages=en-US UpdateURL=http://update23.services.openoffice.org/ProductUpdateService/check.Update UpdateID=OpenOffice.org_2_en-US UpdateUserAgent=OpenOffice.org 2.3 (680m5(Build:9221); $_OS; $_ARCH; BundledLanguages=en-US) OOOBaseVersion=2.3 ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update Pressing Esc key doesn't stop the Credits info from the About OpenOffice.org dialog box. NoOp wrote: On 10/03/2007 09:18 AM, NoOp wrote: On 10/03/2007 06:20 AM, Sudheer Satyanarayana wrote: Hello, Any hints to solve this problem? I'm ok with another locale/build/version. Please suggest possible workarounds. I would appreciate any information to temporarily or permanently resolve this issue. Guy Voets wrote: Hello On 2.3/NL_nl on my iMac, all the dates in your sample file are shown correctly. In this case (contrary to another case on the list today) I cannot confirm the problems you report. Can you try the OOo build directly from OOo (http://download.openoffice.org/2.3.0/index.html) see if that makes a difference? Or is that the one that you are using now? Another thing that you might try is to rename your ./openoffice.org2 directory and let OOo rebuild a new one to see if perhaps it is something in your OOo profile. Sorry, clicked send to quickly... can you also provide the version build of your OOo? You can find this two ways: 1. Versions and Build Numbers 1.Choose Help - About OpenOffice.org. This opens a dialog containing document information. 2.To obtain further information, hold down Ctrl and press the letters S D T in succession. At the beginning you will find information about the version and build number. This is followed by a list of contributors. To stop the information before the end, press Esc. 2. In your directory where OOo is installed (for instance mine is in /opt) open: /opt/openoffice.org2.3/program/versionrc in a text editor. That will show you the info. Mine is: [Version] buildid=680m5(Build:9221) ProductPatch= ProductSource=OOG680 ProductMajor=680 ProductMinor=5 ProductBuildid=9221 AllLanguages=en-US UpdateURL=http://update23.services.openoffice.org/ProductUpdateService/check.Update UpdateID=OpenOffice.org_2_en-US UpdateUserAgent=OpenOffice.org 2.3 (680m5(Build:9221); $_OS; $_ARCH; BundledLanguages=en-US) OOOBaseVersion=2.3 ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update and in my Ubuntu'ized OOo 2.3 version (installed in /usr/lib/openoffice/program on another machine): [Version] buildid=680m5(Build:9221) ProductPatch= ProductSource=OOG680 ProductMajor=680 ProductMinor=5 ProductBuildid=9221 AllLanguages=en-US UpdateURL= UpdateID=OpenOffice.org_2_en-US UpdateUserAgent=OpenOffice.org 2.3 (680m5(Build:9221); $_OS; $_ARCH; BundledLanguages=en-US) OOOBaseVersion=2.3 ExtensionUpdateURL=http://updateext.services.openoffice.org/ProductUpdateService/check.Update Vendor=Debian and Ubuntu BuildVersion=openoffice.org-core 1:2.3.0-1ubuntu2, Fri Sep 28 13:40:23 GMT 2007 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- With Warm Regards, Sudheer. S http://www.binaryvibes.co.in - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/03/2007 12:25 PM, Sudheer Satyanarayana wrote: Oops! Didn't notice this message first. Here's the info from /opt/openoffice.org2.3/program/versionrc: I don't know what else to suggest other than perhaps add to the bug that Kirill mentioned: http://www.openoffice.org/issues/show_bug.cgi?id=76623 Don't know if this matters or not, but my locales are: $ locale LANG=en_US.UTF-8 LC_CTYPE=en_US.UTF-8 LC_NUMERIC=en_US.UTF-8 LC_TIME=en_US.UTF-8 LC_COLLATE=en_US.UTF-8 LC_MONETARY=en_US.UTF-8 LC_MESSAGES=en_US.UTF-8 LC_PAPER=en_US.UTF-8 LC_NAME=en_US.UTF-8 LC_ADDRESS=en_US.UTF-8 LC_TELEPHONE=en_US.UTF-8 LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=en_US.UTF-8 LC_ALL= Clocks are 12 hour _not_ set to UTC. And in OOo: Tools|Options|OpenOffice.org(OOo) Calc|Calculate Date: 12/30/1899 (default) is checked Search criteria... is checked Decimal Places: 2 Tools|Options|OOo|General Year: interpret... 1930 Tools|Cell Contents AutoCalculate and AutoInput are checked - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/02/2007 07:08 PM, Sudheer Satyanarayana wrote: Hello, No comments? On some of the cells, the date displayed is Sep 30, 07. When I place the cursor on the cell with date Sep 30, 07, the date displayed on the formula bar is 10/01/07. The date displayed on the formula bar is correct. Also, when I place the cursor on the cell and press F2 and then Esc key, the date is correctly displayed both on the cell and as well as the formula bar. When I switch to another window and come back to the OO Calc window, again the display is mangled. Has anybody else experienced similar problems? If yes, how have you fixed them? Last month Clive Bowley experienced the exact same problem using a windows version (search the archives for Date format + Clive Bowley. He sent me his spreadsheet of list and I was not able to reproduce in: OOo 2.3 (linux): cannot reproduce OOo 2.1 (linux): cannot reproduce StarOffice 8 (linux): cannot reproduce OOo 2.1 (Windows): cannot reproduce StarOffice 8 (Windows): cannot reproduce MS Excel 2002 SP3 (windows): cannot reproduce I also was not able to reproduce your problem using a single cell w/your date data. Perhaps it's a locale problem? I am in the US and use US locale's in OOo etc. Clive is in the UK so perhaps this is a related regional bug. Perhaps someone from your (and Clive's region) could check? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Display Problem
Hello NoOp, Thanks for the reply. I searched the archives but didn't find any information to fix it. I have no clue how to troubleshoot this problem. Can anybody suggest wow I would further investigate this problem? How would I know if it is a local problem? The same is happening on my colleague's computer who is using Ubuntu 7.04. I'm attaching the document with personal data removed. Can somebody try replicate the problem please? Any help would be appreciated, NoOp wrote: On 10/02/2007 07:08 PM, Sudheer Satyanarayana wrote: Hello, No comments? On some of the cells, the date displayed is Sep 30, 07. When I place the cursor on the cell with date Sep 30, 07, the date displayed on the formula bar is 10/01/07. The date displayed on the formula bar is correct. Also, when I place the cursor on the cell and press F2 and then Esc key, the date is correctly displayed both on the cell and as well as the formula bar. When I switch to another window and come back to the OO Calc window, again the display is mangled. Has anybody else experienced similar problems? If yes, how have you fixed them? Last month Clive Bowley experienced the exact same problem using a windows version (search the archives for Date format + Clive Bowley. He sent me his spreadsheet of list and I was not able to reproduce in: OOo 2.3 (linux): cannot reproduce OOo 2.1 (linux): cannot reproduce StarOffice 8 (linux): cannot reproduce OOo 2.1 (Windows): cannot reproduce StarOffice 8 (Windows): cannot reproduce MS Excel 2002 SP3 (windows): cannot reproduce I also was not able to reproduce your problem using a single cell w/your date data. Perhaps it's a locale problem? I am in the US and use US locale's in OOo etc. Clive is in the UK so perhaps this is a related regional bug. Perhaps someone from your (and Clive's region) could check? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- With Warm Regards, Sudheer. S http://www.binaryvibes.co.in date-format-problem.ods Description: application/vnd.oasis.opendocument.spreadsheet - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/02/2007 09:14 PM, Sudheer Satyanarayana wrote: Hello NoOp, Thanks for the reply. I searched the archives but didn't find any information to fix it. I have no clue how to troubleshoot this problem. Can anybody suggest wow I would further investigate this problem? How would I know if it is a local problem? The same is happening on my colleague's computer who is using Ubuntu 7.04. I'm attaching the document with personal data removed. Can somebody try replicate the problem please? Any help would be appreciated, A2 - A11 I see Oct 1, 07 A12 - A14 I see Oct 2, 07 A15 I see Oct 3, 07 I see the same in the formula bar for each. Is that what you get? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Display Problem
On 10/02/2007 10:20 PM, NoOp wrote: On 10/02/2007 09:14 PM, Sudheer Satyanarayana wrote: Hello NoOp, Thanks for the reply. I searched the archives but didn't find any information to fix it. I have no clue how to troubleshoot this problem. Can anybody suggest wow I would further investigate this problem? How would I know if it is a local problem? The same is happening on my colleague's computer who is using Ubuntu 7.04. I'm attaching the document with personal data removed. Can somebody try replicate the problem please? Any help would be appreciated, A2 - A11 I see Oct 1, 07 A12 - A14 I see Oct 2, 07 A15 I see Oct 3, 07 I see the same in the formula bar for each. Is that what you get? Correction: in the formula bar I see: A2 - A11 I see 10/01/07 A12 - A14 I see 10/02/07 A15 I see 10/03/07 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: date math
Neal Piche [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] ok so here is what I've got, I have to fields move in and move out both in date format and a third field length which I would like to show # yrs # mo # days automatically. when I tried to make the third field a date to show the difference it gives me a nonsense date I realize now that is because it is taking the integer value that is returned when subtracting dates and using it as it's internal representation. so I guess I have to use a number field but I just don't know what to do please help I think I understand you to be saying you want the different between two dates to be expressed in the form of number of years, months and days. Have a look at the DAYS, MONTHS, YEARS functions. You'll probably have to use a formula to format a string in the format you want. I don't know how you'll handle the leap year issue. -- Bob Long P.S. You have written to a mailing list where help is provided by volunteers. Please reply only to the mailing list at [EMAIL PROTECTED] FAQ, userguide, etc: http://documentation.openoffice.org/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [Date Format Default Question] Re: Date format
On 09/07/2007 01:59 AM, LoLo wrote: I did start this as a new thread. Brian Russel answered my original question and i responded directly to his answer to which Clive Bowley responded. It would therefore be appreciated if you got your facts correct and stop mixing emails up to suit some agenda that you have to tell people off. LoLo Perhaps you missed: Interesting... I show Clive's first in the thread Message-ID: [EMAIL PROTECTED] then Lolo's Message-ID: [EMAIL PROTECTED] I think I may have figured out the problem; Clive's msg has a date of Date: Thu, 5 Jul 2007 11:11:08 +0100 and somehow I picked it up as current via the gmane newsreader. My mistake aplogies to Lolo all. Gary - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format
It was using the tab /mouse, not transferring any data regards Clive - Original Message - From: NoOp [EMAIL PROTECTED] Newsgroups: gmane.comp.openoffice.questions Cc: [EMAIL PROTECTED] Sent: Thursday, September 06, 2007 6:03 PM Subject: Re: Date format On 07/05/2007 03:11 AM, Clive Bowley wrote: I'm new to Open Office, and I've opened up an excel file (no macros) one column of which is date formatted to DD/MM/, my problem is that I've inserted a date 26/05/2005 but when I move to the next column or row this date alters to 1 day less ?, ie 25/05/2005 albeit the data input field at the top of the screen still shows the correct details, and I can't find how to correct this. Clive I'm unsure of what you mean by move to the next column or row. Are you referring to selecting the next column or row (using mouse, tab, arrow key), or moving the data in the cell to another column or row? Please reply only to users@openoffice.org - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format
On 09/06/2007 01:25 PM, Clive Bowley wrote: - Original Message - From: NoOp [EMAIL PROTECTED] Newsgroups: gmane.comp.openoffice.questions Cc: [EMAIL PROTECTED] Sent: Thursday, September 06, 2007 6:03 PM Subject: Re: Date format On 07/05/2007 03:11 AM, Clive Bowley wrote: I'm new to Open Office, and I've opened up an excel file (no macros) one column of which is date formatted to DD/MM/, my problem is that I've inserted a date 26/05/2005 but when I move to the next column or row this date alters to 1 day less ?, ie 25/05/2005 albeit the data input field at the top of the screen still shows the correct details, and I can't find how to correct this. Clive I'm unsure of what you mean by move to the next column or row. Are you referring to selecting the next column or row (using mouse, tab, arrow key), or moving the data in the cell to another column or row? Please reply only to users@openoffice.org It was using the tab /mouse, not transferring any data regards Clive That's rather odd I cannot seem to replicate it. Is it possible that you'd be willing to chop out any sensitive stuff on the worksheet and post here or send to me directly? (glgxg at sbcglobal.net). - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [Date Format Default Question] Re: Date format
On 9/6/07 7:19 PM, NoOp wrote: On 09/06/2007 03:53 AM, LoLo wrote: Hi Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. Thanks for any help LoLo In the future it would be appreciated if you started a *new* thread regarding your problem. Yes, I realize that your post has to do with date format as well, but as you can see, your question has detracted from the original question asked by the unsubscribed OP: I do not understand what you are talking about. LoLo's post is the first one that I see in this thread. When I checked the headers I do not see any In Reply To designated. Please explain. I'm new to Open Office, and I've opened up an excel file (no macros) one column of which is date formatted to DD/MM/, my problem is that I've inserted a date 26/05/2005 but when I move to the next column or row this date alters to 1 day less ?, ie 25/05/2005 albeit the data input field at the top of the screen still shows the correct details, and I can't find how to correct this. Clive If nothing else, please at least retag the subject (similar the changed subject in this msg) so that others can distinquish between *your* new added question vs the *OP's* original question. Gary BTW: I am a LoLo as well... :-) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format
LoLo wrote: Thanks Brian, i didn't know about the double click thing so that's a help. Would still like to change the default though if anyone knows how. LoLo Hi, Is this in a document format you will be using regularly? If so you can save the formatted date in a template and whenever you use that template for a new document the date will be in the desired format. For instance I have a letterhead template and the date is inserted above the addressee data. You can make it a fixed date, so it will be the date the new document is created, or it can be updated whenever the file is opened. However the date format is preserved in the template _only_ if it is actually used. So you can't set it up in a blank document and save that as your default, unfortunately. I think if you look in issuezilla you will see an RFE (request for enhancement) for this, but it is not seen as a high enough priority to attract the developers' attention. HTH Russell - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: [Date Format Default Question] Re: Date format
On 09/06/2007 08:41 PM, Larry Gusaas wrote: On 9/6/07 7:19 PM, NoOp wrote: On 09/06/2007 03:53 AM, LoLo wrote: Hi Can someone please tell me how to change the date format default in Writer. It currently inserts the date as 06/09/07 and i want it to insert the date as 06 September 2007 as default. Thanks for any help LoLo In the future it would be appreciated if you started a *new* thread regarding your problem. Yes, I realize that your post has to do with date format as well, but as you can see, your question has detracted from the original question asked by the unsubscribed OP: I do not understand what you are talking about. LoLo's post is the first one that I see in this thread. When I checked the headers I do not see any In Reply To designated. Please explain. Interesting... I show Clive's first in the thread Message-ID: [EMAIL PROTECTED] then Lolo's Message-ID: [EMAIL PROTECTED] I think I may have figured out the problem; Clive's msg has a date of Date: Thu, 5 Jul 2007 11:11:08 +0100 and somehow I picked it up as current via the gmane newsreader. My mistake aplogies to Lolo all. Gary - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Arithmetic in Calc ??
William Case wrote: Hi; Just double checking that I have things in some date formulae written correctly. OOo starts dating at 30/12/1899 shows as Dec 29, 1899 when MMM DD, formatting is applied. It appears to lose a day. The 30/12/1899 date none-the-less is the date that is used for internal date arithmetic, is it not? Put a zero into the formatted cell. It shows 1988-12-30. Check the value (Format 0.0) Your function may need =ROUND(your formula;0) In Help the WEEKS() Function is defined as follows: WEEKS(Start date, End date, Type) Calculates the difference in weeks between two dates. Start date: First date End date: Second date Type: Calculates the type of difference. The possible values are 0 (interval) and 1 (in numbers of weeks). If the Start date is set to 30/12/1899 and End date is today, WEEKS() returns 5562 weeks for Type value 0 and 5563 for Type value 1. Help is not clear, on the difference between interval type (0) and 'in number of weeks' type (1). I have never used that function. I use =(end-start)/7 with round(), roundup() or rounddown(). What I really want to do is count the number of Mondays since the 30/12/1899 start date. I think this means I want to use Type 2 but I would like to have this assumption confirmed, if someone could take the time to help. Not exactly, but I could copy and paste. First day of week for some month: =DATE(myYear;MyMonth;1)+MOD(myDoW-WEEKDAY(DATE(myYear;MyMonth;1));7) where myYear and myMonth specify the month in question and myDoW is a day-of-week-number as returned by WEEKDAY(Date). Sun=1,...Sat=7. Same with last day of week for some month: =DATE(myYear;MyMonth+1;0)-MOD(WEEKDAY(DATE(myYear;MyMonth+1;0))-myDoW;7) Test with some named style having a date-format like -MM-DD NN (2006-06-02 Fr) - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date Arithmetic in Calc ??
On Fri, 2006-11-08 at 23:07 +0200, Andreas Saeger wrote: William Case wrote: Hi; Not exactly, but I could copy and paste. First day of week for some month: =DATE(myYear;MyMonth;1)+MOD(myDoW-WEEKDAY(DATE(myYear;MyMonth;1));7) where myYear and myMonth specify the month in question and myDoW is a day-of-week-number as returned by WEEKDAY(Date). Sun=1,...Sat=7. Same with last day of week for some month: =DATE(myYear;MyMonth+1;0)-MOD(WEEKDAY(DATE(myYear;MyMonth+1;0))-myDoW;7) Test with some named style having a date-format like -MM-DD NN (2006-06-02 Fr) - The 0 (0.00) date value still gives me '30/12/1899'. So there is no problem there, but thanks for the tip of using zero as a start date rather than 30/12/1899. Cleans things up. I appreciate your sharing your formulae, but WEEKS() seems neater and cleaner and has the advantage of being built in, if only I could be certain that the Type in WEEKS(Start Date; End Date; Type) meant what I think it means. I am going to apply your formulae -- after dinner -- and see if I end up at the same place. Thanks again. -- Regards Bill - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date field on a spreadsheet
Dennis J. Tuchler wrote: I have gone through the help files but have found no way to insert today's date in a cell. When I print out the list, I want the date the list was printed in a cell at the top of the sheet. I can put a date field on a document, but not on a spreadsheet. How do I do that? Use the today() function for the current date. Use the now() function for the current date and time. Both functions are automatically updated when a file is opened and when any change is made in a file, such as adding a space and then deleting it. Jallan - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date field on a spreadsheet
=now() gives date and time =today() gives date only Anthony Chilco [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] enter =now() in the cell and format the cell for date the way you want to see it. tc Dennis J. Tuchler wrote: I have gone through the help files but have found no way to insert today's date in a cell. When I print out the list, I want the date the list was printed in a cell at the top of the sheet. I can put a date field on a document, but not on a spreadsheet. How do I do that? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date and calculations inoperative
tony smailes tee.smailes at virgin.net writes: Have recently (last 24 hours) discovered openoffice. Last night (GMT) I downloaded your programme but all calculations including dates are inoperative on trial spreadsheet. What have I done incorrectly? Help please. Tony Smailes. You may need to be more specific. In the meantime, check the following setting: Tools Cell Contents AutoCalculate. It should be ticked. If it isn't, select it, it will be and your calculations will take effect. If that isn't it, you'll have to give examples of formulas and date entries made and the results. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Formatting in OOo 2.0
On 21/12/2005 18:58, Terry North wrote: Bob baasha at shaw.ca writes: I have a column set up in Calc to format dates as MM/DD/YY. This normally works fine. A couple of days ago I tried to enter two dates, 09/12/05 (Sep. 12th) and 10/12/05 (Oct. 12th). The program seems to assume that because I am entering this information in December, then I must mean Dec. 9th and Dec. 10th, which is not the case. I can not seem to find a way to override this behaviour. Am I doing something wrong, or is this a bug? I take it the dates are displaying as 12/09/05 and 12/10/05 even though you input 09/12/05 and 10/12/05. That is strange because the format DD/MM/YY would still show your input as entered. If your cell formats are still correct, perhaps you need to check language settings - Tools /Options /Language Settings /Languages. You haven't used any other formatting? If you do not format the cells, the format you use seems to be the default format. Perhaps you should put the matter beyond any doubt by selecting English (USA) as the language when formatting the cells. Thanks Terry, That was it; a conflict between my locale setting and my date formatting. I worked for an American corporation for many years, so I got used to formatting dates in the American way. But I had my spreadsheet set up for Canadian English, so it is no wonder the program was confused. G.I.G.O. is just as true as it always has been. :-)) Bob - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date Formatting in OOo 2.0
Bob baasha at shaw.ca writes: I have a column set up in Calc to format dates as MM/DD/YY. This normally works fine. A couple of days ago I tried to enter two dates, 09/12/05 (Sep. 12th) and 10/12/05 (Oct. 12th). The program seems to assume that because I am entering this information in December, then I must mean Dec. 9th and Dec. 10th, which is not the case. I can not seem to find a way to override this behaviour. Am I doing something wrong, or is this a bug? I take it the dates are displaying as 12/09/05 and 12/10/05 even though you input 09/12/05 and 10/12/05. That is strange because the format DD/MM/YY would still show your input as entered. If your cell formats are still correct, perhaps you need to check language settings - Tools /Options /Language Settings /Languages. You haven't used any other formatting? If you do not format the cells, the format you use seems to be the default format. Perhaps you should put the matter beyond any doubt by selecting English (USA) as the language when formatting the cells. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format as default
Margaret Stanley stanley at wr14.freeserve.co.uk writes: Every time I enter a date in Writer I need to explicitly set the format to , for example 31 Oct 05 instead of 10/31/05. Is there any way of setting this as a default date format? Margaret Stanley I've only managed to get part of the way: Tools /Options /Language Settings /Languages /Locale Setting: Your Choice, Default Languages ... Western: Your Choice. Since I've chosen Australian English, using the simple date field gives me 09/11/05 (instead of the US format 11/09/05) for 9 November 2005. The only way I can find to get a different format is to use the field other. I too am interested to discover whether there is some way to alter the default format. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date format Date vs. Date Fixed
Jonathan Kaye wrote: If you use Date Fixed, then the date doesn't change (maybe it's hard text rather than a code) so if you enter Date fixed and print today you get 28 June 2005. You print tomorrow and you still get 28 June 2005. Actually, it is still a field code, but the date is not updated when the file is reopened or saved. However, being a field, if it is in a template then the date is updated if you use File-New to start a new document from the template, as well as being an all or nothing deletion or editing item--that is, it's not straight text you could edit (you need to delete the code and then reenter to make a change). -- Ed Zollars, CPA Phoenix, Arizona - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format
On Tue, 28 Jun 2005 08:20:55 -0600, Robin Laing wrote: Peter Kupfer OOo wrote: Robin Laing wrote: Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style Also, can I ask you to briefly explain Date and Date Fixed? What is the difference? Where do you see this term? How do you make it the default format so you don't have to go through and change the format every time? Probably change the default locale. Tools Options Language Settings Languages I just looked, there is no setting for the date format. Only the language. Here is the problem. I use English (Canada) but I need to use ISO date format. How do I set the ISO date format as default? I checked in 1.9.104. I guess this is a bug in my opinion. Try http://qa.openoffice.org/issues/show_bug.cgi?id=3093 as one. It was part of the search I sent the other day. I gather it did not work for you. In that case, do an issue search as follows: 1. Select all but patch in the issue type field 2. Select all but verified in the status field 3. Enter date format in to the summary field 4. Enter date format in to the A description entry: field 5. Click submit This will give a list of existing issues. -- Documentation Co-lead Dinna meddle wi' things ye ken nuthin' aboot! J.H. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [users] Re: Date format
G. Roderick Singleton wrote: On Tue, 28 Jun 2005 08:20:55 -0600, Robin Laing wrote: Peter Kupfer OOo wrote: Robin Laing wrote: Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style Also, can I ask you to briefly explain Date and Date Fixed? What is the difference? Where do you see this term? How do you make it the default format so you don't have to go through and change the format every time? Probably change the default locale. Tools Options Language Settings Languages I just looked, there is no setting for the date format. Only the language. Here is the problem. I use English (Canada) but I need to use ISO date format. How do I set the ISO date format as default? I checked in 1.9.104. I guess this is a bug in my opinion. Try http://qa.openoffice.org/issues/show_bug.cgi?id=3093 as one. It was part of the search I sent the other day. I gather it did not work for you. In that case, do an issue search as follows: 1. Select all but patch in the issue type field 2. Select all but verified in the status field 3. Enter date format in to the summary field 4. Enter date format in to the A description entry: field 5. Click submit This will give a list of existing issues. But this is not the default format. ie I open a document and enter the date field and print. The date format is not ISO. I open a Calc sheet and enter a date, I have to reformat the cells to get the date format. How to set all OOo to default to ISO dates is the question, not how to get ISO dates in documents. I have been doing it one way or another for years (except in footers in Calc). I put comments on the bug link already. I guess I will submit a bug. -- Robin Laing - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date format Date vs. Date Fixed
En/La Graham Window ha escrit, a 25/06/05 07:23: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Also, can I ask you to briefly explain Date and Date Fixed? What is the difference? Best wishes, Graham I don't think any of the other posting got to your question of Date vs. Date Fixed. My understanding (I could be wrong here) is that Date inserts a date code that varies according to when you open the file. Suppose you insert a date field today and print the file, you get 28 June 2005 (or whatever date format you use). If you open and print the file tomorrow you'll get 29 June 2005, etc. If you use Date Fixed, then the date doesn't change (maybe it's hard text rather than a code) so if you enter Date fixed and print today you get 28 June 2005. You print tomorrow and you still get 28 June 2005. Hope this is clear. Jonathan -- Please don't cc: your posting to my personal address. Thank you.
[users] Re: Date format
On Sat, 25 Jun 2005 13:25:42 -0400, G. Roderick Singleton wrote: On Sat, 2005-06-25 at 12:03 -0500, Peter Kupfer OOo wrote: G. Roderick Singleton wrote: On Sat, 2005-06-25 at 11:36 -0500, Peter Kupfer OOo wrote: Graham Window wrote: Hi, Is there a way to change the Date Format fom Americam style to European style (eg. today is July 25th - short date 6/25/05 in America and 25/6/05 in Europe)? Select the cell, right click Format Date Choose style Also, can I ask you to briefly explain Date and Date Fixed? What is the difference? Where do you see this term? Insert Field Other Document Date and you get to choose Date (fixed) or Date. This is describe in Help Contents Index Search term date fields. This also explains the difference between fixed and dynamic. How can I make it so that if I search help for fixed date I get that result? Short of rewriting Help, I do not know. Can I file an issue about that or is there nothing I can do? You might be able to get it added if you file an issue on 2.0. I hate doing followups to my own messages but I forgot to mention that you file against documentation and on-line help. -- Documentation Co-lead Dinna meddle wi' things ye ken nuthin' aboot! J.H. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[users] Re: Date default in Writer
On Sun, 08 May 2005 16:25:00 +0200, Richard Judge wrote: I always use a long date format in my documents and while this is easy to change, from the default 05/08/05 to Sunday, May 8, 2005 I would like the default insertion of the date to be in the long format. Please advise me how this is done, despite some effort I have not been able to do this. Richard You might like to have a look at http://qa.openoffice.org/issues/show_bug.cgi?id=3093 As to why ISO date format is not the default is probably worth an RFE. -- Documentation Co-lead Dinna meddle wi' things ye ken nuthin' aboot! J.H. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
