Page 1 of 1

Charts Non-Recalc

Posted: Mon Sep 04, 2017 9:08 pm
by rafaewolie
Hi,

I'm putting some charts at the top of some perspectives that are been published at TM1WEB and Contributor.

The issue is, at first time I open the application, the charts does not appear at all, I need to Recalc to show them.

Someone knows Why it happens and How Do I Solve this?

My Web Config xml is:

<add value="false" key="UseBookRecalcSetting"/>
<add value="true" key="RecalcOnActivate"/>
<add value="True" key="RecalcOnDataValidationChange"/>
<add value="True" key="RecalcOnPicklistChange"/>

Thanks.

Re: Charts Non-Recalc

Posted: Mon Sep 11, 2017 7:49 am
by st2000
Your calculation option in Excel is on automatic?
Could be done by this setting via code: https://msdn.microsoft.com/VBA/Excel-VB ... erty-excel
or in the ribbon Formula/watch out for the calculator-symbol, here in german, but might look similar in english:
EXCEL_2017-09-11_09-46-52.png
EXCEL_2017-09-11_09-46-52.png (7.25 KiB) Viewed 3108 times

Re: Charts Non-Recalc

Posted: Mon Sep 11, 2017 1:44 pm
by rafaewolie
Hi st2000,

I already Changed the Calc Options to Automatic before publishing.

But Even When I turn to Automatic, Tm1 seems to change again to manual When published.

Thanks for Your Help