{"id":23442,"date":"2016-02-01T10:15:12","date_gmt":"2016-02-01T09:15:12","guid":{"rendered":"http:\/\/help.qualiware.it\/qw-help\/?p=23442&lang=en"},"modified":"2016-02-05T09:42:49","modified_gmt":"2016-02-05T08:42:49","slug":"07-word-excel-qw-fields","status":"publish","type":"post","link":"https:\/\/help.qualiware.it\/qw-help\/07-word-excel-qw-fields\/?lang=en","title":{"rendered":"QUALIWARE FIELDS WITHIN “WORD AND EXCEL DOCUMENTS”"},"content":{"rendered":"

Within the documents created by Microsoft Word<\/strong> and Microsoft Excel<\/strong>, you can insert information residing in the database of QualiWare and that are defined in form realized by the Form Designer. <\/span>This is done through special “bookmarks” (that we will call\u00a0“QualiWare Fields”);<\/strong>\u00a0they allow automatic updating of such information at the opening of file.<\/span><\/p>\n

QualiWare fields can be included in templates<\/a>\u00a0and in \u00a0form’s printing<\/a>, using the appropriate menu QualiWare Fields,<\/strong>\u00a0in the Add-ins<\/strong> tab of the toolbar.<\/p>\n

The modality which the QualiWare fields are inserted into the text is different between Microsoft Word and Microsoft Excel, and it is described below.<\/p>\n

\"campiqualiwareExcel\"<\/p>\n

<\/a>Microsoft Word<\/strong><\/h4>\n

The field values are inserted into the “Document customized Property<\/em>” at the time of opening the file, and within the text is inserted a reference to the property.
\n<\/span>Clicking by the mouse’s right button on a field, choosing “enable\/disable codes field” shows the code of the reference. <\/span>The following image shows an example:<\/span><\/p>\n

\"codicidicampoWord\"<\/p>\n

The position of eventually grid on the form is defined by using tables, that must have a number of columns equal to the number of columns that are configured in the form.
\n<\/span>The first line is the header, which can be defined in the template or left blank, and if so, will be automatically updated when creating the document, containing the description of columns inserted.<\/span>
\nEach table is associated with the corresponding grid through a bookmark consists of the prefix “GRID_”, followed by the name attributed to the grid on the form.<\/span><\/p>\n

\"segnalibrogrigliaWord\"<\/p>\n

<\/a>Microsoft Excel<\/strong><\/h4>\n

Starting from version 2015.03a<\/strong>, QualiWare fields are identified by named cells, <\/strong>that QualiWare fills, at the time of opening the file, with the value of the field to which they relate. <\/span>The cell name is visible in the position shown in the following picture.<\/span><\/p>\n

\"celleDenominateExcel\"<\/p>\n

The insertion position of the grids is identified by a cell whose name consists of the prefix “grid_” followed by the name attributed to the grid on the form. <\/span>That cell identifies the first header cell. <\/span>QualiWare will insert in the header row of the descriptions of the columns specified in the definition of the form where that line is empty. <\/span>The grid data are entered on subsequent rows.<\/span><\/p>\n

\"cellagrigliaExcel\"<\/p>\n

NOTE<\/strong><\/p>\n

In earlier versions \u00a0“QualiWare Field” values were inserted in cells by the function PropertyValue<\/b>, where VBA code was injected by QualiWare itself in the file upon creation. <\/span>This entailed the need for formats that support macros (such as XLS, XLSM and XLSB).<\/span>
\nFrom version 2015.03<\/span> is used uses the above-described methodology of named cells, and the files and the existing templates are changed upon first opening, giving the appropriate naming to cells that contains the call to the function Propertyvalue<\/em>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

Within the documents created by Microsoft Word and Microsoft Excel, you can insert information residing in the database of QualiWare and that are defined in form realized by the Form Designer. This is done through special “bookmarks” (that we will call\u00a0“QualiWare Fields”);\u00a0they allow automatic updating of such information at the opening of file. QualiWare fields…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"ngg_post_thumbnail":0,"footnotes":""},"categories":[35],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/posts\/23442"}],"collection":[{"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/comments?post=23442"}],"version-history":[{"count":0,"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/posts\/23442\/revisions"}],"wp:attachment":[{"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/media?parent=23442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/categories?post=23442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/help.qualiware.it\/qw-help\/wp-json\/wp\/v2\/tags?post=23442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}