Page 1 of 1

Decimal Pointer in Mail Merge

Posted: Tue Dec 15, 2020 11:12 pm
by jwn
Hello,

I'm using the current Docker image of the document server (6.1). I'm trying to create invoices with mail merge, using a spreadsheet as a data source. I'm having difficulties with the data format however. Numeric values saved in the Accounting-format lose their decimal point. So "796,23 €" becomes "796231566798419" in the recipient list. Am I missing something or is this a bug?

Thanks for the great software! I'm considering buying the Home Server license, as I'm starting to use Onlyoffice productively.

Re: Decimal Pointer in Mail Merge

Posted: Thu Dec 17, 2020 1:02 pm
by Serge
Hello,

Please provide the following information:
  • Which platform is the Document Server integrated into?
  • What are your regional settings for the source spreadsheet?
  • Do you add values in the spreadsheet or the text document?
Could you also describe your actions step by step?

Re: Decimal Pointer in Mail Merge

Posted: Fri Dec 18, 2020 5:03 pm
by jwn
Serge wrote:
Thu Dec 17, 2020 1:02 pm
  • Which platform is the Document Server integrated into?
I'm using the Documentserver with Nextcloud.
Serge wrote:
Thu Dec 17, 2020 1:02 pm
  • What are your regional settings for the source spreadsheet?
German. So 1.000,01 for numerical values.
  • Do you add values in the spreadsheet or the text document?
Could you also describe your actions step by step?
[/quote]

I have a spreadsheet with several sheets. The first sheet contains the raw data without any formulas, that I manually copy over from the other sheets. I paste it with "Values + all formatting". I save that file and open the template for my letter in the Document Editor. I click on Mail merge and select my spreadsheet. When I open the editor for the recipient list, I can see the first sheet of the document, but there's no decimal pointer and in general, all formatting is lost. Dates are shown as numerical values, for example. That can be fixed by choosing the correct format. But fields with the original format Accounting can't be fixed. The original value would be "1378,79330592885" and formatted as "1378,79 €" becomes "13787933059288500".

Now, for some reason, my original spreadsheet is rejected with an error message when I now click on Mail merge. However, copying the data to an empty spreadsheet with a single sheet and no other data and using that leads to the same problem as stated in the above paragraph.

I have to admit that I've never tried to insert a merge field and check it's preview. Apparently, in the preview the decimal point is back! However it's still not correctly formatted ("1378,79330592885").