[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Blocks|87761 |88174 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Blocks||88175 --- Comment #9 from Robinson Tryon (qubit) qu...@runcibility.com --- TESTING with Ubuntu 14.04 + LO 4.4.0.1 (Want to test with XLSX format as well) (In reply to Dave from comment #2) SCENARIO 2 * Start Libre Calc * Go to Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas - CHECK the box. Already checked I typed turtle in cell A1, and saved the file as ODS, XLS, and XLSX. Then I closed LibreOffice and opened the files one by one. * Go to Tools | Options | LibreOffice Calc | Calculate. NOTE: Enable Regular Expressions in formulas is CLEARED. Calc has failed to restore the previous user setting. RESULTS: - ODS: [x] Enable Regular Expressions in formulas - XLS: [ ] Enable Regular Expressions in formulas (as expected) - XLSX: [ ] Enable Regular Expressions in formulas (ALSO unchecked) Okay, so looks like this affects XLSX as well: Blocks - XLSX-limitations -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Dave davetyler...@gmail.com changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |NOTABUG --- Comment #8 from Dave davetyler...@gmail.com --- Although there is a warning on saving the document of This document may contain formatting or content that cannot be saved in the currently selected file format “Microsoft Excel 97/2000/XP/2003” as you said, I still think that the options need to be marks ODS File format only in the options. Therefore, suggestion: Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas needs a note below it: ODS Files only. It will save a lot of confusion support time for confused users. No user remembers switching on Enable Regular Expressions in formulas after working with a sheet for an hour+ and then relates that specific option to the warning message about Excel 97/2000/XP/2003 file formats. If you wish to close this bug, by all means. I leave this suggestion in your capable hands. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #7 from Robinson Tryon (qubit) qu...@runcibility.com --- (In reply to Beluga from comment #6) There is this warning by default: This document may contain formatting or content that cannot be saved in the currently selected file format “Microsoft Excel 97/2000/XP/2003”. Do you propose to add more information to this? status - NEEDINFO -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Robinson Tryon (qubit) qu...@runcibility.com changed: What|Removed |Added CC||qu...@runcibility.com Blocks||87761 -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Beluga todven...@suomi24.fi changed: What|Removed |Added CC||todven...@suomi24.fi Severity|normal |enhancement --- Comment #6 from Beluga todven...@suomi24.fi --- (In reply to Dave from comment #4) 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. There is this warning by default: This document may contain formatting or content that cannot be saved in the currently selected file format “Microsoft Excel 97/2000/XP/2003”. Do you propose to add more information to this? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 --- Comment #5 from John Rasor jmrasor...@gmail.com --- I can reproduce the behavior reported by Dave. Platform: Xubuntu 14.04 on 64-bit AMD homebuilt. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 --- Comment #4 from Dave davetyler...@gmail.com --- 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: AB 1 Data11 2 DataEnter22 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Dominique Boutry dominique.bout...@laposte.net changed: What|Removed |Added Status|NEEDINFO|UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from Dominique Boutry dominique.bout...@laposte.net --- OK, thank you. I reproduce the behaviour with LibO 4.2.1.1 on Win7. I understand that part of the options are global (as should be regular expression, you say), and that another part is carried by a document (as Date [origin] in the same Tab). What criteria to fall into one category or the other? I wonder whether some people may build Calc applications that build texts to be interpreted as regular expression, and would therefore prefer that the regular expression option be carry by their documents. Status put back to Unconfirmed to gather additionnal advices. -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 --- Comment #2 from Dave davetyler...@gmail.com --- Ok. 2 scenarios: SCENARIO 1 * Start Libre Calc * Go to Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas - CHECK the box. * Shutdown Calc. Do not save the Untitled spreadsheet. * Restart Calc. * Go to Tools | Options | LibreOffice Calc | Calculate. NOTE: Enable Regular Expressions in formulas is still CHECKED and Calc has remembered the user setting. SCENARIO 2 * Start Libre Calc * Go to Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas - CHECK the box. * Shutdown Calc. Do not save the Untitled spreadsheet. * Find a spreadsheet in Windows explorer. * Double click the spreadsheet to open it in the associated Libre Calc. (the spreadsheet does not have to contain use of regular expressions). * Go to Tools | Options | LibreOffice Calc | Calculate. NOTE: Enable Regular Expressions in formulas is CLEARED. Calc has failed to restore the previous user setting. SCENARIO 2 shows the bug. Does that make sense now? -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 75167] Tools | Options | LibreOffice Calc | Calculate | Enable Regular Expressions in formulas setting not saved
https://bugs.freedesktop.org/show_bug.cgi?id=75167 Dominique Boutry dominique.bout...@laposte.net changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #1 from Dominique Boutry dominique.bout...@laposte.net --- Hi. I can't understand your sentence ...is not saved between exiting the spreadsheet.. Could you please provide a step by step ? Thanks -- You are receiving this mail because: You are the assignee for the bug. ___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
