Difference between revisions of "About the dZMirror"
From dataZoa Wiki
| Line 1: | Line 1: | ||
<div class="imgGlyph24 imgConcept"></div> The <b><i>dZMirror</i></b> is an add-on for Microsoft Excel that links the cells of an Excel spreadsheet to the cells of a tabular dataZoa [[Displays|display]]. | <div class="imgGlyph24 imgConcept"></div> The <b><i>dZMirror</i></b> is an add-on for Microsoft Excel that links the cells of an Excel spreadsheet to the cells of a tabular dataZoa [[Displays|display]]. | ||
<onlyinclude> | <onlyinclude> | ||
| − | |||
| − | |||
<div style="margin-left: 2em;"> | <div style="margin-left: 2em;"> | ||
| Line 16: | Line 14: | ||
</div> | </div> | ||
<br> | <br> | ||
| + | |||
| + | <div class="imgGlyph24 imgIdea"></div> Rather than copying values in and out of spreadsheets, share the "mirror" link. No time-lag, no copying mistakes, no "version confusion". | ||
| + | |||
<div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | <div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | ||
</onlyinclude> | </onlyinclude> | ||
Revision as of 11:26, 17 February 2017
The dZMirror is an add-on for Microsoft Excel that links the cells of an Excel spreadsheet to the cells of a tabular dataZoa display.
When a dataZoa table is mirrored in a user's spreadsheet, each cell in the table becomes an actual cell in the spreadsheet. Because the all of the dataZoa cells update automatically, formulas in the spreadsheet update automatically as well.
The "dZMirror"
icon sits in the footer of tabular displays enabled for the display. Anyone viewing your display can use it download the add-in and mirror it into their own spreadsheet.
You can download the dZMirror add-in here.
If you allow a display to be posted publicly, be sure that related series are marked as public. When a private series is viewed outside its account, and its title shows as "Unavailable" its values show "NA."
