Re: [libreoffice-users] How to remove user-defined format codes for numbers?
On Tue, 09 Jul 2013 07:38:57 -0400, chimak111 chimak...@gmail.com wrote: LibreOffice 4 Some of my spreadsheets have a ridiculous number of user-defined format codes (for numbers in Alt, Format, Cells, Category, Number). I think I created them when I was learning how to format numbers. Is there some elegant way I could remove all these user-defined format codes or do I have to delete them one by one? To remove all the codes from a sheet select the area or sheets you wish to reformat and use ctrl+m to clear the formating (FORMAT 'CLEAR DIRECT FORMATING'). -- Jay Lozier jsloz...@gmail.com -- 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] How to remove user-defined format codes for numbers?
Hi :) I think i might have misunderstood but just in case i didn't ... You know Ctrl A selects the entire work-sheet and you can then apply a single set of formats to the entire sheet? Regards from Tom :) From: chimak111 chimak...@gmail.com To: users@global.libreoffice.org Sent: Tuesday, 9 July 2013, 12:38 Subject: [libreoffice-users] How to remove user-defined format codes for numbers? LibreOffice 4 Some of my spreadsheets have a ridiculous number of user-defined format codes (for numbers in Alt, Format, Cells, Category, Number). I think I created them when I was learning how to format numbers. Is there some elegant way I could remove all these user-defined format codes or do I have to delete them one by one? -- View this message in context: http://nabble.documentfoundation.org/How-to-remove-user-defined-format-codes-for-numbers-tp4064664.html Sent from the Users mailing list archive at Nabble.com. -- 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