Re: [libreoffice-users] does this work for you?
At 16:44 05/05/2023 -0400, James Lockie wrote: That explains my test spreadsheet and I fixed that in the test and it works. Incidentally, one easy way to spot that what you have is text and not a proper date is that by default text is left-justified - as in your original test file. True dates (just like numbers, which is what they really are) are by default right-justified in the cell. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
That was it but it happened because I copied a file with 2023 dates to a new file and then replaced 2023 with 2024 (replace all, selection only) and it loses the formatting (resets to the formatting in A1) in W1. On 2023-05-05 17:12, Brad Rogers wrote: On Fri, 5 May 2023 17:09:37 -0400 (EDT) James wrote: Hello James, be the date in the first cell but only display the month. Currently, the formatting clones cell A2; You need to change it. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
On Fri, 5 May 2023 17:09:37 -0400 (EDT) James wrote: Hello James, >be the date in the first cell but only display the month. Currently, the formatting clones cell A2; You need to change it. -- Regards _ "Valid sig separator is {dash}{dash}{space}" / ) "The blindingly obvious is never immediately apparent" / _)rad "Is it only me that has a working delete key?" I ain't got no time for intellectual music, e.g. Hergest Ridge Heads Down No Nonsense Mindless Boogie - Alberto y Lost Trios Paranoias -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
I want the date in the first cell to display as day month year but the sec cell be the date in the first cell but only display the month. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
On Fri, 5 May 2023 16:44:49 -0400 James wrote: Hello James, >My original doesn't work and is definitely a date. Because you've got the formatting wrong in the second cell. -- Regards _ "Valid sig separator is {dash}{dash}{space}" / ) "The blindingly obvious is never immediately apparent" / _)rad "Is it only me that has a working delete key?" I'm sure she stole all of my pencil lead in school Golden Green - Wonder Stuff -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
That explains my test spreadsheet and I fixed that in the test and it works. My original doesn't work and is definitely a date. I deleted mostly everything from the original and uploaded it (same file name). https://www.mediafire.com/file/19yqomh4pp67cy7/2023-05-05-test-ods.ods/file On 2023-05-05 16:14, Brian Barker wrote: At 15:41 05/05/2023 -0400, James Lockie wrote: Does this work for you? The A1 cell contains a date with a date format (NN, MMM D, ) that displays the weekday month day year. The B1 cell contains a reference to the A1 cell but has a date format () that is only supposed to display the month. I uploaded a sample file ... Although you have your cells formatted as you suggest, what you have in A1 is actually a text string and not a date. When this is referenced in B1, that also will contain the same text string. Since you have no dates, your formats are ignored. In order for your typing (in A1) to be interpreted as a date, it needs to be something that LibreOffice will interpret as a date. In that case, the string you type will be converted to a date in the cell, and this will be displayed according to the cell format. It is not necessary to enter such a date in the format you wish to see; indeed, in this case, you must not, since that is not one of the formats that LibreOffice will recognise. Just re-enter the date in A1 in such a format (e.g. 1/3/24 in your locale) and everything will spring to life as you wish. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
At 15:41 05/05/2023 -0400, James Lockie wrote: Does this work for you? The A1 cell contains a date with a date format (NN, MMM D, ) that displays the weekday month day year. The B1 cell contains a reference to the A1 cell but has a date format () that is only supposed to display the month. I uploaded a sample file ... Although you have your cells formatted as you suggest, what you have in A1 is actually a text string and not a date. When this is referenced in B1, that also will contain the same text string. Since you have no dates, your formats are ignored. In order for your typing (in A1) to be interpreted as a date, it needs to be something that LibreOffice will interpret as a date. In that case, the string you type will be converted to a date in the cell, and this will be displayed according to the cell format. It is not necessary to enter such a date in the format you wish to see; indeed, in this case, you must not, since that is not one of the formats that LibreOffice will recognise. Just re-enter the date in A1 in such a format (e.g. 1/3/24 in your locale) and everything will spring to life as you wish. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
Re: [libreoffice-users] does this work for you?
Den fre 5 maj 2023 kl 21:49 skrev James : > Does this work for you? > Yes, I believe it does. > > The A1 cell contains a date with a date format (NN, MMM D, ) that > displays the weekday month day year.. > fr, maj 5, 2023 > The B1 cell contains a reference to the A1 cell but has a date format > () that is only supposed to display the month. > maj Yes, it looks right (my locale is Swedish – Sweden). LibreOffice 7.4.6.2 Kind regards Johnny Rosenberg > > I uploaded a sample file to: > https://www.mediafire.com/file/mjky6h3uvmvvqhn/2023-05-05-test-ods.ods/file > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
[libreoffice-users] does this work for you?
Does this work for you? The A1 cell contains a date with a date format (NN, MMM D, ) that displays the weekday month day year.. The B1 cell contains a reference to the A1 cell but has a date format () that is only supposed to display the month. I uploaded a sample file to: https://www.mediafire.com/file/mjky6h3uvmvvqhn/2023-05-05-test-ods.ods/file -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy