Description: If I insert a sheet from file there is a check box to 'Detect special numbers'. This works where I have numbers with a currency symbol and the imported sheet has these columns as currency. However, if I have forgetten to check the box there is no option available to convert text with currency symbols to currency. Steps to Reproduce: 1. Insert a sheet from file containing numbers with a currency symbol without checking the 'Detect special numbers' box Actual Results: There is no function to convert text with a currency symbol to currency type Expected Results: There should be a conversion function Reproducible: Always User Profile Reset: No Additional Info: This probably also applies to dates in text
See this FAQ https://wiki.documentfoundation.org/Faq/Calc/How_to_convert_number_text_to_numeric_data Also note the conversion extension mentioned https://extensions.libreoffice.org/extensions/ct2n-convert-text-to-number-and-dates Not a bug.