Re: [PLUG] LO Calc: text formatting question
On Fri, 5 Jan 2018, Tomas Kuchta wrote: You seems to have selected whole column past the cells wit numbers. So this may be the max row number possible. Tomas, Ah, that may well be the reason. Try to select just the cells with values and repeat the formatting. Use Ctrl+Shift+Arrow to select filled cells. Will do so. Thanks, Rich ___ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
Re: [PLUG] LO Calc: text formatting question
You seems to have selected whole column past the cells wit numbers. So this may be the max row number possible. Try to select just the cells with values and repeat the formatting. Use Ctrl+Shift+Arrow to select filled cells. Tomas On Jan 4, 2018 3:15 PM, "Rich Shepard" wrote: > For those of you who use LibreOffice Calc. > > I have a .csv file which wc reports having 5003 lines and Calc shows 5001 > lines. I don't mind the discrepancy of two lines. But, when I select a > column and invoke Format -> Text -> Cycle case (to capitalize the first > letter of each word)) the status bar on the bottom shows 1,048,513 rows and > 1 column selected. Then the application hangs. > > Where might Calc find 1048513 rows when the bottom row is at line 5001? > > Rich > ___ > PLUG mailing list > PLUG@pdxlinux.org > http://lists.pdxlinux.org/mailman/listinfo/plug > ___ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
[PLUG] LO Calc: text formatting question
For those of you who use LibreOffice Calc. I have a .csv file which wc reports having 5003 lines and Calc shows 5001 lines. I don't mind the discrepancy of two lines. But, when I select a column and invoke Format -> Text -> Cycle case (to capitalize the first letter of each word)) the status bar on the bottom shows 1,048,513 rows and 1 column selected. Then the application hangs. Where might Calc find 1048513 rows when the bottom row is at line 5001? Rich ___ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug