11. Documents, Templates and Data Exchange¶
Answers to frequent questions about reusing documents as templates, exchanging data, difference maps, file handling, document size, and field functions and tables on pages.
11.1. Using templates and data exchange¶
11.1.1. How do I reuse a report as a template for new data?¶
Open the saved document (.ipz or .ipw).
Choose Data > Data Exchange (Document).
Select the data file in the list and click Replace File.
Choose the new file and confirm with OK.
All datasets of the document that were imported directly from a data file are replaced. Datasets created with Data > More Data Functions are calculated again from the new data. If you change the calculation itself, create them again. To keep the document as a template, save it as an .ipw file.
To exchange the data of one page only, use Data > Data Exchange (Page).
See also: Data=>Data Exchange (Document), Data=>Data Exchange (Page), Creation of a Diagram Template.
11.1.2. How can I display several data files in the same diagram, or add a file without replacing the existing data?¶
Use Add File in the Data Exchange dialog:
Select a file in the list and click Add File. UniPlot appends a copy of the list entry and of all datasets related to this file.
Select the new entry, click Replace File and choose the additional measurement file.
Optional: click 2D-Style to give the new datasets a different colour or symbol.
The existing data is kept, and the new file is shown in the same diagrams, for example to compare consecutive measurement cycles.
Note that Add File increases the document size with every exchange, while Replace File does not (see Why does my IPZ/IPW document grow bigger and bigger, and how can I make it smaller?).
See also: Data=>Data Exchange (Page).
11.1.3. Data Exchange (Document) replaces only one page, or fails when the document contains several data files. What can I do?¶
In the Action column of the Data Exchange dialog, set every file that should keep its data to Ignore. Then replace only the file you need.
Do not exchange data from a slow or unreliable network drive, because access to network files can fail now and then. Copy the files to a local drive first.
See also: Data=>Data Exchange (Page).
11.1.4. How do I update a diagram after I changed or recalculated the data and deleted the NC2 file?¶
Do not delete the NC2 file to refresh a diagram. Use one of these methods instead:
Data > Data Exchange (Page) or Data > Data Exchange (Document), then Replace File and select the new data file. The diagrams adapt automatically.
Data > Reload Data….
View > Replot to redraw the diagram.
Datasets created with Data > More Data Functions must be recreated after the calculation has changed.
See also: Data=>Data Exchange (Page).
11.1.5. Why does loading new data into a diagram add a new plot instead of replacing the old data?¶
First click the plot (dataset) that you want to replace, then load the new data from the Data Browser. The selected plot is replaced. If no plot is selected, the loaded data is added as a new plot on top of the existing one.
11.1.6. Title or placeholder text in my template is not updated after Data Exchange. What is wrong?¶
Open the Options dialog of the Data Exchange and make sure that Update text place holders. is selected. By default, placeholders such as $Title$ are filled with the values of the first data file. To use the values of another file, include the file index in the placeholder, for example $File2:Engine$.
See also: Data=>Data Exchange=>Options, Text Placeholder.
11.1.7. How can I load values from an Excel file into the tables of a template?¶
Use text placeholders:
In the table cell, enter a placeholder with the name and the index of the value, for example
$BSFC.1$(1, 2, 3 select the first, second, third value).Import the Excel file. In the Data Browser choose the type Text: Load Placeholder Text and click Load, then confirm with OK.
The cells are updated. When the file is replaced later, enable Update text place holders. in the data exchange options (see Title or placeholder text in my template is not updated after Data Exchange. What is wrong?).
See also: Text Placeholder.
11.1.8. How do I use or change record filters in the Data Exchange dialog?¶
To show the filters, open the Options of the Data Exchange dialog and enable Display record filter in the data exchange dialog box. The Record-Filter column and the Add Record Filter and Remove Record Filter buttons are then available.
Data Exchange does not take over a record filter that was changed inside the new data file. Select the filter per dataset in the Record-Filter column before you run the exchange.
If a diagram does not show its filter after the exchange, right-click the data, open the data file for editing, activate the filter check box and enter the filter expression again. If the new file contains no record that satisfies the filter, UniPlot reports
Cannot create filter. No records found.and the dialog cannot be confirmed; in that case remove or change the filter.
See also: Data=>Data Exchange (Page), Data=>Data Exchange=>Options.
11.1.9. How do I make “Replace File” open in the directory of the selected data file?¶
In the Data Exchange Options, switch off Use the following start directory in the file open dialog box:. The file dialog then starts in the folder of the file in the selected row.
See also: Data=>Data Exchange=>Options.
11.1.10. How can I quickly change the x channel of many diagrams without plotting them again?¶
Use the dataset list of the Data Exchange dialog:
Open Data > Data Exchange (Document)… (or Data > Data Exchange (Page)…).
Click Dataset List.
Select the datasets whose channel should change.
In the Edit Channel dialog, select the new channel.
The column Valid shows + if the channel exists in the data file and ! if it does not. To replace many different channel names at once, see How can I replace many channel names in a template at once, for example with a lookup table?.
See also: Data=>Data Exchange=>Dataset List.
11.1.11. How can I replace many channel names in a template at once, for example with a lookup table?¶
Choose the method that fits your case:
The same channel is used in many datasets: open Data > Data Exchange (Document) and click Dataset List. Sort the list by the channel column and select all datasets that use the old channel (Shift or Ctrl). Choose the new channel in Edit Channel. All selected datasets are changed in one step.
Many different channels (lookup table): use the Excel dataset table.
Add the commands Export Dataset Table, Open Dataset Table and Assign Dataset Table to the user toolbar (Tools > Customize User Toolbar).
Open the template and click Export Dataset Table. UniPlot writes one Excel row per dataset (page, diagram, data file, x, y and z channel).
In Excel, replace the channel names, for example with Find & Replace or a lookup formula. Save the table.
In UniPlot click Assign Dataset Table. When the warning appears, click Yes to save the document under a new name first.
Assign Dataset Table deletes all datasets of the document and creates them again from the table. Therefore always work on a copy.
Translate the channel names of the data instead of the template: the Norm Names add-in replaces channel names with standard names from an Excel table. It works during the import of UTX and ASAM-ODS data and, since R2025.3, for the data file of a Sequencer slot with the action Norm Names. One template then fits files with different channel names.
See also: Data=>Data Exchange=>Dataset List, Insert Datasets into a Template, Norm-Names, Action Norm Names.
11.1.12. How can I change the plot type of the diagrams in an existing template from 1D to 2D?¶
Do this one diagram at a time:
Open the template and import a data file that contains the desired channels.
Select the graph in the diagram.
In the Data Browser choose the new graph type (2D) and set the x and y channels.
Click Load and confirm the question with Yes.
Right-click the diagram and choose Autoscale > Autoscale selected Diagrams.
Save the template.
11.1.13. How can I create a reusable template for a 3D or contour plot with fixed fonts, size and position?¶
Build the diagram once, format fonts, size and position, and load the data manually. To replace the data later, use Data > Data Exchange (Document). Fonts, diagram size and position are kept, because only the data is exchanged.
See also: Creation of a Diagram Template, Data=>Data Exchange (Document).
11.2. Troubleshooting data exchange¶
11.2.1. Data exchange gives an error about missing channels, or old data stays in diagrams whose channel is missing. What should I check?¶
The error lists channels that the document expects but the new file does not contain.
Check Tools > Formula List…. A formula that references a channel that does not exist in the data (or a formula that is still active from your configuration) causes the error. Remove or correct the formula and repeat the data exchange.
A formula that is calculated online in the template (formula channels computed during the exchange) can also make the exchange fail even though the files are fine. Remove it and exchange again.
If a table lacks a column, or a table configuration contains a deleted channel, add the missing column or remove the stale channel entry on each page.
If UniPlot reports missing channels, choose Yes to continue and select Ignore all following missing channels. Diagrams whose channels are missing in the new file then become empty (2D and 3D). If old data remains, open the Dataset List of the template and check whether files are mixed in the same template.
The Excel error values
#VALUE!or#N/Ain a data file can make the exchange fail. Clean these cells in the source file.
See also: Tools=>Formulalist, Data=>Data Exchange=>Dataset List.
11.2.2. Data exchange reads files incorrectly or does not update a difference map. Can file names be the cause?¶
Yes. File names with unusual characters (for example non-Latin or random symbols) can break the data exchange. Rename the files to plain ASCII characters (letters, digits, underscore) and repeat the exchange.
11.2.3. Adding or replacing files fails with an error (for example C0000005) or datasets multiply after each attempt. What can I do?¶
Typical causes are templates with unusual contents. Check these points:
Use Data > Data Exchange (Document) with Replace File, not Add File, when the data should be replaced.
A dataset with a filter function whose channel is missing in the data file (the dialog then shows a point count such as
0 (4)) could make adding a file fail in releases before R2023.4 (fixed in R2023.4). Update UniPlot, or delete such datasets and add the file again.Newer releases include calculated (computed) datasets in the exchange. A template created in an old release can contain an “empty” computed dataset with missing channels (for example a smooth_time filter). Remove it from the template.
If datasets pile up after every exchange, filtered datasets with missing channels may exist. Open the dataset list and select the datasets of the affected diagrams. Toggle the filter function off and on in their configuration and delete the extra datasets.
A page with many datasets can slow the exchange down. Delete the datasets you do not need.
If a template triggers an error only in one version, update UniPlot (see Which UniPlot releases fixed known data exchange problems?), because several data exchange problems were fixed in the 2022 and 2023 releases.
Data exchange can be slowed by custom scripts in the
autoloadfolder. Start UniPlot with/NoAutoLoadto check whether a script influences the exchange.
See also: Data=>Data Exchange (Document).
11.2.4. Assign Dataset Table fails with “Failed to load data. Unknown Format.” although I did not change the table. What can I do?¶
Fixed in R2025.3
Update to R2025.3 or later, then export the table again before you assign it. Since R2025.3 the dataset table commands (Export Dataset Table, Open Dataset Table, Assign Dataset Table) write and read the table as an .xlsx file. The data file names in the table, including NC2 files, are also handled correctly.
The message means that no import filter could read a data file listed in the columns DatafilePath and DatafileName. If it still appears, check that:
the files still exist at that path,
the file name in the table is complete and spelled correctly.
See also: Insert Datasets into a Template, The Data Source Table.
11.2.5. Why are calculated channels, formula channels or histograms not updated by Data Exchange (Document)?¶
Update UniPlot with Help > Check for Updates. In older releases calculated datasets did not follow the exchange. These improvements were made:
Since R2020.1 the formulas of NC2 data files are calculated before the exchange.
Since R2021.4 computed datasets (for example created with Data > More Data Functions) are generated for newly added files.
Since R2023.3 calculated 3D datasets are updated during the exchange.
Data exchange only replaces data that was imported directly from a file. If you change the calculation itself, create the datasets from Data > More Data Functions again.
See also: Help=>Check for Updates, Which UniPlot releases fixed known data exchange problems?.
11.2.6. After Data Exchange a cycle diagram (2D: x/y Cycle) still shows the old cycles. Why?¶
Fixed in R2021.1
This was a bug in releases before R2021.1. Update to R2021.1 or later (Help > Check for Updates).
In older releases the data exchange with cycle plots (2D: x/y Cycle) replaced only the first dataset, by one dataset that contained all cycles. The diagram then showed one long graph, or old cycles remained.
See also: Data=>Data Exchange (Page), Which UniPlot releases fixed known data exchange problems?.
11.2.7. Which UniPlot releases fixed known data exchange problems?¶
If you still use an older release, update with Help > Check for Updates. Fixed problems:
R2021.1: data exchange with cycle plots (2D: x/y Cycle) replaced only the first dataset by one long graph.
R2021.3: data exchange with an empty channel and an active data filter still showed the old filter values.
R2021.4: computed datasets (for example maximum datasets) are generated for newly added files.
R2021.5: the data exchange stopped after a page with missing channels, and did not replace or add datasets of the types 2D: x/y/Label and 2D: x/y/Cycle-Index.
R2022.1: a script error occurred when computing a 3D difference map.
R2022.2: a script error occurred during data exchange.
R2023.3: calculated 3D datasets were not updated during data exchange in some conditions.
R2023.4: a missing channel with a filter function caused a crash during data exchange.
See also: Help=>Check for Updates.
11.2.8. Why is a 3D difference map not updated after Data Exchange?¶
A difference map is a dataset calculated from two source maps. It follows the data exchange automatically when the source datasets are exchanged. If it keeps showing old data:
Update UniPlot. Data exchange problems with computed datasets and difference maps were fixed in R2021.4, R2022.1 and R2023.3 (see Which UniPlot releases fixed known data exchange problems?).
Make sure the source datasets have names. Double-click an isoline of the left map to open the 3D dataset configuration, open the Name tab and give the dataset a name (for example
Data1). Repeat for the right map (Data2), save the template and exchange the files again. A damaged or very old template can contain 3D datasets without a name.Use the standard procedure to build the difference: import data, plot two 3D maps, right-click the first map and choose 3D-Difference… (see Data=>Difference map and other functions (3D)). Then exchange the files with Data > Data Exchange (Document).
If the difference map still keeps the old data, check the log window for error messages and repeat the data exchange.
Check that the file names contain only plain ASCII characters (see Data exchange reads files incorrectly or does not update a difference map. Can file names be the cause?).
If you choose the same file that is already used in the template, nothing changes, because the maps keep their values.
See also: Data=>Data Exchange (Document), Data=>Data Exchange=>Dataset List.
11.2.9. Many temporary windows are created during data exchange of a template with calculated graphs. How can I avoid this?¶
Turn off the check box Always load original data files in the Data Exchange dialog to speed up the exchange: UniPlot then opens the existing NC files instead of converting the original files again. Also check that no custom script in autoload modifies the data exchange (start UniPlot with /NoAutoLoad), and use a current release.
See also: Data=>Data Exchange (Page).
11.3. Opening, saving and repairing documents¶
11.3.1. An IPZ or IPW document cannot be opened, shows only one page, or is reported as corrupt. Can I recover it?¶
A damaged file (for example after a crash) usually cannot be repaired, but UniPlot keeps earlier versions:
Look in the folder of the document for a backup with the same name and the extension
.bak(for examplereport.ipz.bak). Remove the last extension (.bak) and open the file. A backup that was written after the damage is also damaged, so try an older one if there is one (for example from OneDrive version history). Sometimes a.jnlfile exists next to the document; keep it in the same folder.Look in the
AutoSaveandLocalStorefolders of your UniPlot user folder (for example%LOCALAPPDATA%\UniPlot\AutoSave) for an earlier version. Copy files before you delete anything there, and remove the.bakextension to open them.Check the log window for errors and open the Dataset List to see whether hidden pages exist.
Renaming an .ipw file to .ipz does not help for a corrupt file. Save important documents regularly and keep the autosave function enabled.
See also: Tools=>More Options.
11.3.2. I cannot open saved UniPlot files and an error appears. What can I check?¶
Find out whether one file or all files are affected and whether a colleague can open the same file. If the file opens on another PC, the cause is in your user directory, for example scripts in the autoload folder or the formula folder in the user home directory (see User Home Directory under Tools > More Options > Paths and Files). Test by starting UniPlot with /NoAutoLoad and with a renamed formula folder.
See also: Tools=>More Options.
11.3.3. Why is my IPZ file opened write-protected (“write protect” in the title) or why do I get “Cannot open file”?¶
A document opens read-only when it is in use elsewhere. Check these points:
The file is open in another UniPlot instance on the same PC, or on another PC (file on a network drive).
A script accessed the document and failed without closing it. Restart the PC that opened it.
A file manager preview or viewer (for example the preview pane of a file manager) has the file open and blocks it. Turn off the preview.
Copy On Open in Tools > More Options > UniPlot Document Options is enabled and the file is opened from a network folder that is not mapped as a drive: if UniPlot cannot create the
.lockfile, the file opens read-only.The folders
LocalStoreandAutoSave(in%LOCALAPPDATA%\UniPlot) contain many files. If they contain only outdated files, delete them while UniPlot is closed; files inLocalStorecan be the only copy of a modified document, so check first.
A leftover .jnl or .lock file next to the document does not by itself make it read-only. To change data in a read-only document, save a copy with File > Save as under a new name.
See also: Copy On Open, UniPlot Document Options.
11.3.4. The modified date of a document on a network drive is not updated. Why?¶
With Copy On Open enabled, UniPlot works on a local copy of the document. The time stamp on the network drive can be unchanged when you close the document with the window close button and confirm saving. Save with Ctrl+S before closing, or disable Copy On Open in Tools > More Options > UniPlot Document Options if you want to open documents directly from the network.
See also: Copy On Open.
11.3.5. Saving a document on a slow network drive takes minutes and reopening it gives an error. Why?¶
Saving runs in a background process and continues after you close the document or the UniPlot window. While saving, the file is locked, so reopening or deleting it fails. This also applies after a script has called Doc_Save.
Wait until the save has finished before you reopen or delete the file. On slow connections this can take several minutes.
Faster: save to a local drive and copy the file afterwards.
The background save is controlled by the option Use a background process to save the document in Tools > More Options > UniPlot Document Options.
See also: File=>Close (Save Compact).
11.3.6. Saving a very large IPZ template (about 2 GB) fails with “Cannot save”. What can I do?¶
Reduce the document size (see Why does my IPZ/IPW document grow bigger and bigger, and how can I make it smaller?). In Tools > Options (setting “Data Type for 1D-, 2D-Datasets”) you can store the data of 1D and 2D datasets as
floatinstead ofdouble; this halves the data size at slightly lower precision.Open only the new data file, save it as NC2 and check its size; then exchange the data in the template with this NC2 file. NC2 itself handles very large files.
Make sure the target drive has enough free space and is not a slow network share.
If the error persists, collect the latest files in the
logfolder of the UniPlot home directory and a screenshot of the error.
11.3.7. After a new PC or an upgrade, old files are reopened at program start with “*” (unsaved). How do I stop that?¶
UniPlot restores unsaved and last session files from the AutoSave and LocalStore folders of the user directory. To stop this, clear these folders:
Close UniPlot.
Open the folder
%LOCALAPPDATA%\UniPlot.Check that no file in
AutoSaveandLocalStoreholds changes that you still need.Delete the contents of the
AutoSaveandLocalStorefolders.Start UniPlot again.
See also: Tools=>More Options.
11.3.8. How do I convert an IPZ document to IPW (or back)?¶
Open the document with File > Open, then choose File > Save as and enter the file name with the extension .ipw (or .ipz for the opposite direction). The saved file is a valid file in the other format. If the explicit command File > More File Functions > Convert UniPlot-IPZ to UniPlot-IPW… fails with “Conversion of the following files failed” for a file, use Save as instead.
11.3.9. Why does my IPZ/IPW document grow bigger and bigger, and how can I make it smaller?¶
UniPlot documents are compound files like a small file system. When content is replaced (for example by a data exchange), the old element is not removed directly: the gap remains and the new content is appended, which inflates the file. Ways to compact it:
Automatic: enable Save Document files compact in Tools > More Options > UniPlot Document Options (enabled by default). The file is then rewritten compactly when more than 50 percent of it consists of gaps.
Manual: open the file and choose File > Close (Save Compact). This takes longer once; for very large files on slow drives it can take several minutes.
While a temporary file exists next to the document, a compacting process is still running in the background; wait until it has finished (a document of 600 MB can shrink to less than 100 MB).
Further measures:
Use Replace File rather than Add File for data exchange; Add File increases the file size.
If the file still is large, it contains a lot of data. For storage or e-mail, exchange the large data with a small data file and re-link the large data when you continue to work.
Store 1D/2D data as
floatinstead ofdouble(see Saving a very large IPZ template (about 2 GB) fails with “Cannot save”. What can I do?).If the file grows by hundreds of megabytes after adding pages although the compact option is enabled, un-tick the other options in the UniPlot Document Options and save again.
See also: File=>Close (Save Compact), UniPlot Document Options.
11.3.10. Can a UniPlot document contain more than 255 pages?¶
No. A document holds at most 255 pages (see Application Limits). Split large evaluations or reports into several documents.
See also: Overview Diagram Documents.
11.4. Templates, pages and layout¶
11.4.1. How do I add my own template (for example 16:9) to the File > New and New Page lists without replacing the standard ones?¶
Setting a template path in Tools > More Options > Paths and Files > NEW Command Template File Location replaces the standard list. To extend the standard list instead:
Keep the path set, open
file-new-en.ipz(orfile-new-de.ipzfor the German user interface) from thetemplatefolder of the installation.Add a new page, insert your template (for example the 16:9 page) and rename the page.
Save the file, remove the path from the option and restart UniPlot.
Writing to the program folder can need administrator rights. Other standard templates are in the same template folder.
See also: Tools=>More Options.
11.4.2. The “Show page margin” setting is enabled again for every new page. How can I make it permanent?¶
There is no option for it. Edit the new-document template instead:
Open
file-new-en.ipz(orfile-new-de.ipz) in thetemplatefolder of the installation.Remove the page margin on the pages (File > Page Margin).
Save the file in the same location.
Restart UniPlot.
You can still add margins manually later. Writing to the program folder can need administrator rights.
See also: File=>Page Margin.
11.4.3. How can I set the same page size (for example 200 mm x 300 mm) for all pages of a document at once?¶
File > Page Setup changes the paper size of the active page only. To change all pages of the active document in one step, use a short UniScript:
Open the command window (View > Command Window).
Enter these lines (width and height in cm, 1 to 100 cm):
hDoc = AppGetActiveDocument(); hvPage = DocGetAllPages(hDoc); for (i in 1:len(hvPage)) PageSetSize(hvPage[i], 20, 30); PageReplot(AppGetActivePage());
Save the document.
Instead of width and height you can pass a predefined paper size, for example PageSetSize(hvPage[i], 9) for A4.
See also: File=>Page Setup, PageSetSize, DocGetAllPages.
11.4.4. How can I change the font of all diagrams or text objects in a document in one operation?¶
Format one object as you want it, then copy its format to all objects of the same type with Edit > Copy Format:
Change the font of one diagram or one text object.
Select this object and click the brush button in the toolbar (or choose Edit > Copy Format). The dialog lists all objects of the document that have the same type as the selected one.
In the style list, check the properties to copy, for example the font.
Select all objects in the object list (Ctrl+A) and click Assign Styles.
The format of all selected objects is changed. Other layout options, such as the grid colour of diagrams, are applied the same way. There is no global font setting for a whole document.
See also: Edit=>Copy Format.
11.4.5. How can I move a page quickly to another position in a document with many pages?¶
Right-click the page background and choose Move Page… (or Edit > Page > Move…).
Select one or more pages in the list.
Enter the new position and click In front of Position.
The selected pages are moved and keep their order. Moving several pages at once is possible since R2020.5. For scripts, use PageMove.
See also: PageMove.
11.4.6. Changing an axis title on one page also changes it on duplicated pages. How do I make them independent?¶
The axes of the duplicated diagrams are linked. Select a diagram, open Diagram > Link Axes Scales… and remove the X link or Y link. The axis titles are then independent.
11.4.7. Threshold lines or ranges disappear or are shifted after replacing data in a template. Why?¶
A threshold (limit line or range) is drawn relative to the y axis of the diagram it belongs to. A diagram without its own data has no scale, so UniPlot cannot know where to draw the threshold. Therefore thresholds in a separate diagram do not work.
Enable the y axis scale for the diagram.
Check that the threshold values lie inside the displayed range.
If thresholds are shifted after a data exchange started by a script with DocExchangeDataFiles, check the parameters of the call, especially the last two.
See also: DocExchangeDataFiles.
11.4.8. After duplicating a page and replacing its dataset, the integral (follow-up function) still refers to the dataset of the first page. How can I fix this?¶
Change the source (dependency) of the integral to the dataset of the new page. A calculated dataset such as an integral stores its source as dataset name plus page name, for example Data1:Page 1. A copied page therefore still points to the source dataset on the original page, and a data exchange on the copied page does not change the integral.
On the copied page, right-click the integral curve and choose Edit Function Parameters….
Select the DependOn entry and click Edit Function….
In the Edit Dependencies dialog, enter the dataset of the new page, for example
Data1(same page) orData1:<new page name>.
The calculation is then updated from the new data. The message could not find dataset X also means that the referenced dataset is not on the page; correct the reference in the same way.
See also: Data=>Edit Function List.
11.4.9. Can I place two tables of contents side by side on a page?¶
The table of contents template contents-template-en.ipw (contents-template-de.ipw for the German user interface) is located in the template folder of the installation and can be edited. However, when more than one table is placed on the page only the first one is filled with titles and page numbers. Use one table per page, or two separate contents pages.
11.5. Field functions, tables and text objects¶
11.5.1. Why do field functions such as page name or page number show wrong values on a background page?¶
A field function always refers to the page on which it is placed. On a background page it therefore cannot show the name or number of the page in front (a page number field can return an error text). Insert the field in each normal page: create it once, then copy and paste it to all pages so that it has the same position everywhere. The same applies to a legend that should show the data of the page in front.
To show the legend of a diagram on another page, copy the diagram to the other page (the legend survives a refresh but does not update on data exchange), or build a legend table with field functions (see How can I build a legend table that updates automatically and label data points?).
See also: Field Functions, @f{pagename}.
11.5.2. How can I start page numbering later in a document, for example skip the first three pages?¶
Use an offset in the page number field function. @f{pagenumber(-3)} numbers the pages so that page 4 shows as 1. Adapt the offset to the number of pages to skip, and insert the field in a text object on each page.
See also: @f{pagenumber}.
11.5.3. How can I show a value from a dataset on another page, for example in a summary table?¶
Use the field function xystatvalue and qualify the dataset with the page name, separated by a colon:
@f{xystatvalue(DatasetName:PageName, Type)}
Type selects the statistical value; see the function description for the valid values. A summary page can in this way show characteristic values of the datasets of all pages in a table.
See also: @f{xystatvalue}.
11.5.4. A text box or table with xyvalue keeps jumping to another position on the page. How do I stop that?¶
This is the documented behaviour of xyvalue: when a value such as ymax or ymin is requested, the text box moves next to the data point. Use xystatvalue if the text box or table must stay in place.
See also: @f{xyvalue}, @f{xystatvalue}.
11.5.5. The field function xyinterpol returns nothing for y-to-x interpolation. What is the correct syntax?¶
For interpolation from y to x all parameters must be given, especially the number of the intersection. Use the form @f{xyinterpol(dataset, value, format, i_intersect)} with a value of the form y=600. Always give the intersection number if the curve crosses the value several times. Compare the exact parameter order with the function description.
See also: @f{xyinterpol}.
11.5.6. How can I show the name of an enumeration value instead of its numeric ID in a text object?¶
Use the type enumvalue in the xyvalue field function, for example @f{xyvalue(Data1,ymax.enumvalue,1,%g)}. The enum value of ymax.enumvalue and ymin.enumvalue is correct since R2022.2.
See also: @f{xyvalue}.
11.5.7. How can a field function read an attribute of the NC file that belongs to a dataset?¶
A document does not follow the file that is currently loaded in the Data Browser; it refers to the data copied into the document. Functions such as Browser_GetDataFile() are not evaluated inside a field function. Use one of these methods:
@f{ncattfromdata(DatasetName, AttributeName)}or@f{ncattfromdata(DatasetName, AttributeName, VarName)}, for example@f{ncattfromdata(Data1, Company)}. The dataset remembers the file it came from; if that file is deleted, the last value is kept.Placeholders such as
$Operator$(global attribute) or$EngSpd.units$(channel attribute), which are updated on data exchange (option Update text place holders., see Text Placeholder).
Field functions cannot be used in the alias table.
See also: @f{ncattfromdata}, Text Placeholder.
11.5.8. A table with field functions is not displayed correctly when I combine a scalar value with vector channels. What can I do?¶
Channels of different dimensions (different time basis or sampling) are not combined, to avoid mixing data of different frequencies. Convert the scalar value into a vector on the same basis as the other channel; the table is then displayed correctly.
See also: Table Objects.
11.5.9. How can I build a legend table that updates automatically and label data points?¶
Create a table on the page and enter field functions in the cells:
Curve colour:
@f{legendstyle(DiagramName, DatasetIndex)}, for example@f{legendstyle(Diagram1,1)}.Curve name:
@f{legendtext(DiagramName, DatasetIndex)}.
The table is updated by the data exchange. Data points can be labelled with the field functions @f{labeldatapoint} and @f{labelsinglepoint}.
See also: @f{legendstyle}, @f{legendtext}, @f{labeldatapoint}, @f{legend_table}.
11.5.10. The file legend shows the original measurement file instead of the NC file name, or lists the files in the wrong order. Why?¶
The file legend (field function Create legend for data files (Table)) shows the original data file, not the converted NC file. This is the file the data was imported from, the “origin” of the NC file. If you copied or renamed an NC file, the legend still shows the original file name.
The order of the files and the comment come from the Data Exchange dialog:
Open Data > Data Exchange (Document).
To change the order, select a file and click Button One Up or Button One Down.
To show a text in the legend, enter it in the Comment column.
To list only the files of one diagram, right-click the legend table, choose File Legend Configuration and select Display used files of the selected diagram (since R2024.2).
See also: Table=>File Legend Configuration, @f{legend_table}, Data=>Data Exchange (Document).
11.5.11. How can I list the names of all data files used in the document or on a page in a text field?¶
Use the standard field function List of all used data files. No custom script is needed.
Choose Diagram > Insert Field Function.
Select List of all used data files.
Choose the format: Name, Name.Ext, path.name.ext or drive.path.name.ext.
The field lists the data files of the datasets on the page where it is placed, for example @f{datafilenames(name.ext)}. With @f{datafilenames(NCFile, name.ext)} it shows the NC file names instead of the original files.
To list the files of the complete document in a table, use the file legend (Create legend for data files (Table)) with the option Display used files of the complete document (see The file legend shows the original measurement file instead of the NC file name, or lists the files in the wrong order. Why?).
See also: @f{datafilenames}, Diagram=>Insert Field Function, Field Functions.
11.5.12. How do I highlight a table cell automatically when a value exceeds a limit, or show a number in exponential notation?¶
Highlighting: right-click the table cell, choose Conditional Formatting > Add Rule…, define the condition and the format and confirm. The format is applied automatically whenever the cell value meets the condition. Rules on cells whose content comes from a field function that returns a number are supported since R2025.3; update UniPlot if this does not work.
Exponential notation: change the format in the cell formula, for example
%.2einstead of%.3lf, or right-click the cell, choose Configuration…, select Numbers > Format and set an exponential format.
See also: Table Objects, @f{ncvaluefromdata}.
11.5.13. How do I embed an Excel worksheet in a UniPlot page and keep it editable?¶
An object created with Edit > Insert New Object > Create new > Microsoft Excel Worksheet can only be edited while Excel is open. After you close Excel, UniPlot can no longer access its content and double-clicking raises a reference error. To keep the data permanently, link a saved file:
Create and save the Excel file locally.
In UniPlot create or open a document (File > New…), then choose Edit > Insert New Object….
Select Create from file, browse to the Excel file, tick Link and, if you want an icon, Display as icon, and click OK.
Double-click the object. Excel opens; edit and save in Excel and the table in UniPlot is updated.
The content is displayed in UniPlot but can only be edited in Excel. If the object appears blank, set Graphics Rendering Screen to GDI+.
See also: Insert Objects into UniPlot, Editing an Embedded Object.
11.5.14. An embedded Excel table does not update its visible area after my script changed the data. What can I do?¶
At the end of the script, update the field functions of the page so that the table is refreshed:
PageUpdateFields(hPage);
hPage is the handle of the page that contains the table. Interactively, you do the same with Edit > Update Fields (F9).
See also: PageUpdateFields, Edit=>Update Fields.
11.5.15. How do I remove tables from many pages and re-centre the diagrams before exporting to PowerPoint?¶
If the tables are on the background (master) page, edit that master page once instead of every page. To assign the master page, right-click an empty area of the page and choose Select Master Page….
Otherwise use a UniScript that loops over all pages and layers: get the pages with DocGetAllPages, the layers with PageGetAllLayers, check the type of each layer with LayerGetProps (diagram or table), set Do not print for tables (or delete them) and resize the diagrams with ObjSetProps. Work on a copy of the document.
If some graphs do not follow a linked y axis, they are protected. Unprotect them.
See also: DocGetAllPages, PageGetAllLayers.
11.5.16. An error message box appears on every page change when I open an IPZ whose data files are not available. How can I avoid it?¶
The message comes from an import script (for example a custom add-in used to re-import files) that calls a message box when the measurement data is missing. Change the message box in the script to log_warning so that the message goes to the log window instead of waiting for acknowledgement on every page.
id-428497