Re: [libreoffice-users] cells donât auto-wrap
At 14:11 06/04/2021 -0400, Eric Beversluis wrote: I've got a spreadsheet with all cells formatted to auto-wrap, yet when I enter stuff into certain cells, it doesn't autowrap. And sometimes the cell just shows the last bit of what I've entered. When I right-click and check the cell, it does show it's set to auto-wrap. I think the answer may be simple: that you have set the row height for the relevant cells to be insufficient to allow wrapping to happen. In this case, the last line of wrapped text is indeed what will appear in the cell. You need to tinker with row height to enable Calc to expand the row sufficiently to accept all your text. 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] Re: [libreoffice-users] cells don’t auto-wrap
It seems I want to set “Optimal Row Height” as the default. I thought that’s what I had and for some reason certain rows or certain cells weren’t following that setting. If I have the trouble again, I’ll check if the affected cell has a different row height setting for some reason. If so, it sounds like Girvin’s trick is the easy solution. Thanks. Eric Beversluis Short fiction at www.ericbeversluis.com On April 6, 2021 at 16:20:46, Girvin Herr (ghe...@fastmail.com) wrote: > > On 4/6/21 1:04 PM, Brian Barker wrote: > > At 14:11 06/04/2021 -0400, Eric Beversluis wrote: > >> I've got a spreadsheet with all cells formatted to auto-wrap, yet > >> when I enter stuff into certain cells, it doesn't autowrap. And > >> sometimes the cell just shows the last bit of what I've entered. When > >> I right-click and check the cell, it does show it's set to auto-wrap. > > > > I think the answer may be simple: that you have set the row height for > > the relevant cells to be insufficient to allow wrapping to happen. In > > this case, the last line of wrapped text is indeed what will appear in > > the cell. You need to tinker with row height to enable Calc to expand > > the row sufficiently to accept all your text. > > > > I trust this helps. > > > > Brian Barker > > > > > Double-click on the bottom line of the far left column (the row number > column, not column "A") of the row needing enlargement. If you are on > the line, the mouse pointer will change to the up-down arrow icon. Doing > so should increase the row height to accommodate the text. (It will also > decrease the row height if the text will allow it.) > > Girvin > > -- It seems I want to set “Optimal Row Height” as the default. I thought that’s what I had and for some reason certain rows or certain cells weren’t following that setting. If I have the trouble again, I’ll check if the affected cell has a different row height setting for some reason. If so, it sounds like Girvin’s trick is the easy solution. Thanks. Eric Beversluis Short fiction at www.ericbeversluis.com -- 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] Re: [libreoffice-users] cells don’t auto-wrap
On 4/6/21 1:04 PM, Brian Barker wrote: At 14:11 06/04/2021 -0400, Eric Beversluis wrote: I've got a spreadsheet with all cells formatted to auto-wrap, yet when I enter stuff into certain cells, it doesn't autowrap. And sometimes the cell just shows the last bit of what I've entered. When I right-click and check the cell, it does show it's set to auto-wrap. I think the answer may be simple: that you have set the row height for the relevant cells to be insufficient to allow wrapping to happen. In this case, the last line of wrapped text is indeed what will appear in the cell. You need to tinker with row height to enable Calc to expand the row sufficiently to accept all your text. I trust this helps. Brian Barker Double-click on the bottom line of the far left column (the row number column, not column "A") of the row needing enlargement. If you are on the line, the mouse pointer will change to the up-down arrow icon. Doing so should increase the row height to accommodate the text. (It will also decrease the row height if the text will allow it.) Girvin -- 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] cells don’t auto-wrap
Den tis 6 apr. 2021 kl 21:07 skrev Eric Beversluis < ebe...@researchintegration.org>: > I’ve got a spreadsheet with all cells formatted to auto-wrap, yet when I > enter stuff into certain cells, it doesn’t autowrap. And sometimes the cell > just shows the last bit of what I’ve entered. When I right-click and check > the cell, it does show it’s set to auto-wrap. > > Using LO 6.2.8.2 on Mac 10.12.6 > > Strange. Mine wraps as expected. LibreOffice 7.0.4, on Manjaro Linux 20.2.1. Maybe a bug in 6.2.8.2 that has been fixed now? Kind regards Johnny Rosenberg > THanks. > > Eric Beversluis > Short fiction at www.ericbeversluis.com > > > -- > 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] cells don’t auto-wrap
I’ve got a spreadsheet with all cells formatted to auto-wrap, yet when I enter stuff into certain cells, it doesn’t autowrap. And sometimes the cell just shows the last bit of what I’ve entered. When I right-click and check the cell, it does show it’s set to auto-wrap. Using LO 6.2.8.2 on Mac 10.12.6 THanks. Eric Beversluis Short fiction at www.ericbeversluis.com -- 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] days since beginning of year
You already have the answer, as you have used the YEAR function in your previous message. So YEAR(cell) will give you just the year from the date expressed in "cell". --- Gabriele Ponzo Il giorno lun 5 apr 2021 alle ore 03:46 James ha scritto: > How do I get the start date to be dynamically the current year? > > Apr. 4, 2021 19:30:53 cspi...@ieee.org: > > > I assume you're asking about how to get the days since the beginning of > the year given an existing date and that you're using LibreOffice Calc. > With this in mind, here is an example: > > > > =DATEDIF("2020-12-31","2021-01-27","d") > > > > The resulting value in the cell will be 27. > > > > The first parameter is the starting date. Middle parameter is the > current date in question (I used Jan 27th in my example). The third > parameter is the interval Calc should use, which is days here, hence "d". > Note that if you use 2020-01-01 as the start date, then the 27th day of > January would actually only be the 26th day since Jan 1st, so you need to > use a starting date of the last day of the prior year. > > > > Hope this helps! > > > > > > On Sun, Apr 4, 2021 at 3:59 PM James wrote: > >> How do I get the number of days since the beginning of year? > >> > >> > >> -- > >> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org[ > users%2bunsubscr...@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 > -- 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