Cell data retaining old values - not showing new values from xml table
We have a grid which has some editable/derived columns (hence values in their cells change after load based on user input) and other non editable cells. Once loaded users can customise the grid based on preferences screen that we have provided.So users can select the columns that they want to see and change the column orders. Once user saves the preferences screen (which is a popup on top of grid screen) we are reflecting the required changes in the grid without doing any grid/page refresh. All we are doing is setting the new set of columns on XML table and grid is getting updated correctly with correct data in all columns.
Only issue is that any cell text that users might have updated before changing grid preferences is not getting rerendered again i.e. they are retaining their text and not getting the correct cell text corresponding to new column at that place.Hopefully following will make our problem clear -
Before preferences change -
after preferences change (actual) -
after preferences change (expected/desired) -
So before at index x column was Salary and user updated the cell at x,y. Then user changes the preferences and column Department starts appearing at index x,then all cell text is appearing for this new column minus the cell at x,y which was updated the user before preferences change.
We tried refreshing the column, even grid but that did not solve the problem. Refreshing the page will offcourse work but that will be unacceptable to business.
We tried digging in and found that getCellValue/Data actually gives correct value that is HR. But getcellText is 160000.
Please suggest are we going wrong.Or, suggest some workarounds.
Once a cell gets edited it tends to retain its text even after subsequent grid refreshes. I have verified that the underlying XML table contains the correct values.
Any help appreciated.
This topic is archived.
Back to support forum
Version 2Looking for AW 2.6 ?
The old site is here.