Greetings,
I am creating a template to use as a job estimate form. I have a table created inside of a Writer document. Is there a way to hide the value of a cell that is used in a formula from being printed?
What I am trying to achieve is a tax rate total using a product formula. I live in a city that borders 3 states and I will need different tax rates depending on the location for the estimate. This percentage rate does not need to be printed, but I will need to be able to edit the number.
Just a tip:
.
Use a custom character style for the Tax value, and modify the Font color of the Style to white for the printing. You can do it by a macro too.
.
Please upload an ODF type sample file here.
Suggestion #1: use Calc for your computations as it is more powerful and versatile than the over-simplified primarily text-oriented Writer tables (where each cell is mainly a text sub-document). Insert the Calc sheet inside your Writer document.
Suggestion #2: writer has special fields Hidden Text and Hidden Paragraphs which can hide the controlled data depending on a variable value, in your case a code for the state.
PS: when asking here, always mention OS name, LO version and save format. The importance of the latter is illustrated by the fact that suggestion #2 works only in .odt because there is no equivalent feature in DOCX.
You may instead use a frame, which has a [ ] Print checkbox it its properties:
Unchecking it makes your frame not appear on printing, but still visible on screen. Everything you put there, including fields like Set variable, would be easily editable. If you have such a Set variable field, then all the table formulas (and formula fields), that go after the frame’s anchor point, would be able to use the variable name in the calculations.
