Microsoft Office Tips and Tricks
A variety of tips and tricks in Microsoft Office products.
Today, a couple of quick troubleshooting tips for Excel templates. Problem One: My template is taking way too long to output. If your template is taking longer to generate than you anticipate, the cause may be that the size of the workbook is much larger than it needs to be in order to present your […] …read more
The DOCX spec has some pretty convoluted paths to determining the formatting of an object. But this one may be the ultimate in complexity. Take a look at paragraphs 3 & 4 in this document. How is this set? Well… First, look at document.xml and the entire paragraph xml. We can see the numPr element […] …read more
When you design a template in Word and generate the report in Word, the original text looks pretty much the same. But when a Word template is rendered to PDF output, two key things happen: Letters are spaced slightly further apart. Lines of text are usually spaced slightly further apart. This is at present an […] …read more
Editor’s note: This is part of our blog series on getting to know AutoTag better. Here’s another useful feature you may have overlooked. Did you know that AutoTag has a custom function that allows you to easily calculate a running total? What exactly do we mean by “running total,” you ask? Allow me to explain. […] …read more
Editor’s note: This is part of our blog series on getting to know AutoTag better. Here’s another useful feature you may have overlooked. AutoTag makes calculating sums in Microsoft® Word, using data from your data source, quick and easy with the Equation Editor’s SUM Function. Let’s say you have a report with a table showing […] …read more