topic Re: Export with formatting generates Excel table with black background in App Development

Export with formatting generates Excel table with black background

francesco_menin — Thu, 16 Mar 2023 08:41:37 GMT

Hi all,
I'd like to share with you a question regarding the Data Export with Formatting.

We recently upgraded a customer from Nov 21 version to Nov 22 version last patch and we are experiencing some issues with a single application when doing export data to excel with formatting.

The source straight table looks pretty much ok:

and we left the default blank values for background colors as was before the upgrade

now when the export is done we get this result

So it looks like there is something off in the definition of the app itself which we cannot identify.

Doing the same on a different app (no changes as this one) gets the correct result.

What might be missing with this app?

Thanks

Re: Export with formatting generates Excel table with black background

francesco_menin — Thu, 16 Mar 2023 08:53:59 GMT

So double checking again the options we switched back to a default theme and it looks like everything is fine:

Any ideas as to what kind of setting we need to look into?

Re: Export with formatting generates Excel table with black background

francesco_menin — Thu, 16 Mar 2023 09:45:49 GMT

we found the culprit in a JSON setting: this highlighted property was set up as rgba(255,255,255) which was doubly wrong by missing a parameter and being misinterpreted by Excel itself, so we switched back to a simpler hex code