- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Text Object
Hi All,
I have one requirement like .
If you can please look into my attachment . I have a straight table with only one column WHich in real time I will hide it below any other chart . and i want a text object or action button upon single clik it should give me the values on the excel sheet . (Customer ID) .
I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel.
Thanks in Advance
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
try this
=concat(CustomerID,'\n')
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I think you can do the following:
you can export the text box contente to excel. Click on the text box, then right click, press on "export to excel". In excel you will get the content in only one cell "A1". You can unstack the cell content into many cells (different columns) then you transpose it. Finally you get only one column. Hope it helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi
I want to click and it has to print all the values . Is it possible as I have to provide a action button and Need to print one fiel value in an excel .
Tahnks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How exaclty is your requirement? what is the output?
you can create an action button to export the text box content, then in excel use data transformation to get what you need in excel
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @felcar2013
If you can please look into my attachment . I have a straight table with only one column WHich in real time I will hide it below any other chart . and i want a text object or action button upon single clik it should give me the values on the excel sheet . (Customer ID) .
I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel.
Thanks .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
hi
see file