Re: [libreoffice-users] What happened to autoformat option?
At 18:21 30/05/2013 -0700, Girvin R. Herr wrote: ... Calc keeps changing the 1st character of a filename in a text cell to upper case. ... the autoformat option in the Format menu is grayed out no matter what I do. ... the autoformat option is the same - grayed out! No-one seems to have answered the question in your Subject header: What happened to autoformat option? The answer is that it is probably alive and well and fulfilling its proper purpose - which is to apply cell formats quickly to a table of cells. It makes no sense for a single cell: that is why it is greyed out. Since it seems to expect column and row headings as well as a line of totals in each direction, a minimum of a three-by-three cell range appears to be appropriate. If you select such a cell range, the AutoFormat menu item will leap into black and white. ... since I usually turn off all autoformatting. That would be AutoCorrection. I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] What happened to autoformat option?
Brian Barker wrote: At 18:21 30/05/2013 -0700, Girvin R. Herr wrote: ... Calc keeps changing the 1st character of a filename in a text cell to upper case. ... the autoformat option in the Format menu is grayed out no matter what I do. ... the autoformat option is the same - grayed out! No-one seems to have answered the question in your Subject header: What happened to autoformat option? The answer is that it is probably alive and well and fulfilling its proper purpose - which is to apply cell formats quickly to a table of cells. It makes no sense for a single cell: that is why it is greyed out. Since it seems to expect column and row headings as well as a line of totals in each direction, a minimum of a three-by-three cell range appears to be appropriate. If you select such a cell range, the AutoFormat menu item will leap into black and white. ... since I usually turn off all autoformatting. That would be AutoCorrection. Oops! My bad. For some reason, I wasn't seeing that option under Tools, and I looked more than once. My only excuse is that it was late in the day. Thanks, Brian. That resolved my problem. Girvin I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] What happened to autoformat option?
Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to upper case. If I go back and edit it back to lower case, it sticks. However, it is a pain to have to do this every entry and the autoformat option in the Format menu is grayed out no matter what I do. Anyone know the trick to get this option back so I can remove this aggravating formatting permanently? I just checked on my desktop and the autoformat option is the same - grayed out! That is going to be a big hindrance to me, since I usually turn off all autoformatting. Thanks in advance. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] What happened to autoformat option?
Hi. What about FormatAutocorrectAutocorrect optionsOptions. Untick capitalise first letter... On 31/05/13 1:21 PM, Girvin R. Herr wrote: Greetings, I upgraded to LO 3.6.6.2 and just installed it on my HP laptop. However, Calc keeps changing the 1st character of a filename in a text cell to upper case. If I go back and edit it back to lower case, it sticks. However, it is a pain to have to do this every entry and the autoformat option in the Format menu is grayed out no matter what I do. Anyone know the trick to get this option back so I can remove this aggravating formatting permanently? I just checked on my desktop and the autoformat option is the same - grayed out! That is going to be a big hindrance to me, since I usually turn off all autoformatting. Thanks in advance. Girvin Herr -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted