https://bugs.documentfoundation.org/show_bug.cgi?id=154260
Bug ID: 154260
Summary: MAILMERGE loses space at the end of calculated field
when merging from xlsx, works fine from ods
Product: LibreOffice
Version: 7.5.1.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
Note: I encountered this in 7.5.2.1 but that isn't available as a choice in the
Version list.
1. Create a blank spreadsheet.
2. Put "c" in A1.
3. Put "=CONCAT(","," ")" in B1.
4. Save it in XLSX format.
5. Create and register a new database connected to the spreadsheet.
6. Create a new labels document, with a single synchronized label.
7. In the first label put "Before<c>After<nr>", where "<c>" is the "c" mail
merge field from the database and "<nr>" is the next record field from the same
database sheet.
8. Synchronize the labels.
9. Print to a mail merge file.
10. Open the resulting file.
11. Observe that it says "Before,After" instead of "Before, After", i.e., the
space that should be after the comma is missing.
If you repeat all of the above steps with an ODS file instead of an XLSX file
this problem does not occur.
Steps to Reproduce:
See above.
Actual Results:
See above.
Expected Results:
See above.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.5.2.1 (X86_64) / LibreOffice Community
Build ID: 50(Build:1)
CPU threads: 16; OS: Linux 6.1; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 4:7.5.2~rc1-0ubuntu1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
