https://bugs.documentfoundation.org/show_bug.cgi?id=170429
Bug ID: 170429
Summary: Writer mail merge outputs instead of text when using
Calc cells with Spanish macro functions (e.g. ).
Product: LibreOffice
Version: 25.2.7.2 release
Hardware: x86 (IA32)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Title: Writer mail merge shows instead of text when Calc cells use Spanish
macro functions
Environment:
• LibreOffice (Spanish language version)
• Operating system: [insert your OS, e.g. Windows 10 / Linux distro]
• Calc document with custom macro function (Spanish localized function
names)
Description:
When using LibreOffice in Spanish, we rely on localized functions such as in
Calc to convert numeric values into text strings (e.g., “Ciento veinte pesos
00/100 M.N.”). The function works correctly inside Calc: the cell displays the
expected text.
However, when this column is used as a field in Writer’s mail merge, the output
is always . Writer does not display the text string, even though Calc shows it
correctly.
Steps to Reproduce:
1. In Calc (Spanish version), create a column with the formula:
=NUMEROS_LETRAS(AB11;"peso";0;"centavos";"";"/100 M.N.";1)
2. Confirm that Calc displays the correct text string in the cell.
3. Use this column as a field in Writer mail merge.
4. Run the merge.
Actual Result:
Writer outputs instead of the text string.
Expected Result:
Writer should display the same text string that Calc shows in the cell.
Workarounds Tried:
• Copying values manually into another column (works, but breaks
automation).
• Formatting the target column as text before inserting formulas.
• Using , , to force text conversion.
• Registering the Calc sheet as a Base data source.
• Writing a macro to copy values into a “plain text” column before merge.
All of these are partial or manual workarounds. None provide a clean automated
solution.
Impact:
This prevents automated mail merge workflows when using localized macro
functions in Calc. It forces manual intervention or custom macros, reducing
reliability and usability.
Suggestion:
Writer should correctly interpret and display the visible string values from
Calc cells, even when they are generated by localized macro functions. At
minimum, documentation should clarify how to ensure macro outputs are exported
as text for mail merge.
--
You are receiving this mail because:
You are the assignee for the bug.
