AX3013
Resolving the column layout warning
What causes this warning?
The column layout warning displays when Axiom detects a column structure change in a template sheet. You may have deleted columns in the sheet or added columns. The warning indicates the first detected change in the sheet (for example, "starting at column F") but there may be other column changes elsewhere in the sheet.
When a template sheet has an associated calc method library, the column structure of the sheet and the calc methods must remain in synch. Additionally, any other templates in the file group that contain the same sheet name must also have the same column structure, because they share the same calc method library.
This warning is intended to alert you of a possible mismatch between the template sheet, the calc method library, and other templates in the file group. Once triggered, the warning appears when you save the template (with the impacted sheet active), or when you perform any calc method action in the sheet.
What do I need to do about this warning?
The action that you need to take depends on whether you are currently following standard procedures for updating the column structure of a template sheet. Generally, if you need to change the column structure of a template sheet, you need to bring in all calc methods first, then make the change, then update the calc methods in the library. For more information, see Changing the column structure of a template sheet.
-
If you are currently following the standard procedure, then the warning is simply a reminder. Axiom only detects the column layout change; it does not know if you have already made all associated updates or if you are in the process of doing so. You can continue saving calc methods and templates until you have made all necessary updates. Once you are finished updating, you can "reset" the column layout data to dismiss the warning.
-
If you get this warning and you are not following the standard procedure (for example, if you deleted or inserted a column without bringing in the calc methods first), then you most likely have a column mismatch that needs to be resolved. If possible, you should restore your template to its original state, and then follow the standard procedure for updating column layout. If this is not possible, or if you otherwise need assistance, please contact Axiom Support.
The warning will also occur if you manually delete a validation code in the reserved validation rows (rows 1-2). These rows are reserved for system-generated codes and should not be edited by users. If you absolutely know that this is the cause of the warning, then you can reset the column data layout to dismiss the warning and repopulate the validation codes. However, if you have any doubt, then you should review the template and the calc methods first to ensure that everything is still in synch.
How do I reset the column layout data?
Once you are sure that all necessary updates have been made, you can reset the column layout data to dismiss the warning:
-
On the Axiom tab, in the Advanced group, click CM Library > Reset Column Layout Data.
NOTE: If other templates in the file group share the same sheet name, those templates will also be opened and the column layout data will also be reset for that sheet.
- Save all templates where the column layout data was reset.
When you reset the column layout data, Axiom accepts the current column layout as correct, and places new validation codes in the sheet. You will not see the column layout warning for this sheet again, unless a new column layout change is made to the sheet.
IMPORTANT: You should not reset the column layout data unless you are confident that all necessary updates have been made. If a column mismatch is left unresolved, it can result in errors in your plan files, and may impact the validity of your data. If you have any doubt, please contact Axiom Support for assistance.