formula/inc/core_resource.hrc |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

New commits:
commit 88cf867bf80475c9e3f04a09c938608d1cd1f0bd
Author:     Karthik Godha <[email protected]>
AuthorDate: Mon Feb 2 07:37:16 2026 +0530
Commit:     Balazs Varga <[email protected]>
CommitDate: Thu Feb 5 15:23:45 2026 +0100

    XLSX: Use ',' as Union operator
    
    Excel uses ',' insteal of `~` as union operator
    
    support page: 
https://support.microsoft.com/en-us/office/using-calculation-operators-in-excel-formulas-78be92ad-563c-4d62-b081-ae6da5c2ca69
    
    bug-document: forum-mso-de-50772.xls
    Change-Id: I0dcf563d0a75dd4e3f5a573519eeb9ace525bc14
    Reviewed-on: https://gerrit.libreoffice.org/c/core/+/198510
    Reviewed-by: Balazs Varga <[email protected]>
    Tested-by: Jenkins CollaboraOffice <[email protected]>

diff --git a/formula/inc/core_resource.hrc b/formula/inc/core_resource.hrc
index 6c8902608cad..9deadc5a2d90 100644
--- a/formula/inc/core_resource.hrc
+++ b/formula/inc/core_resource.hrc
@@ -534,7 +534,7 @@ const std::pair<const char *, int> 
RID_STRLIST_FUNCTION_NAMES_ENGLISH_OOXML[] =
     { "OR" , SC_OPCODE_OR },
     { "_xlfn.XOR" , SC_OPCODE_XOR },
     { " " , SC_OPCODE_INTERSECT },
-    { "~" , SC_OPCODE_UNION },
+    { "," , SC_OPCODE_UNION },  // Excel uses ',' as Union operator
     { ":" , SC_OPCODE_RANGE },
     { "NOT" , SC_OPCODE_NOT },
     { "NEG" , SC_OPCODE_NEG },

Reply via email to