@= in active sheet formula

Post Reply
MarenC
Posts: 56
Joined: Sat Jun 08, 2019 9:55 am
OLAP Product: Planning Analytics
Version: Planning Analytics 2.0
Excel Version: Excel 2016

@= in active sheet formula

Post by MarenC » Mon Dec 02, 2019 4:32 pm

Hi,

We are seeing some strange behaviour in excel active forms. When we put in a formula and use a function it is inserting an @ symbol, so for example we see,

=@TM1RPTROW($E$10,.....)

Anyone come across this before?

Maren

Wim Gielis
MVP
Posts: 2322
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: @= in active sheet formula

Post by Wim Gielis » Mon Dec 02, 2019 11:23 pm

Hello,

A customer of mine reported it to me. He didn't see any adverse effects so we left it as is.

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

dymoy
Posts: 16
Joined: Mon Dec 08, 2008 8:36 pm

Re: @= in active sheet formula

Post by dymoy » Mon Jan 06, 2020 11:47 pm

Apparently Microsoft recently added that to their latest Excel upgrade patch and it's "The implicit intersection operator was introduced as part of substantial upgrade to Excel's formula language to support dynamic arrays". A link to their support page: https://support.office.com/en-us/articl ... c999be2b34.

We have noticed that the @ is affecting any uploading, particularly with AWS. Other than that, no noticeable issue. A ticket was opened with IBM by ACG.

Wim Gielis
MVP
Posts: 2322
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: @= in active sheet formula

Post by Wim Gielis » Tue Jan 07, 2020 8:04 pm

Thank you, that's useful knowledge.
I wonder when Microsoft is going to roll out those new functions to those who are not part of the Insiders program. Like 99% of the Office 365 population probably.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply