Refill non-user matrix

[Former Member]

Hello,

i have to add a column to a non-user matrix in sbo 2005. To achieve this i have to clear the matrix first. After this it is possible to add the column. Now i want to refill the matrix with the old values. Is there any possibility to do this?

Thank you in advance.

[former_member185703 · Accepted solution]

Hello,

The only way is to call AddRows again (or e.g. in A/R or A/P programmatically launch the item select dialog etc. etc.) and to fill in the data via the particular Specifics of the cells - as necessary; please note that when you enter e.g. the item code other columns will be filled automatically...:

You will need to figure out exactly which cells you need to change + you will need to handle issues like the case that the user has chosen to hide some cell that would need to be filled (or has set it to read-only...)

I.e. you must be extremely careful when using this trick - and I would really try to avoid using it!

Frank