Differences

This shows you the differences between two versions of the page.

--- en:process_steps:worksheet [2020/01/21 14:39]
andraz
+++ en:process_steps:worksheet [2024/02/18 00:47] (current)
tiger [How Djeeni manages worksheets]
@@ Line 1: / Line 1: @@
-====== Worksheet Group [] ======
+{{indexmenu_n>1}}
+====== Working with Worksheets ======
 Djeeni can execute the following worksheet related process steps:
   * [[.worksheet:wsheet_use]]: Specify a worksheet to be used in the process (either as a source or target data set)
-  * [[.worksheet:wsheet_add]]: Add a worksheet next to a worksheet already in use
+  * [[.worksheet:wsheet_add]]: Add a worksheet next to another worksheet
   * [[.worksheet:wsheet_filteradd]]: Add a filter to a worksheet
-  * [[.worksheet:wsheet_filterclear]]: Clear the filter in a worksheet
+  * [[.worksheet:wsheet_filterclear]]: Clear the filter on a worksheet
   * [[.worksheet:wsheet_rename]]: Rename an existing worksheet in use
-  * [[.worksheet:wsheet_pdf]]: Create a PDF version of a worksheet
+  * [[.worksheet:wsheet_pdf]]: Create a PDF file from a worksheet
-  * [[.worksheet:wsheet_normalise]] WSheet Normalise: Delete empty rows and columns from the worksheet
+  * [[.worksheet:wsheet_normalise]]: Get rid of possible irregularities (extra empty rows/columns; badly formatted dates or numbers) on a worksheet before actual processing
-  * [[.worksheet:wsheet_release]] WSheet Release: Release a worksheet with a Djeeni name to be able to use that name in another worksheet
+  * [[.worksheet:wsheet_release]]: Release a worksheet with a Djeeni name if processing is ready
+===== How Djeeni manages worksheets =====
+Next to the explicit Wsheet Use, Wsheet Release and WBook List Start process steps Djeeni actively manages the open worksheets by the following rules:
+  * At the end of the process all source worksheets in use are released without saving and the corresponding workbooks closed
+  * At the end of the process all target worksheets in use are released without saving; the corresponding workbooks remain open
+  * At the Wbook List Next process step the current worksheet in the list is released and closed and the next worksheet is used.

User Tools

Site Tools

Differences

Page Tools