Sorry i thought i had replied to list but it seems i was mistaken. Ive got it sussed now, i have to *double click* in the cell and then *add a space* after the fraction before pressing ctrlZ (as the fraction was the only text in the cell, i didn't think to do either of these). Then it works just as i need it to. Thanks for your help.
G. -------------------------------------------- On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de> wrote: Subject: Re: [libreoffice-users] automatic fractions To: "Gary Collins" <gcatl...@yahoo.co.uk> Date: Monday, 30 October, 2017, 11:53 Hi Gary, please do not replay to a single person but to the mailing list. Gary Collins schrieb: > Thanks for reply. It doesnt seem to work ctrlZ in calc 5.2.2.2 ubuntu 16.10 returns to the cell where the fraction was entered but leaves it as a single character You have to use Ctrl+Z really _immediately_ after 1/2 was replaced by ½. If you have already written further characters or have exit edit mode, it will not work. Kind regards Regina > > G. > > -------------------------------------------- > On Mon, 30/10/17, Regina Henschel <rb.hensc...@t-online.de> wrote: > > Subject: Re: [libreoffice-users] automatic fractions > To: users@global.libreoffice.org > Date: Monday, 30 October, 2017, 11:30 > > Hi Gary, > > Gary > Collins schrieb: > > Hi > > Usually its a useful thing to have > fractions like 1/2 converted to a single character but > sometimes its better if the characters are kept separate, eg > if used along with other fractions that dont have a single > character representation, eg 5/7. > > > > Is it possible to cancel the conversion on > a one-off basis, ie without having to alter preferences, > conversion tables or whatever? > > Yes. Press Ctrl+Z immediately after the > conversion happens. > > Kind > regards > Regina > > > -- > 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 > > -- 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
