Page 1 of 1

Formatting in a merge document

PostPosted: Wed May 20, 2015 5:23 pm
by gkluther
I did do a search and could find nothing addressing my issue.
I have an invoice form that I use with merge and pull data from a spreadsheet. All well and good. In the document to help with formatting I merge some values into a table with white lines so the recipient doesn't see the table. This works well, also. My problem is that in the spreadsheet the numbers are formatted with decimals. in the merge document the numbers come out as integers. I went to Number Format in the table cells and have it setup as follows:
Decimal places: 2 Leading zeros:4. Yet, when I do the merge they display in the merged document as integers and not decimals. I am sure I am missing something really simple but I can't see it. Any suggestions/help would be greatly appreciated. Thank You.

Re: Formatting in a merge document

PostPosted: Tue Jun 02, 2015 4:52 pm
by Arineckaig
I have an invoice form that I use with merge and pull data from a spreadsheet.

There are several different ways by which Calc spreadsheet data can be 'merged' or 'pulled' into into a Writer document. It would be easier to offer suggestions if given some indication of the method used that is causing the problem.