Hi Michel,
You can do a lot without impacting the Re-Import.
If I explain what content we rely on and then I’ll outline some rules below:
We rely on:
Row 1 – (and apart from A,B,C) it stores the internal name for the element attribute, or existing tagged value name
Row 2 – (and apart from A,B,C) it stores the user name for the column whether an element attribute or tagged value. Note that if this is a value is placed in a column in Row 2 and the corresponding cell in Row 1 is blank we assume it is a new tagged value
Row 3 – is reserved for value typing
Column A stores the GUID for existing items – for new items on import this would be blank until the element has been created
Column B stores the Parent ID – once again if/when the element exists
Column C contains the Element Type – this must be set for new elements, otherwise reflects the current type
So at present this means:
* Don’t move columns A,B,C
* Don’t move rows 1,2,3
So in turns of your points:
1. Changing cellattributes (color, aligment, border) –> Don’t see any issues with this
2. Data Validation List for columns –> no problem excepting they should not comprise the values in Rows 1,2,3
3. Reorder columns –> yes APART from A,B,C
4. Conditional formatting –> no problem
I hope the explanation helps you understand the rules.
Just so you are aware we are looking at some enhancements which may involve modifying these rules, if some additional, special cases are used. We do not anticipate any changes for current functionality.
If in doubt or you experience any issues do let us know.
BR
eaDocX Support
.
