Last Updated: 29 Apr 2019 06:13 by ADMIN
Created by: Vamsi Krishna
Comments: 1
Category: Spreadsheet
Type: Feature Request
Currently, the cells which are disabled are not protected in the exported XLSX document and can be modified by the users. Implement functionality to protect the data when exporting.
Last Updated: 12 Feb 2019 14:50 by ADMIN


we have a hard time controlling the cells "Enable" attribute in a data binding scenario, because it really depends on the data, e.g. the complete Row must be read only (Enable = false) when Cell "Completed" is marked with true.

I mark this as "Feature request" because I think there is no such functionality, but I'd need some dynamic expression here, you could reuse the validation expressions, e.g.:

enable: "NOT(ISERROR(FIND(\"true\", B3)))"


As an alternative/workaround, maybe we can reuse validation / reject, so instead of making the cell non-editable, leave it editable but reject any kind of change, this is just a thought and I feel like there is no easy way to do it like this either.


You might wonder how we apply validation or enabled/disabled cells in data binding scenario; We basically run post processes after data binding, so because I think there is no other way doing it.

Best regards