Welcome to the Mythicsoft Q&A site for:

- Agent Ransack
- FileLocator Lite
- FileLocator Pro

Please feel free to ask any questions on these products or even answer other community member questions.

Useful Links:

- Contact Us
- Help Manuals
- Mythicsoft Home
0 votes

Using FLP V 8.5 (Bld 2889) : (Libreoffice (x64))

I am using FLP to traverse n directories looking at LibreOffice spreadsheets - ods files.

Source .ods files data have £ prefix to data but when parsed, the hits data (and consequently exported data) has $ as the currency symbol. While this isn't a showstopper, it is a bit of a pain having to reformat the data every time.

I have browsed the forums but not seen any reference to this.
Any advice much appreciated!


by (30 points)

1 Answer

0 votes

After looking at the source data (an .ODS file converted from an old .XLS file from Office 2003) it looks like there was a problem with the conversion. If you open the .ODS file with Excel 2016 it shows '$' symbols.

The underlying styles data (styles.xml) and the data in the spreadsheet (content.xml) are not consistent. The content refers to a style that isn't included in the styles data and all the styles in the styles data use the $ symbol.

Since the FileLocator Pro conversion agrees with a modern version of Excel I'm not sure there's much that can be done.

by (72.9k points)