Navigation:  7.19 > 7.19.0747

Released on April 11, 2020

Change: Safe control on restricted columns

We now check at computing time that the column layout of the minute doesn’t contain any formula referring to any of the following columns:

 

•FORMULA_FOR_QUANTITY

•EVALUATED_QUANTITY

•COMMENT_ABOUT_QUANTITY

•QUANTITY_FACTOR

•QUANTITY_PERCENTAGE

•LOCAL_THROUGHPUT

•QUANTITY_FOR_EVALUATION

•QUANTITY_NUMBER

 

These columns are all hosting-row oriented but they have a special behavior which displays the content of the database of the estimate when rows from the base are referenced. Other free columns which are hosting-row oriented propagate the value being in the hosting row to all rows of the instance.

So, the column above listed cannot be referenced in any formula because that would lead to different figures for different instances of the same row of the database of the estimate.

This is now secured. If you attempted to use such formulas in existing estimate, you didn’t get any message. Now you will get an error message, even with existing estimates.

You can still reference these columns in formulas when your estimate contains no database of the estimate. But, logically, all these fields are designed to calculate the quantities so they should not be needed in formulas.

Change: Recent column QUANTITY_X_QEVAL removed

A special column QUANTITY_X_QEVAL was implemented a few days ago in a recent beta. We have removed it because it cannot work. The reason is explained above (it contained a formula referring to the column QUANTITY_FOR_EVALUATION and this is no longer accepted).

Bug Fix: Recent column QUANTITY_FOR_EVALUATION adapted

The new column QUANTITY_FOR_EVALUATION displays correct figures in all cases. There were no figures in the first rows of instances from the database of the estimate.

New: Special column QUANTITY_NUMBER

A new column named QUANTITY_NUMBER has been added to the special columns in the minutes. You can use it as soon as you use the columns FORMULA_FOR_QUANTITY and the column EVALUATED_QUANTITY. It behaves like a factor which multiplies the resulting evaluated quantity. Its default value is 1 and the default value is not displayed.

Change: A lot of special columns can now be synchronized with external databases

So far, all special columns had their flag ‘Replace when updating’ set to ‘No’. For those which can be stored to external databases, this flag is now editable so you can decide what happen when you decide to store them to a database. You may have to re-insert the columns in your layout to benefit from this change.