Skip to main content
H
HelenaV
Member
July 7, 2026
Solved

Narrative reporting table formats in Word

  • July 7, 2026
  • 3 replies
  • 33 views

We are using v8.5 and inserting document variables into our Word document from a Named Range in a spreadsheet using the merge format option:

{DOCVARIABLE "{XF}{Application}{File}{Documents/Public/Extensible Documents/Performance Reporting/MPR.xfdoc.xlsx}""ExcelNamedRange=CapInvGrp"\* MERGEFORMAT}

The tables are formatted in Excel with column widths, shading, borders, numbers formats.

In the Word document, we apply styles to these tables to correct the row height and spacing. One style applies to the headers (left aligned) and another to the value cells (right aligned).

When an artefact is refreshed, the formats are maintained and shown correctly for all but the very last cell in every table, which reverts to the "Normal" style:

The number style is set up with the “Style for following paragraph” option as the same style.

Any idea why this happens and how we can correct it?  Alternatively, is there a better way to force the row spacing in the Word tables without losing it on refresh?

Best answer by RobbSalzmann

Hi Helena,

This looks like an indexing bug in the presentation logic (nothing you can control). As a workaround, try adding an empty row at the bottom of the report to take up the unformatted cell.

3 replies

RobbSalzmann
Advisor
RobbSalzmannAdvisorAnswer
Advisor
July 7, 2026

Hi Helena,

This looks like an indexing bug in the presentation logic (nothing you can control). As a workaround, try adding an empty row at the bottom of the report to take up the unformatted cell.

H
HelenaVAuthor
Member
July 8, 2026

Thank you, that works well. Just for my understanding: is an indexing bug something in the solution or in my particular document or environment?  I’m wondering if everyone has this issue and do the same thing, or if it’s something that may have been fixed in later versions.

RobbSalzmann
Advisor
RobbSalzmannAdvisor
Advisor
July 8, 2026

That’s the idea yes.  Think of it like this: if your grid has 64 cells, a loop has to iterate over the cells using an index that counts to decide which cell is being formatted by the current iteration.  Most loops index from 0, so it would count 0-63 (64 cells) and format each cell as it got to it.  If the dev forgot to add 1 to the index to correspond with cells numbered 1-64, then the last cell would always be skipped.

    Terms & ConditionsAccessibility statement