Export file as Excel has sometimes [Object] in the cell... please correct

[VinceFINET]

Describe the bug
Export file as Excel has sometimes [Object] in the cell... please correct

To Reproduce
Export all details from the global view:

• 👥 Active Internal Users: "Api Enabled", "View Setup", "Modify All Data", "Customize App."

It might not be limited to this tab...

Thank you

[VinceFINET]

Need to check the same when exporting global view!
I have the following exception:

Error: Cell type is not supported for XLS export (type: object, supported  primary types: string,number,boolean), value: [object Object]
    at E (modules/orgcheck/orgcheckExportButton.js:85:48)

[VinceFINET]

That would be nice to have more information in the previous exception...
it does not help where the data is wrong, what column, row, etc...

[VinceFINET]

Need to work on how to output the dependencies which is an object right now (cause of the exception).

[VinceFINET]

"Dependencies" column in Org Check is a link to the dependencies modal, so it does not make any sense to export that column!
I should remove the column of type ColumnType.DEP from the export source then...
But the input structure in th exporter does not have the type of the column, it should be up to the exporter's caller to remove columns....
OR the other approach would be to JSON stringify any object... and remove the exception!

[VinceFINET]

issue with the JSON approach is that all of a sudden the export looks like VERY technical

and in an excel file it's pretty sure that a complex JSON structure is not helping...

for dependencies in particular that would be great to have the list of items in "using" and "referenced in"...

[VinceFINET]

Depencencies column is now split into two columns when exporting:

• List of used
• List of referenced