Difference between revisions of "About the dZMirror"
From dataZoa Wiki
| Line 3: | Line 3: | ||
<div style="margin-left: 2em;"> | <div style="margin-left: 2em;"> | ||
| + | <div> | ||
| + | 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 [[Automatic Updates|update automatically]], formulas in the spreadsheet update automatically as well. | ||
| + | </div> | ||
<div> | <div> | ||
The "dZMirror" <div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/EMCT-Mirror-Dark.png', title: 'dZMirror icon', xtraStyle: ' min-height: 16px; min-width: 16px;' }"></div></div> icon sits in the footer of tabular [[Displays|displays]] enabled for the display. Anyone viewing your display can use it download the add-in and mirror it into their own spreadsheet. | The "dZMirror" <div class="imgWholeWrap1"><div class="imgWhole " data-guts="{ url: '/img/EMCT-Mirror-Dark.png', title: 'dZMirror icon', xtraStyle: ' min-height: 16px; min-width: 16px;' }"></div></div> icon sits in the footer of tabular [[Displays|displays]] enabled for the display. Anyone viewing your display can use it download the add-in and mirror it into their own spreadsheet. | ||
</div> | </div> | ||
| + | <div> | ||
You can download the dZMirror add-in [https://www.datazoa.com/data/dzMirror.exe here]. | You can download the dZMirror add-in [https://www.datazoa.com/data/dzMirror.exe here]. | ||
| + | </div> | ||
</div> | </div> | ||
<br> | <br> | ||
Revision as of 10:21, 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."
