Change capitalization

Post Reply
lgsl
Posts: 345
Joined: Wed Mar 04, 2020 8:00 pm

Change capitalization

Post by lgsl »

I have a spreadsheet that have several cells with text in lowercase. I need to change it change the capitalization of such rows. There is no option in the ribbon (by default) or the classical menu to achieve this. I did noticed, however, that is possible to add the capitalization commands into the ribbon, the problem is that they do not work. According to the manual, Shift+F3 should allow me to change from lowercase to uppercase, but doesn't work either.

Using PROPER (what I need), UPPER and LOWER, works, but I can't just simply go and manually add =PROPPER("string") to every cell. Is not practical.

I do not know if the capitalization commands not working this is a bug or if this commands shouldn't be available on the customize ribbon interface. However Shift+F3 not working, as the manual appendix states one can use to switch between lowercase and uppercase points to a problem here. Switching the type of the cell from default to text does not help either.

Furthermore: An option to change capitalization between lowercase, uppercase and first letter of each word is a feature already available in every other spreadsheet application I have come across. If this functionality is not available, then I would like to request for it to be added in the near future.
Post Reply

Return to “PlanMaker for Linux”