Wordlayout Mini Sales Header - Alignment of Decimal Fields

gerdhuebner

I've encountered a strange thing, when looking at the standard Mini Sales Header Reports of NAV 2016 (reports 1304,...,1307, 1316). For example in the word layout of report 1304 "Mini Sales - Quote", the columns Quantity_Line, VATPct_Line, etc. all appear right aligned, when printed, but in the word layout itself, I cannot find, where or how this right alignment is defined. Quite the contrary, all controls, paragraphs, table columns, etc. for these fields seem to be left aligned...(!) - can anyone give me a hint, please!

gerdhuebner

In the meantime, I have found the reason. There is no automatic right alignment of decimal fields, but format is set within the Word template, though hidden. If you edit the Wordlayout of Report 1304, make a slight modification, save it again and reload it into NAV, the obscure right alignments are all gone and the columns are left aligned as it would be expected (though ugly). If you examine the OOXML code of the Wordlayout document.xml (for those of you, who are interested in Open Office XML), the w:jc element, which is responsable for the right alignment has been removed by Word, while saving the document.:

The supplied Wordlayout for the miniform reports may have been designed with another tool (except word) or another (older) version of Word.
In order to right align table cells containing plain text content controls, you should put a non-breaking space (Ctrl+Shift+Space) before the plain text control. Then any format supplied to the table cell's content will be retained upon saving and reopening.

nhsejth

Hi,
The w:jc element disappears when Word reads the document, not when it's saved. The templates you mention are saved with Word, Office 2013 or 2016. The alignment in the final report are based on the column type. If you have a table that includes data of type decimal (in the report dataset), we will automatically right align this column IF no alignment has been specified on the column. A missing w:jc element equivalents to left alignment (the default) and Word does not save default values to the documents.

gerdhuebner

In the meantime, I have found the reason. There is no automatic right alignment of decimal fields, but format is set within the Word template, though hidden. If you edit the Wordlayout of Report 1304, make a slight modification, save it again and reload it into NAV, the obscure right alignments are all gone and the columns are left aligned as it would be expected (though ugly). If you examine the OOXML code of the Wordlayout document.xml (for those of you, who are interested in Open Office XML), the w:jc element, which is responsable for the right alignment has been removed by Word, while saving the document.:

The supplied Wordlayout for the miniform reports may have been designed with another tool (except word) or another (older) version of Word.
In order to right align table cells containing plain text content controls, you should put a non-breaking space (Ctrl+Shift+Space) before the plain text control. Then any format supplied to the table cell's content will be retained upon saving and reopening.

nhsejth

Hi,
The w:jc element disappears when Word reads the document, not when it's saved. The templates you mention are saved with Word, Office 2013 or 2016. The alignment in the final report are based on the column type. If you have a table that includes data of type decimal (in the report dataset), we will automatically right align this column IF no alignment has been specified on the column. A missing w:jc element equivalents to left alignment (the default) and Word does not save default values to the documents.

gerdhuebner

@nhsejth
Thank you very much.
Is there any further documentation available about the DocumentReport AddIn and especially what all happens when the MergeWordDocument function is called in Codeunit 9651?

gerdhuebner

nhsejth wrote: »

Hi,
...If you have a table that includes data of type decimal (in the report dataset), we will automatically right align this column IF no alignment has been specified on the column...

Well, I tried this with a simple report layout and it does not work.

The Wordlayout consists of a repeated table row with 3 columns. There is no formatting. The last two columns are of type decimal:

Here is the result:

nhsejth

@gerdhuebner,
You are absolutely right, this is not always working in nav 2016. It was fixed in nav 2017, but the fix did not get backported, I have tested your setup in nav 2016 and 2017 and can confirm that its working fine in 2017 and fails in 2016. I will see if I can get this fix and a fix on image scaling backported to nav 2016 for the next CU.

The problem with the alignment was that the alignment property did not get inserted if the property element on the cells paragraph element was missing. Notice that the right alignment will only be active if no alignment has been defined for the cell, following the principle that the renderer should only override settings if they are not explicitly defined.

<w:p w:rsidR="001F1DFA" w:rsidP="00AC7DCE" w:rsidRDefault="001F1DFA">
  <w:pPr>
    <w:jc w:val="right" />
   </w:pPr>
    <w:r>
      <w:rPr>
        <w:lang w:val="da-DK" />
      </w:rPr>
      <w:t>5</w:t>
    </w:r>
 </w:p>

PS: Sorry for the long delay in feedback, but I don't follow mibuso forums on a regular basis due to time constraints.

sVerme

EDIT:

Cancel my question. ctrl + shift + space to retain the alignment