Minimized Object

[nihhalmca]

Hi All,

I want to minimize chart object even though if user double click on object it will not maximize. I tried through properties--> Caption--> unchecked 'Allow maximized' option. But not working this way, please share if you know.

Thanks in Advance,

Nihhal.

[stevedark]

What reason do you wan to keep the chart minmized for for?

If it is so the chart can be used in a report or something I would add a new tab for this chart, and any other objects for reports, and then set the show condition on that tab to false (or have a variable so you can toggle the show of this).

If it is so you can view the text in the caption of the chart, just use a text box instead.

Hope that helps,

Steve

[arulsettu]

check if auto minimize is enabled? i think...

[nihhalmca]

Hi Steve, Thanks for your reply

Actually my requirement is, i want to make a chart for just send to excel data (not Macro) will not show object in sheet.

[nihhalmca]

HI Arul,

No I checked.

[#6]

Hi Nihal,

Unfortunatelly its not possible, instead you try to use condition to show or hide the object.

thanks,
Selva

[#7]

Then You try serverside export using macro..

sub Export

set ch=ActiveDocument.GetSheetObject("CH706")

ch.ServerSideExportEx "C:\ChartExport.xls",";",5

end Sub

Add the Macro trigger action in  a text box or Button..

Note: exported Excel will be available only in the server machine..may be you can create the shared folder in the server machine and distribute it accordingly...

Thanks,

Selva

[stevedark]

In that case, what you should do is create a new tab and move the chart to that tab.  You can then set the show condition on that tab to False (1=0), but still refer to it in your export code.

If you are presently getting the user to right click on the minimised icon, you will need to replace this with a button (or text box) with an Action to do the export.

To make it so that you can get to the hidden sheet to make changes either use Ctrl+Shift+S or use a variable (I use vShowDev) and set that to either 1 or 0 and set the show condition to:

=vShowDev = 1

Hope that helps,

Steve

[#9]

Hi,

U can try changing X-pos, Y-pos , height ,width so that the object size reduces to the size of minimized object.

This does not maximize object even after double click.

HTH

-Shruti

[#10]

Hi Nihhal,

Please check if this meets your requirement

Thank you

Vardhan