Converting text to numbers currently requires an extension: http://extensions.libreoffice.org/extension-center/ct2n-convert-text-to-number-and-dates
IMO this should be included in the core functions of LibreOffice - often times for new users they have no clue why Format -> Cell -> Number doesn't convert their stuff to numbers and it's because of the quarky addition of ' to the beginning of a cell that has certain text in it.
If an example is needed I will provide one but I think most devs/QA will know what I'm referencing - maybe this is wrong though :)
Added Joren for a 2nd opinion :)
As author I feel honoured of course :)
(And with lots and lots of experienced and patience, loving support, I could even to able to achieve it ;) )
:) Cor I had no clue this one was yours, I probably would have pinged you personally first.
Is it agreed that this is a valid request and can be marked as NEW?
(In reply to comment #3)
> :) Cor I had no clue this one was yours, I probably would have pinged you
> personally first.
No problem :)
> Is it agreed that this is a valid request and can be marked as NEW?
For me yes, but I leave it for others to judge ;)
(In reply to comment #4)
> > Is it agreed that this is a valid request and can be marked as NEW?
> For me yes, but I leave it for others to judge ;)
For me it is too ;-). Hupsa -> NEW :-)
Created attachment 80260 [details]
Example of Date That Cannot be Converted Without Extension
*** This bug has been marked as a duplicate of bug 33962 ***