Using a macro, I want to change the data displayed in a grid column from one table field to a different field of the same table.
This was working fine in version 4.2.8.x with the following code:
oForm = ThisComponent.Drawpage.Forms.getByName("MainForm") oField = oForm.getByName("TestTable") oColumn = oField.getByName("FormattedField1") oColumn.DataField = "MONTH3INFO" oColumn.Label = "MONTH3INFO" oColumn.Name = "MONTH3INFO"
I recently found out this version was ending its’ life cycle so I upgraded to v220.127.116.11 and most of my code works fine except for this particular piece. It is a critical part of the system design and I haven’t figured out a way around it.
I receive no errors, the Label, Name and DataField all change properly (used MRI) but the data never changes. However checking BoundField (read only) I see it is still pointing to the previous data field.
I have also gone back and tried v18.104.22.168 and the results were the same.
Finally, I reloaded 4.2.8.x and again the code worked correctly.
Any ideas on how to get this working again will be greatly appreciated.