For me dealing with an extension, installing it, making sure it doesn't conflict with something else was more effort than creating a column, using Value() and then pasting special.
What's a problem is that in Excel even though it also uses the leading ' to format text as numbers, if you change the format of a cell the conversions happen without any problems. I want that same behavior in Calc because to me it makes sense that the cell format should be the controlling factor for what type of data is in a given cell. On Nov 10, 2013, at 7:43 PM, Joel Madero wrote: > Why is everyone straying away from the fact that there is a simple extension > developed by Cor (one of our brilliant devs) which accomplishes all of this? > Just curious if there's a benefit to doing these formula techniques instead > of just pushing a button on a nice gui Eugenie (Oogie) McGuire Desert Weyr http://www.desertweyr.com/ Paonia, CO USA -- 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