|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Word table formula with SEQ operators not working properly on one computer but fine on others
I'm trying to resolve an issue for a customer with a document that uses SEQ formula operators.
I've created an invoice document template and the table uses some SEQ formula operators to calculate the invoice total, amongst some other things, but the template doesn't work correctly on my clients machine. When the fields are updated using F9, the dollar symbols are repeated and decimal places are introduced even when these are zero. To be clear, the template works correctly on my computer. It also works correctly on my client's colleagues computer too. I'm confused as to what the problem is. We're both using Windows 11 and we're both using the latest version of Microsoft Office 365 but there must be something different between the two installations? Here's some things I've already tried to resolve the problem:
Does anyone have any suggestions? Here's what formula code I'm using in one of the cells. I'm not an expert in these SEQ operators but I built this based off some other formulas I found on StackExchange, basically it multiplies three cells together to create a total for the row, it works relatively so the same code can be used in all total cells and it won't break if other rows above or below are deleted. Code:
${ =({ QUOTE "D{ =1+{ SEQ row \* Arabic } \* Arabic }" }*{ QUOTE “E{ =1+{ SEQ row \c \* Arabic } \* Arabic }" }*{ QUOTE “F{ =1+{ SEQ row \c \* Arabic}\* Arabic }" }) } |
Tags |
microsoft word, seq, table formula |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
ms word and outlook have stopped working but publisher and excel appear to be fine. | Manny | Word | 4 | 10-21-2018 01:34 PM |
Word 2016 Spell Checker not working properly | Ryuuzaki88 | Word | 6 | 05-13-2018 03:28 PM |
Hyperlinks not working properly in Word 2013 to PDF conversion | Kayjay | Word | 0 | 02-25-2016 04:21 AM |
Accent symbols not working properly on new computer | Binary.tobis | Excel | 3 | 04-28-2012 04:49 PM |
Word 2000 Macro not working properly | brianlb | Word VBA | 1 | 07-01-2009 07:04 AM |