Difference between revisions of "About the dZMirror"
From dataZoa Wiki
| (9 intermediate revisions by 2 users not shown) | |||
| 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;"> | ||
<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 | + | When a dataZoa table is mirrored in a user's spreadsheet, each cell in the table becomes an actual cell in the spreadsheet. Because all of the dataZoa cells [[Automatic Updates|update automatically]], formulas in the spreadsheet update automatically as well. |
| + | </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. | ||
| + | </div> | ||
| + | <div> | ||
| + | You can download the dZMirror add-in [https://www.datazoa.com/about/dzmirror.asp here]. | ||
</div> | </div> | ||
| − | |||
</div> | </div> | ||
<br> | <br> | ||
| + | |||
| + | <div class="imgGlyph24 imgIdea"></div> Rather than copying values in and out of spreadsheets, host your data in dataZoa and share the "mirror" link. No time-lag, no copying mistakes, no "version confusion". | ||
| + | |||
<div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | <div>{{Template:PublicDisplaysNeedPublicSeries}}</div> | ||
</onlyinclude> | </onlyinclude> | ||
| Line 14: | Line 22: | ||
[[Category:Displays]][[Category:Definitions]] | [[Category:Displays]][[Category:Definitions]] | ||
| + | [[Category:Circulating]] | ||
| + | [[Category:Time_Savers]] | ||
Latest revision as of 11:01, 28 August 2018
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 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."
