https://bugs.freedesktop.org/show_bug.cgi?id=75167
--- Comment #4 from Dave <[email protected]> --- I think I have more information that pins down what is happening here. It is a difference between saving spreadsheets in Excel XLS format and ODS format: SCENARIO 3 - XLS vs ODS * Start Libre Calc * Go to Tools | Options | LibreOffice Calc | Calculate | "Enable Regular Expressions in formulas" - CHECK the box. * Enter the following data into cells: A B 1 Data1 1 2 DataEnter2 2 3 =VLOOKUP("DataE.*",A1:B2,2,0) * Save the spreadsheet "Untitled1.xls" - Excel format. * Open "Untitled1.xls" spreadsheet from Windows explorer. * Go to Tools | Options | LibreOffice Calc | Calculate. ************************************************* NOTE: "Enable Regular Expressions in formulas" is CLEARED. Calc has failed to restore the previous user setting. Cell A3 shows "#N/A" ************************************************* * With the XLS spreadsheet still open: Go to Tools | Options | LibreOffice Calc | Calculate | "Enable Regular Expressions in formulas" - CHECK the box. * Save the spreadsheet in ODS format. * Close the spreadsheet. * Open the spreadsheet again. * Go to Tools | Options | LibreOffice Calc | Calculate. ************************************************* NOTE: "Enable Regular Expressions in formulas" is CHECKED. Calc has stored the setting in the ODS format of file. Cell A3 shows correct result. ************************************************* ************************** * CONCLUSION ************************** Understandably, Calc does not save Regular Expression settings in a format of spreadsheet that is incompatible with Excel (Excel does not support Regular Expressions). If a user saves a spreadsheet into a XLS format, user must be warned that certain features are contained within the spreadsheet that will be lost as a result of using a different format. Options available in Tools | Options could clearly label or indicate which features are available: * as a GLOBAL setting * as a DOCUMENT setting * as an ODS DOCUMENT setting I realise this might be quite a bit of work but it may save the headaches of people like me using the software and getting what appear to be unpredictable results. Hope all that helps. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
