Don't want non-visible textboxes to appear in CSV output

Progress® Telerik® Reporting Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Unplanned

Last Updated: 14 Feb 2024 11:35 by Steve

Jim

Created on: 29 Apr 2020 18:13

Type: Feature Request

Don't want non-visible textboxes to appear in CSV output

Hello,

I see from support threads that Telerik really resists any changes to their concept of CSV rendering. And I also understand the reasoning in not changing any default behavior due to its potentially unwanted effect on established customers.

That said, I wonder if the ability to exclude hidden objects (TextBoxes for example) has been proposed and is in the list of potential enhancements. I wouldn't mind if it required a configuration setting like NoHiddenObjects = True where the default is False.

Has that been considered?

Duplicated Items

CSV render output control

5 comments

Steve

Posted on: 14 Feb 2024 11:35

Hi everyone,

I think that it might be best to keep the current functionality of the Visible property as only affecting the output in visual display formats - and have other means to control the rendering of data formats like CSV.

I have added a more detailed comment to my duplicate request - see "Duplicated Items" above.

Shruthi

Posted on: 14 Feb 2024 10:01

I am facing the issue where textboxes with Visbile = false are displayed in csv exports. i believe its the same issue raised here. Do we have an update on this issue.

ADMIN

Elena

Posted on: 07 May 2020 07:46

Hi Jim,

It sounds like the problem you're experiencing is very frustrating. I understand your reasoning and completely agree that the experience can be improved. I've made this feature request public so that other users who have requested it can vote and speed up the process for prioritisation -> planning -> implementation.

Meanwhile, I really want to help you by providing a workaround that you can take into consideration. I'm sorry my previous comment isn't relevant to your situation. There are other suggestions like using table group filters or hiding the whole column in the CSV export programmatically. If you'd like, you can open a ticket with your specific report and we can try to achieve something similar to the desired behaviour, for the time being.

Thank you for your patience!

Regards,
Elena
Progress Telerik

Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.

Jim

Posted on: 06 May 2020 15:10

Elena,

I believe you have missed the point of this request. The situation involves a textbox with a value (which is essential for producing the result I need), but whose .Visible property is False. I do not want to change the value of the textbox, I just want it to be not included in the CSV output -- i.e., I do not want the textbox to render as an empty column in the output. I need to apply the same ability to XLSX output.

Is that a clearer explanation?

Thanks.

ADMIN

Elena

Posted on: 06 May 2020 07:49

Hi Jim,

We've added a relatively new functionality that gives you the type of the rendering format during the processing of the elements. You can try setting the value expression of the hidden textbox to something like this: = IIf(RenderingFormat.Name = "CSV", "", "my value"). The "" will set the value to an empty string only if the rendering format is CSV. For the rest of the formats, you can keep "my value" (or replace it with a custom nested another logic that hides and shows the textbox).

Regards,
Elena
Progress Telerik