https://bugs.documentfoundation.org/show_bug.cgi?id=86359
--- Comment #10 from Jan-Marek Glogowski <[email protected]> --- The origin of the problem is the replacement of fields with text strings during single document generation and the cell number formatting of the Writer table. While the field exists, it gets the formatting and displayed value from the Calc sheet / DB, independent from the Writer cell formatting. For a new table all cells are set to string and it's not changed, if you move a field from the DB source view into the cell. But if you have a different number format assigned to the cell, the default value is assigned to the cell, e.g. office:*-value="1899-12-30" for a date. This doesn't affect the formatting of the cell while it's a field. But when converting the the field to text during mail merge, the text becomes affected by the cell formation. In fact the text is ignored and the cell shows the invalid "office:*value", which is based on the default value when the field was added to the cell, based on the cell number formatting. Example XML from the merged document: <table:table-cell table:style-name="表�| �1.A2" office:value-type="float" office:value="0"> <text:p text:style-name="P3">98</text:p> </table:table-cell> Now my current idea to fix this confusion is to change the cell value to string when merging the field. As we already creating a "working source" copy, this can be done at the beginning of the merge. Loosing the Writer table cell formatting for the merged document should not be a problem (famous last words). -- 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
