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] Fw: Potential bug printing blank Writer tables
Ok, is printing a hard copy necessary or is generating a PDF file sufficient? I created a table, in Writer, with 10 columns and 20 rows. I edited the first cell in each row and pressed "Enter" to double the height of the row. When I reached row 20, I saw I had space at the bottom of the page so I added another row and updated the first cell by pressing "Enter". When I generated a print preview, nothing appeared on the page! Then, I realized I had to enable borders. :) After doing that, the print preview showed a grid on the page. I then generated a PDF file and the grid was preserved and looked good. This is using Writer 7.5.2.2 on Manjaro (22, I think...the latest version) KDE Linux. I don't have a printer connected to this system and the system with a printer attached has Writer 7.3.7 installed. If you're interested in seeing the document and PDF file I generated, I can send both to you privately. I didn't enter any text of any kind, just added the table. Peace... Tom W On 5/5/23 12:36 PM, dboland9 wrote: The version is 7.5.2. Normally, when I post a question, get a copy of my post. That did not happen, so I assumed something went wrong. Dave, Sent with Proton Mail secure email. --- Original Message --- On Friday, May 5th, 2023 at 2:37 PM, Tom wrote: Your first message was received. I guess no one responded yet. :) Which version of Writer are you using? Peace... Tom W On 5/5/23 11:33 AM, dboland9 wrote: Resending because it does not seem to have reached the mail group. Dave, Sent with Proton Mail secure email. --- Forwarded Message --- From: dboland9 dbola...@protonmail.com Date: On Friday, May 5th, 2023 at 8:07 AM Subject: Potential bug printing blank Writer tables To: Users users@global.libreoffice.org A form was created using Writer tables, double spaced. Printing of the borders was very inconsistent - some too light to even see, a few ok, with most in between. Could I ask others to create a page in Writer with a table covering most of the page. Hit the Enter key twice in each line, then print it. Tables printed with content in them seem to work fine. Dave, Sent with Proton Mail secure email. -- 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
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] Fw: Potential bug printing blank Writer tables
Ok, fair enough. :) I might have a copy of 7.5.2 available. If so, I'll give it a shot. :) Peace... Tom W On 5/5/23 12:36 PM, dboland9 wrote: The version is 7.5.2. Normally, when I post a question, get a copy of my post. That did not happen, so I assumed something went wrong. Dave, Sent with Proton Mail secure email. --- Original Message --- On Friday, May 5th, 2023 at 2:37 PM, Tom wrote: Your first message was received. I guess no one responded yet. :) Which version of Writer are you using? Peace... Tom W On 5/5/23 11:33 AM, dboland9 wrote: Resending because it does not seem to have reached the mail group. Dave, Sent with Proton Mail secure email. --- Forwarded Message --- From: dboland9 dbola...@protonmail.com Date: On Friday, May 5th, 2023 at 8:07 AM Subject: Potential bug printing blank Writer tables To: Users users@global.libreoffice.org A form was created using Writer tables, double spaced. Printing of the borders was very inconsistent - some too light to even see, a few ok, with most in between. Could I ask others to create a page in Writer with a table covering most of the page. Hit the Enter key twice in each line, then print it. Tables printed with content in them seem to work fine. Dave, Sent with Proton Mail secure email. -- 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
Re: [libreoffice-users] Fw: Potential bug printing blank Writer tables
On Fri, 05 May 2023 19:36:40 + dboland9 wrote: > The version is 7.5.2. > > Normally, when I post a question, get a copy of my post. That did > not happen, so I assumed something went wrong. > > Dave, Instead of assuming, it's usually best to check whether your posting is in the archives, as listed in every email: List archive: https://listarchives.libreoffice.org/global/users/ -- 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
Re: [libreoffice-users] Fw: Potential bug printing blank Writer tables
The version is 7.5.2. Normally, when I post a question, get a copy of my post. That did not happen, so I assumed something went wrong. Dave, Sent with Proton Mail secure email. --- Original Message --- On Friday, May 5th, 2023 at 2:37 PM, Tom wrote: > Your first message was received. I guess no one responded yet. :) > Which version of Writer are you using? > > Peace... > > Tom W > > On 5/5/23 11:33 AM, dboland9 wrote: > > > Resending because it does not seem to have reached the mail group. > > > > Dave, > > > > Sent with Proton Mail secure email. > > > > --- Forwarded Message --- > > From: dboland9 dbola...@protonmail.com > > Date: On Friday, May 5th, 2023 at 8:07 AM > > Subject: Potential bug printing blank Writer tables > > To: Users users@global.libreoffice.org > > > > > A form was created using Writer tables, double spaced. Printing of the > > > borders was very inconsistent - some too light to even see, a few ok, > > > with most in between. Could I ask others to create a page in Writer with > > > a table covering most of the page. Hit the Enter key twice in each line, > > > then print it. > > > > > > Tables printed with content in them seem to work fine. > > > > > > Dave, > > > > > > Sent with Proton Mail secure email. > > > -- > 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
Re: [libreoffice-users] Fw: Potential bug printing blank Writer tables
Your first message was received. I guess no one responded yet. :) Which version of Writer are you using? Peace... Tom W On 5/5/23 11:33 AM, dboland9 wrote: Resending because it does not seem to have reached the mail group. Dave, Sent with [Proton Mail](https://proton.me/) secure email. --- Forwarded Message --- From: dboland9 Date: On Friday, May 5th, 2023 at 8:07 AM Subject: Potential bug printing blank Writer tables To: Users A form was created using Writer tables, double spaced. Printing of the borders was very inconsistent - some too light to even see, a few ok, with most in between. Could I ask others to create a page in Writer with a table covering most of the page. Hit the Enter key twice in each line, then print it. Tables printed with content in them seem to work fine. Dave, Sent with [Proton Mail](https://proton.me/) secure email. -- 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] Fw: Potential bug printing blank Writer tables
Resending because it does not seem to have reached the mail group. Dave, Sent with [Proton Mail](https://proton.me/) secure email. --- Forwarded Message --- From: dboland9 Date: On Friday, May 5th, 2023 at 8:07 AM Subject: Potential bug printing blank Writer tables To: Users > A form was created using Writer tables, double spaced. Printing of the > borders was very inconsistent - some too light to even see, a few ok, with > most in between. Could I ask others to create a page in Writer with a table > covering most of the page. Hit the Enter key twice in each line, then print > it. > > Tables printed with content in them seem to work fine. > > Dave, > > Sent with [Proton Mail](https://proton.me/) secure email. -- 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] Recovered File Issues - Blank Document
I suspect the reason that Options is not in the Tools menu is because the original poster is using a Mac. The Mac version of LibreOffice has its options in Preferences in the "LibreOffice" menu. Chuck (LibreOffice 7.4.6.2, Mac OS 10.13.6) On Fri, May 5, 2023 at 8:27 AM Peter Hillier-Brook wrote: > On 03/05/2023 09:29, Katinka Van Dijk wrote: > > Hello, > > > > Libre Office crashed and when restarted it asked if I wanted to recover > the file I was working on and as this has worked in the past I agreed. When > the document was recovered it was blank. > > > > Looking through your forum to possibly find an older version a few say > to go Tools: Options etc.. my tools tab does not have an Options, the kast > thing is Customize. Should it? > > Yes it should, immediately below 'Customise' (Using version 7.5.3.2, > freshly installed). Perhaps you need to scroll your screen? I'm not sure > that this will help you with your current problem though. > > Please don't take this the wrong way but, many years ago - about 35 if > memory serves - I learned the hard way to save important documents every > 10 minutes to minimise potential losses. This started, of course, before > I discovered a more reliable operating system that didn't crash every so > often:-) > > Peter HB > [snip] -- 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] Recovered File Issues - Blank Document
On Fri, 5 May 2023 at 10:29, Peter Hillier-Brook wrote: > Please don't take this the wrong way but, many years ago - about 35 if > memory serves - I learned the hard way to save important documents every > 10 minutes to minimise potential losses. Ah yes. Same experience here. Experience is a hard teacher, but a very effective teacher! -- T. R. Valentine A rich heart may be under a poor coat. -- 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] Recovered File Issues - Blank Document
On 03/05/2023 09:29, Katinka Van Dijk wrote: Hello, Libre Office crashed and when restarted it asked if I wanted to recover the file I was working on and as this has worked in the past I agreed. When the document was recovered it was blank. Looking through your forum to possibly find an older version a few say to go Tools: Options etc.. my tools tab does not have an Options, the kast thing is Customize. Should it? Yes it should, immediately below 'Customise' (Using version 7.5.3.2, freshly installed). Perhaps you need to scroll your screen? I'm not sure that this will help you with your current problem though. Please don't take this the wrong way but, many years ago - about 35 if memory serves - I learned the hard way to save important documents every 10 minutes to minimise potential losses. This started, of course, before I discovered a more reliable operating system that didn't crash every so often:-) Peter HB -- 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] Potential bug printing blank Writer tables
A form was created using Writer tables, double spaced. Printing of the borders was very inconsistent - some too light to even see, a few ok, with most in between. Could I ask others to create a page in Writer with a table covering most of the page. Hit the Enter key twice in each line, then print it. Tables printed with content in them seem to work fine. Dave, Sent with [Proton Mail](https://proton.me/) secure email. -- 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
