Description: When the attached spreadsheet is opened in LO one of the conditional formatting has lost its condition and when clicked on it it shows that there is no formatting and after that goes missing completely. Steps to Reproduce: 1. Open the attached spreadsheet in LO and MSO. 2. Go to the conditional formatting manager in both. 3. Check out the one which is missing its condition in LO. 4. Close the window then go back to the manager see that its now missing. Actual Results: Some of the conditional formatting is missing in LO. Expected Results: It should still be there even if opened in LO. Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 147538 [details] The original spreadsheet.
Created attachment 147539 [details] Screenshot of the original document side by side in Excel and Calc.
confirm in Version: 6.3.0.0.alpha0+ Build ID: 3c964980da07892a02d5ac721d80558c459532d0 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45 Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded conditions for range C57:D61 dissapeare in LO
Also reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.15; Render: default; Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
*** Bug 122101 has been marked as a duplicate of this bug. ***
*** Bug 122105 has been marked as a duplicate of this bug. ***
Created attachment 152828 [details] Screenshot of a simplified example in Excel and Calc If the condition is not given as a fixed string in Excel then importing the rule fails when using "Given text" type and cell reference inside the same file. Version: 6.4.0.0.alpha0+ (x86) Build ID: 49422a469646ad8be43ba828ca24c2484c26b9e8 CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-07-08_00:50:19 Locale: hu-HU (hu_HU); UI-Language: en-US Calc: CL
Created attachment 152829 [details] Simplified example file from Excel
Tibor Nagy committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0101975f8eac650bb87c4af81157cb33a6309e0e tdf#122102 XLSX import: fix "contains" conditional formatting It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Nice fix! Verified in Version: 7.2.0.0.alpha0+ Build ID: 4484accf4d331a95ebf8475d6cd91950f4c27bcc CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Tibor Nagy, thanks for fixing this issue!!
Tibor Nagy committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/4bca4f507c064c18880bd8283aaba567865d2462 tdf#122102 XLSX import: fix "contains" conditional formatting It will be available in 7.1.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.2.0.0.alpha0+ (x64) Build ID: 96bafa464ebdbce3ef04bec9beae5e745bb37794 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded Thanks for fixing!