https://bugs.documentfoundation.org/show_bug.cgi?id=120749
Bug ID: 120749
Summary: Conditional Formatting CELLIS and BEGINSWITH not
working correctly (Xlsx)
Product: LibreOffice
Version: 6.1.0.3 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
This bug actually come from PHPSpreadsheet issue
https://github.com/PHPOffice/PhpSpreadsheet/issues/531#issuecomment-426942122
After i find some walkaround, i tried to open the file with LibreOffice Calc,
the condition formatting not working.
But when i tried to open the file with other apps (Google Sheet and WPS
Office), the conditional formatting works good.
Here's the file
https://www.dropbox.com/s/gkj18za4wi1p95b/Issue531PhpSpreadSheetFileTest.xlsx?dl=0
I tried to check some reference about XML format for office. It's seems this
xml sniplet should be the correct way to set conditional formatting with CELLIS
and BEGINSWITH :
<conditionalFormatting sqref="A1:Z1048576"><cfRule type="cellIs" dxfId="0"
priority="1"
operator="beginsWith"><formula>"-"</formula></cfRule></conditionalFormatting>
I tried to fix PHPSpreadSheet bug, and tried to generate that XML sniplet for
condition formatting.
Steps to Reproduce:
1. Generate file with conditional formatting CELLIS and BEGINSWITH rule
2. Open the file in Libre Office Calc
Actual Results:
Condition formatting CELLIS and BEGINSWITH not working correctly
Expected Results:
Condition formatting CELLIS and BEGINSWITH should works correctly
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
