We have several grids where multiple fields are in one cell. The 'Export to Excel' only exports one of them. Is there something that can be configured to allow for this?
Please note (in the attached) the address column in the grid has more information than the XLS.
Export to Excel - Multiple Fields in Cell
-
rrogulski
- New User
- Posts: 10
- Joined: Fri Jan 20, 2012 2:29 pm
- First Name: Rob
- Last Name: Rogulski
- Company Name: StoneRiver
- Contact:
Export to Excel - Multiple Fields in Cell
- Attachments
-
- Grid Example.jpg (34.58 KiB) Viewed 519 times
-
- XLS Results.jpg (36.02 KiB) Viewed 519 times
-
Scott Klement
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Export to Excel - Multiple Fields in Cell
Excel does not allow more than one field in a cell, so no, it can only export one. Profound Ui will always export the first field in a cell (based on the order shown in the 'elements' tab).
We consider this to be a "feature" because you can do some interesting stuff with it, such as having the first field in the cell be positioned so it's not visible. Then putting the data for Excel into that non-visible field. That way, you can put different stuff in the export vs. what shows on the screen. I know that several customers use this approach to customize their spreadsheets.
We consider this to be a "feature" because you can do some interesting stuff with it, such as having the first field in the cell be positioned so it's not visible. Then putting the data for Excel into that non-visible field. That way, you can put different stuff in the export vs. what shows on the screen. I know that several customers use this approach to customize their spreadsheets.
-
rrogulski
- New User
- Posts: 10
- Joined: Fri Jan 20, 2012 2:29 pm
- First Name: Rob
- Last Name: Rogulski
- Company Name: StoneRiver
- Contact:
Re: Export to Excel - Multiple Fields in Cell
I can understand the explanation but what about a situation where you may display a link in the cell, if applicable, or just the output, if a link is not applicable. The grid will not export everything shown on the screen nor what is hidden. Is there possibly a way to allow for an option on the export to export everything, creating multiple Excel rows for the same?
-
Scott Klement
- Experienced User
- Posts: 2711
- Joined: Wed Aug 01, 2012 8:58 am
- First Name: Scott
- Last Name: Klement
- Company Name: Profound Logic
- City: Milwaukee
- State / Province: Wisconsin
Re: Export to Excel - Multiple Fields in Cell
Hi Rob,
We do not have a feature for that.
If you are asking us to add a new feature, please e-mail the feature request to support@profoundlogic.com
For your example of something that's a link when applicable, or a plain output field when not... this can be done with a single widget, so there's no need to put multiple widgets in the same cell for that. You can do that by:
1) Use an output field widget for the data.
2) Bind a value (perhaps an indicator with custom on/off values) to the color and text decoration properties, so it should be a hyperlink, it shows as blue and underlined. Or alternately, use a CSS class to do the same thing. Or choose a different appearance and set the properties appropriately to achieve the look that signals your users that it is a "link".
3) Put a routine in the "onclick" for the output field that checks the indicator, and if set, uses pui.openURL() to open the link.
In that way, the same widget (which exports to Excel in either case) would be capable of acting as a link or not a link, as needed.
Hope that helps
We do not have a feature for that.
If you are asking us to add a new feature, please e-mail the feature request to support@profoundlogic.com
For your example of something that's a link when applicable, or a plain output field when not... this can be done with a single widget, so there's no need to put multiple widgets in the same cell for that. You can do that by:
1) Use an output field widget for the data.
2) Bind a value (perhaps an indicator with custom on/off values) to the color and text decoration properties, so it should be a hyperlink, it shows as blue and underlined. Or alternately, use a CSS class to do the same thing. Or choose a different appearance and set the properties appropriately to achieve the look that signals your users that it is a "link".
3) Put a routine in the "onclick" for the output field that checks the indicator, and if set, uses pui.openURL() to open the link.
In that way, the same widget (which exports to Excel in either case) would be capable of acting as a link or not a link, as needed.
Hope that helps
Who is online
Users browsing this forum: No registered users and 1 guest