►
From YouTube: Office Add-ins community call-September 2020
Description
This month's call, hosted by Alex Jerabek, featured how to do two-way messaging with dialogs in addition to some new PowerPoint APIs and the PowerPoint API roadmap. Plus a community demo by Infor on the Infor d\EPM’s Office add-in features and their experience building on the Office add-in platform.
Microsoft speakers: Lillian Liu and Amit Mohindra
Info speakers; Nick Gladkov, Vit Holy, and Volodymyr Onyshchuk
A
Welcome
to
the
microsoft
office,
add-ins
community
call
for
september
9th.
This
is
the
call
where
we'll
share
everything.
That's
new
in
the
world
of
office,
add-ins
and
office
extensibility
get
a
lot
on
the
call
today
we're
going
to
talk
about
the
new
dialogue
apis,
some
news
about
the
new
powerpoint
apis
that
are
coming
out
and
we're
going
to
have
a
customer
story
and
demo
from
infor
depm.
A
So,
let's
get
started.
Please
remember
that
this
call
is
being
recorded,
we'll
post
this
on
our
developer
channel
later.
So
please
keep
your
microphones
muted.
If
you
have
a
question
feel
free
to
type
in
the
chat.
You
know,
we've
got
members
of
the
product
team
on
the
call
as
well
to
answer
your
questions
as
we
go
along
and
we'll
do
a
little
q
a
wrap
up
near
the
end,
but
first
of
all
our
presenters
for
the
day,
but
we
have
a
little
special
announcement
about
microsoft,
ignite
so
dana.
Do
you
want
to
talk
to
this.
B
B
The
session
scheduler
will
be
live
tomorrow
on
september,
10th
and
you'll
be
able
to
start
adding
sessions
after
you're
registered
for
that
live
portion
and
then,
in
addition,
we
are
launching
what
we're
calling
the
virtual
hub,
where
there
will
be
content,
conversation
and
connections,
and
it
will
have
links
and
information
on
deep
dive,
technical
trainings
and
for
it
pros
developers
champions
whatever
you
are
interested
in,
and
it
will
be
across
a
variety
of
topics.
We'll
have
a
lot
on
the
microsoft
365
and
teams
platform
on
the
developer
side.
B
A
Awesome,
thank
you.
Dana
yeah
and
we'll
have
a
couple
office.
Add-Ins
specific
sessions
there
so
be
sure
to
check
out
the
scheduler.
If
you
have
any
questions
that
you
want
to
bring
to
the
the
product
team
they'll
be
there
as
well,
so
without
further
ado,
let's
hop
into
the
call
proper,
so
we're
gonna
start
off
with
the
new
dialogue
apis
and
lillian.
Are
you
ready
to
talk
to
us
about
these.
C
Yeah,
hey
everyone,
so
my
name's
lion,
I'm
a
program
manager
on
the
team
and
I
specialize
in
ux.
So
today
I
wanted
to
talk
to
you
guys
about
message
child.
So
this
is
a
dialogue
api.
So
traditionally,
we've
had
an
api
called
message:
parent,
which
allows
a
dialogue
to
talk
to
your
taskbane
parent.
C
However,
we
never
had
the
reverse,
so
we
never
had
that
full
loop
and
what
that
meant
was.
If
you
wanted
to
communicate
back
to
your
dialogue,
you
would
have
to
go
through
other
channels
and
one
of
the
common
ones
was
through
local
storage.
C
So
we've
had
a
lot
of
feedback
on
this
about
the
importance
of
actually
having
a
two-way
messaging
channel.
So
we've
now
implemented
the
the
inverse
so
we're
we
have
mrs
child,
and
it
is
currently
ga
it
is
now
part
of
the
dialogue.
The
dialogue,
api
requirements
set
1.2.
C
So
here
I've
just
got
some
more
info
on
the
shape
of
the
api
and
also
the
parameters.
So
essentially
it
accepts
a
string
and
and
doesn't
return
anything
so
anything
that
you
can
serialize
can
be
sent
and
so
yeah
and
I've
just
got
some
resources
here.
For
how
you
use
it,
so
we
have
a
few
sections
and
the
dialogue
documentation
that
walks
you
through
how
to
set
this
up
and
then
also
I've
got
the
availability
of
1.2,
so
on
desktop.
C
A
Any
questions
toss
in
the
chat,
lillian's
gonna,
stick
around
on
the
call
and
answer
them
and
paste
those
links
in
there
as
well.
So
yeah
encourage
you
to
try
it
out
visit
our
documentation
for
the
the
new
samples,
and
this
is
nga
so.
A
D
Yes,
I'm
here.
Thank
you
alexander
hello,
everyone.
My
name
is
honor
and
I'm
a
senior
software
engineer
here
in
powerpoint
extensibility
team,
I'm
here
with
amit,
he's
a
principal
program
manager
in
the
team
and
today
we'll
briefly
talk
about
some
of
the
feature
plans
for
powerpoint
officejs
accessibility
story
and
give
you
a
quick
demo
for
the
first
api
we
have
in
the
private
preview
when
we
started
this
journey.
So
we
had
some
research
and
contacted
some
of
the
add-in
developers
for
powerpoint
and
we
asked
about
their
take
their
feedback.
D
We
mainly
tried
to
understand
their
scenarios
so,
based
on
this,
we
came
up
with
these
buckets,
which
we
try
to
find
the
most
frequently
used.
Add-In
scenarios.
The
most
common
operations
were
around
slide
level,
manipulation
and
the
most
common
one
along
those
was
inserting
a
slide
from
an
external
source.
D
D
So
we
decided
to
have
this
scroll,
walk
and
run
approach
where
we
start
small
but
gain
momentum
as
we
expose
more
functionality
and
we
gather
we
can
gather
feedback
as
we
go
along.
We
possibly
change
directions
if,
if
needed,
so
with
this
in
mind,
we
started
with
an
api
that
allows
adding
developers
to
insert
slides
from
other
presentations,
we'll
see
a
live
demo
on
this
shortly.
The
next
set,
which
is
also
currently
in
development,
is
about
the
slide
level
operations
like
enumerating,
adding
new,
slides,
deleting
slides.
D
Then
we
will
be
focusing
on
shape
level
operations,
which
is
much
more
deep
and
has
many
more
branches
like
text
bodies
and
properties.
So
we
would
like
to
go
through
this
journey
with
our
users
and
developers.
We
would
be
really
appreciative
to
gather
your
feedback
throughout
this,
so
some
of
the
things
we
start
showing
today
might
change,
depending
on
the
feedback
we
receive
and
keeping
this
in
mind.
D
Let's
get
to
a
quick
demo
on
this,
so,
as
I
mentioned
before,
this
is
going
to
be
about
inserting
slides
from
other
presentations
for
this
purpose,
I'm
going
to
use
powerpoint,
online
and
scriptlab
to
demo
to
api.
Here
I
have
inserted
four
slides,
but
before
before
we
start,
I
want
to
make
sure
that
you
can
follow
me
better.
So
I
have
also
written
down
the
slide
ids
of
these
slides
into
them.
So
powerpoint
uses
some
identifiers
to
keep
and
distinguish
slides.
D
One
common
identifier
is
the
slide
id,
and
this
is
coming
from
the
old,
visual
basic
for
applications
model.
We
might
even
have
some
desktop
application,
add-in
developers
here,
who
might
already
be
familiar
with
this
concept,
but
there's
also
an
extension
to
this
code,
like
creation
id,
which
I
will
touch
soon,
but
you
will
be,
you
will
all
be
able
to
get
these
through
slide
level.
Apis,
we
will
publish.
Usually
an
add-in
developer
does
not
need
to
know
or
tackle
with
these.
You
just
get
it
through
the
apis
and
use
them
directly.
D
So
I
have
the
I
have
forced
my
four
slides
here.
I
have
the
script
lab
pane
here
and
in
the
in
the
code
side
of
the
script
lab,
I
have
some
little
content,
which
is
actually
just
a
file
input
box
which
looks
like
as
it
acts
like
a
system
file
picker
dialog
from
the
user,
so
that
we
can
specify
the
presentation
we
want
to
insert
and
in
the
script
side
of
things
we
have
some
boilerplate
code
to
take
that
file
and
create
it
base64
encoded
version
of
that
file
in
a
string
here.
D
So
the
interesting
piece
here
is
that
we
call
powerpoint.run
using
a
presentation
that
insert
slice
from
base64
the
only
required
parameter
here
is
a
string
of
the
string
based
representation
of
the
presentation
we
want
to
insert
in
base64
encoded
format.
So
if
I
just
run
this
call
and
go
back
to
my
script
pane
here,
I
can
choose
a
file
and
I
have
prepared
some
color
coded
percentages,
so
we
can
differentiate
those.
So,
for
example,
I
can
choose
a
blue
presentation
to
be
inserted.
Then
I
can
see
that
presentation
slides
are
inserted
into
my
deck
nicely.
D
D
You
should
be
able
to
see
those
slides
are
inserted
into
my
tag
properly
going
back
to
the
code.
There
are
also
we
also
support
some
optional
parameters
here.
The
good
thing
about
this
is
the
second
parameter.
Here
is
actually
a
key,
an
object
which
contains
a
key
value
pairs
of
optional
parameters.
D
The
the
nice
thing
about
this
is,
we
can
add
additional
optional
parameters
in
the
future,
while
extending
to
functionality,
we
can
keep
the
backwards
compatibility
there.
So
one
of
the
parameters
that
I
want
to
talk
about
is
the
formatting
option.
We
can
give
use
destination
theme
or
keep
source
formatting
as
similar
to
how
paste
works.
The
keep
source
formatting
is
the
default
option
and
I'm
going
to
demonstrate
a
use
destination
team
this
time
to
use
the
existing
team
as
the
input.
D
Going
back
to
code,
another
parameter
I
would
like
to
talk
about
is
the
target
slide
id,
which
is,
is
the
position
of
the
of
the
slides
that
I
want
to
insert
in
this
parameter.
I
can
give
a
slide
id,
which
I
have
mentioned
earlier,
along
with
the
creation
id
for
my
creation
id,
which
is
kind
of
in
this
format,
but
I
don't
have
to
provide
creation
id
here
or
if
I
don't
want
an
exact
match
basically,
but
I
will
show
an
example
detail
on
that
in
a
second.
D
So,
for
example,
in
this
version
I'm
saying
we
should
insert
this
presentation
into
into
the
point
position
after
slide
257
in
my
text,
so
I'm
going
to
expect
it
to
appear
right
here
so
going
back
to
the
demo.
Let's
choose
another
file,
this
time
like
to
read
presentation,
and
now
I
can
see
that's
added
after
slide
257
here.
D
D
D
And
yes,
those
two
slides
are
inserted
at
this
point,
I
can
also
try
to
explain
a
bit
on
the
creation
ids,
so
I
extracted
the
creation
ids
of
the
document
that
I
just
showed
earlier.
I
can
also
write
this
down
exactly
as
it
is,
or
can
I
can
omit
the
slide
id
part
here.
This
should
work
exactly
identical
to
the
previous
case.
So
if
I
do
the
same
thing
again,
I'm
going
to
get
those
258
and
259
again
without
any
problems.
D
So
the
last
example
I'm
going
to
talk
about
will
be
of
combination
of
all
these
parameters.
D
D
And
there
they
are
so.
This
is
all
we
would
like
to
show
you
today
a
glimpse
of
what's
coming
up
as
you,
as
you
mentioned
before,
we
appreciate
any
feedback
you
made
have
for
us.
Thank
you
very
much
for
listening.
If
you
have
any
questions
feel
free
to
post
them,
and
this
is
all
thank
you,
alexander.
A
D
D
We
we
will
be
going
to
to
public
preview
public
data
soon
and
throughout
our
documentation
and
throughout
the
documentation,
link
link
of
this
presentation.
I
will
provide
the
right
channel
to
send
us
the
feedback.
A
Okay,
thank
you.
I'm.
It
is
a
principal
program
manager
on
the
powerpoint
extensibility
team.
So
yeah
can
answer
your
questions
very
good
and
respond
to
your
feedback.
So
yeah.
Please
keep
sharing
the
scenarios.
You
have
we're
interested
not
only
like
the
apis.
You
need
but
like
what
you're
trying
to
enable.
So
we
can
kind
of
think
about
this
holistically
and
try
to
help
as
many
people
as
possible,
so
yeah.
Thank
you
very
much
and
if
you
have
any
questions,
please
type
in
the
chat.
Okay.
A
So
now
I
believe
next
up
is
infor,
so
let
me
share.
Do
we
have
the
infor
people
on
right
now
ready
to
go?
Yes,
I'm
still
looking
all
right!
Nick
yeah.
Do
you
want
to
take
it
away
and
share.
E
E
E
I
am
working
with
performance
management
area
with
things
around
budgeting
and
planning
performance
management
reporting
and
everything
around
that
where
excel
traditionally
is
still
being
probably
the
most
popular
tool
doing
these
tasks
ever
so
it
doesn't
matter
how
many
performance
management
tools
that
we
have
on
the
market
still
excel
being
more,
probably
the
most
popular
and
the
most
powerful
tool
for
for
the
key
finance
users.
E
E
Just
because
we
cannot
replace
it,
we
really
need
to
work
together
with
excel
and
that's
probably,
what
will
be
the
focus
for
today's
call
as
well,
where
we
will
talk
about
how
we
continue
working
together
with
microsoft,
excel
in
a
way
of
improving
our
own
product
by
working
together
with
microsoft
tools,
we
also
have
vit
holy
he's
a
product
owner
of
excel
interface,
I'm
working
together
with
n4dpm
too
and
vit
is
the
key
person
who
is
driving
all
the
ideas
and
other
new
features
into
that
product
and
he's
working
with
microsoft
teams
for
around
four
years
now,
as
you
will
see
in
a
second
and
finally,
we
have
vladimir,
who
is
our
senior
ux
designer,
and
he
will
share
his
experience
working
with
excel
from
the
perspective
of
creating
the
beautiful
ui
for
the
end
users,
which
is
honestly
a
little
bit
new
task
for
us
compared
to
the
old
excel
add-ins
that
we
had
around
30
years
ago.
E
So
that's
it's
a
planner,
that's
our
team
that
will
cover
these
topics
today
very
quickly.
I
don't.
I
don't
plan
to
spend
a
lot
of
time
on
on
on
slides,
not
a
fan
on
the
slides.
So
it's
more
about
the
live
demonstration,
so
I
will
cover
the
what
is
info.
What
is
in
for
the
apm?
E
How
do
we
work
with
excel
and
how
we
were
working
with
excel
before
and
then
I
will
switch
to
quick,
live
demonstration
of
our
current
excel
integration
product
and
then
same
will
continue
with
with
his
part
of
the
life
demonstration,
and
we
will
switch
to
vladimir
to
also
speak
about
the
ux
and
ui
and
then
we'll
come
back
to
it
just
to
finalize
and
kind
of
have
a
summary
of
where
we
are
today
so
info
in
four,
it's
a
kind
of
a
hidden
company
which
is
actually
quite
large.
E
So
we
have
almost
20
000
employees
worldwide
and
we're
working
with
key
companies
in
all
of
the
industries,
and
it's
just
a
quick
slide
where,
whatever
industry
you
choose,
you
will
always
see
different
info
products.
E
It's
not
only
performance
management,
so
we
have
plenty
of
other
solutions.
You
might
heard
about
info
lan
in
4m3
or
ban
on
the
whole
name
of
lm
some
systems
and
then
many
many
many
other
products
again.
We
don't
want
to
speak
about
that.
We
also
quickly
share
that
we
have
plenty
of
customers
and
again
I
don't
want
to
sell
info
today,
it's
more
about
that.
E
It's
a
large
company
that
are
working
with
a
big
big
number
of
customers
worldwide,
all
around
the
world
with
different
countries
with
the
epm.
That's
probably
more
relevant
information
over
here,
and
I
can
quickly
say
that
the
company
was
based
about
30
years
ago,
where,
from
the
start,
maybe
working
with
excel
again
about
almost
31
years
ago.
It
was
in
november
or
end
of
october
1988..
E
What
is
important
here
is
that
from
2015
we
started
to
look
how
we
can
redesign
the
whole
product,
not
just
one
component
but
the
whole
thing
in
a
new
services
architecture
vision,
because
we
wanted
to
support
the
modern
way
of
how
technologies
works.
We
want
to
know
how
we
want
to
be
able
to
work
with
the
cloud
and
kind
of
with
that
message.
Also,
we
started
to
look
into
excel,
so
in
2016
we
started
to
build
a
new
first
product
types
of
working
with
javascript
api
and
how
depm
can
work
together
with
excel.
E
E
We
will
continue
developing
the
excel
integration
for
jpm
and
we
did
a
lot
of
beta
versions
and
customers
we're
working
with
the
divergence
in
2018
19.
Until
earlier
this
year,
we
released
excel
integration
as
a
ga
version.
So
that's
what
we
are
again.
I
will
show
you
today
in
terms
of
the
past
what
was
before
2016
we
had
this
excel
add-in,
which
was
based
on
on
the
visual
basic
and
a
lot
of
other
programming.
E
We
were
really
kind
of
hacking,
microsoft
excel
in
unsupported
way,
or
it
was
a
supported
way,
but
it
was
not
a
native
way
of
working
with
with
excel
and
we
were
using
this
excel
interface
for
everything
we
were
doing
the
modeling
of
the
customer
models.
They
were
creating
cubes
dimensions
rules,
they
were
doing
the
ad
hoc
reporting,
they
were
doing
the
proper
development
and,
as
a
matter
of
fact,
my
project.
E
My
first
project
about
16
years
ago,
was
a
based
on
the
visual
basic
development
together
with
dpm
and
excel,
and
we
had
some
issues.
We
had
no
way
working
with
web.
We
had
no
way
of
having
this
same
interface,
for
windows
and
for
mac.
It
also
means
this
hacking
meant
that
every
time
microsoft
was
releasing
new
features
and
new
versions,
we
had
to
be
kind
of.
E
Quite
I
would
say
I
don't
know
creative
to
find
a
new
way
how
we
can
put
all
the
old
features
in
the
new
world
of
excel
so
and
also
it
kind
of
looked
from
20th
century
and
not
and
not
as
a
modern
application.
E
So
that's
why
we
looked
on
all
these
use
cases
where
the
customers
were
doing
the
reporting,
the
analysis
watching
complaining
and
modeling
and
said:
let's
keep
it
more
simple
and
maybe
removed
the
modeling
okay
and
it's
not
development
tool,
it's
the
end
user
and
who
is
a
business
user
and
they
are
not
technical
and
we
want
to
focus
on
the
normal
end,
user
tasks,
approaching
analysis
and
budgeting
and
planning.
E
So
that's
how
the
new
excel
integration
started
around
four
or
five
years
ago,
and
the
whole
idea
was
about
using
the
latest
features
of
excel
working
directly
with
microsoft
team
and
again,
we
probably
will
mention
that
we
are
working
with
your
team
for
a
long
time
also
easy
maintenance
updates
and
we
have
more
platforms,
mac
windows,
integration
with
web
new
ui,
which
looks
quite
cool,
and
we
will
talk
about
this
today
as
well.
E
So
that's
just
a
very
quick
introduction
of
what
we
are
doing
today
and
how
we
get
where
we
get
and
I
will
spend
another
minute
or
so
on
the
live
demonstration,
what
we
achieved.
So
what
we
have
is
just
a
normal
excel
and
I
started
with
some
simple
template
of
budgeting
and
planning
example.
Where
a
company
who
sells
tiles
they
want
to
understand
what
will
happen
in
the
next
budget
for
the
next
year.
They
have
some
information
about
the
previous
year
or
previous
two
years
in
that
example,
what
is
my
budget
for
this
year?
E
What
is
the
percentage
of
the
change
and
some
other
excel
features
to
show
this
in
the
nice
and
visual
way?
What
is
important
is
I
had
my
whole
budget
for
each
month
and
ability
to
comment
and
do
some
other
things
like.
I
can
change
the
analysis
dimensions
and
see
whether
I
do
this
for
the
sales
volume
or
for
the
price
or
for
the
revenue
for
the
whole
company
or
for
the
department.
Let
me
reload
just
to
make
sure
that
I
still
have
a
connection.
Yes,
I
do
that's
good.
We
have
a
pain
here.
E
E
I
can
also
enable
right
back
mode,
and
I
can
do
some
cool
things
I
can
say
I
want
to
copy
my
actual
values
from
the
last
year
and
this
will
be
sent
to
the
olap
cube,
and
I
will
copy
that
column
to
that
column.
I
could
say
just
copy
that
column,
but
it's
cool
when
I
go
to
the
all
up,
something
is
happening
in
the
whole
cube
and
behind
the
scene,
and
then
it's
getting
back
to
the
screen
over
here.
I
can
also
do
some
other
things
where
I
can
say.
E
E
So
some
of
the
features
that
every
single
finance
controller
on
earth
will
love
and
they
will
say,
yeah,
that's
exactly
what
I
need
and
that's
where
that's
what
we
are
doing
today
and
today
with
excel
yeah
integration
also
can
do
the
text
values,
but
this
problem
doesn't
really
matter
for
this
call
today,
that's
very
quick
summary
of
where
we
are
today.
E
F
Sure
let
me
share
my
screen,
hello,
everyone
so
so
before
I
I
will
start
I.
I
will
just
quickly
tell
you
that
I'm
working
with
the
excel
api
for
more
than
10
years,
I
was
working
with
sdk
com
and
primary
interop
assemblies,
also
with
vsto,
and
also
the
old
ad
in
the
office
plus
one
was
using
even
sheet
macro
functions,
so
so
all
of
that
technologies
all
technologies
were
used
there.
F
Now
we
turned
to
the
new
api,
the
office
add-ins
and
I
must
say
it's
a
quite
good
experience,
especially
with
with
the
support
from
microsoft,
but
let
me
show
you
our
application.
So,
first
of
all,
this
is
a
development
environment,
but
it's
running
on
cloud,
so
we
are
using
amazon
for
that.
So
I
pick
a
tenant.
I
have
here
one
predefined
and
I
will
just.
F
Connect
and
what's
happening
is
that
we
now
are
in
navigation
page.
All
of
these
items
are
now
inside
pane.
We
are
planning
to
move
them
to
ribbon,
but
first
we
are
waiting
for
some
some
things
to
do
to
get
supported,
but
I
will
talk
about
it
a
bit
later
for
now
what
I
wanted
to
show
you
is
ways
how
to
get
the
formulas
into
the
sheet.
So
there
are
a
couple
of
ways.
F
One
is
that
you
will
do
some
horizontal
elements,
for
instance,
when
you
want
rows
then
or
columns
in
this
case
it
will
be
columns.
So
so
I
can
just
select
some
items
and
press
it.
It
will
generate
the
the
elements
from
the
olap
cube
similarly
vertical.
F
Similarly,
we
can
at
one
value
and
so
on,
but
it's
it's
something
you
would
do
when
you
really
want
some
customized
report.
The
main
story
here
is
that
if
you
want
to
do
some
analysis,
some
other
analysis
for
for
that
we
have
other
tools,
but
we
are
planning
to
support
them.
Also
natively
in
the
excel.
F
For
now
I
need
to
switch
to
our
self-service
application.
It's
a
web-based
application
where
you
can
actually
do
any
analysis
you
want.
I
don't
want
to
bother
you
with
the
background
here.
If
you
are
interested,
you
can
find
more
details
in
in
four
pages,
but
let's
say
I
want
to
show.
I
want
to
focus
on
europe
because
I'm
from
czech
republic,
so
so
let
me
select
elements
for
the
region
and
I
will
select
europe
and
I
will
select
multiple
items
and
I
want
just
europe
and
some
of
the
countries
nearby.
F
So
let's
have
it
like
this
and
I
don't
want
all
tires.
I
I
want
a
specific
level
so
so
I
will
select
level
tire
and
again
it
should
update,
and
I
want
to
compare
budget
and
actual
so
so
I
will
select
elements
not
variants,
but
these
two
and
and
how
to
get
this
report
into
the
excel
quickly
that
that
was
our
goal.
F
We
were
thinking
initially
that
we
would
have
here
some
kind
of
export
when
we
would
put
our
ad
in
into
the
excel
workbook
and
that
workbook
would
be
opened
and
so
on.
But
we
realized,
then
that
actually
it's
not
a
really
flexible
solution,
because
then
we
have
one
workbook
per
one
report.
F
So
we
we
copy
the
report
definition
and
what
we
can
do
is
that
we
are
just
going
to
the
sheet
and
we
will
use
this
self
service
report
to
to
get
it
there.
Here.
We
have
some
options
to
have
it
enabled
with
the
right
back
or
or
without
right,
back
right
back
means
that
I
can
type
the
values
in
the
spreadsheet
and
it
will
get
into
the
database
as
it
was
already
shown
by
nick.
F
F
This
can
be
slow
so
so
far
that
you
know
because
of
the
automatic
calculation,
if
you
have
really
large
report
every
time
you
type
the
value
the
report
is
being
recalculated
for.
For
that
reason,
we
implemented
a
special
way
how
to
handle
the
solution
with
the
manual
calculation.
F
So
actually
I
can
go
here
and
type,
for
instance
1000
everywhere,
and
if
I
recalculate
it
should
get
into
all
of
them.
You
see,
I
have
everywhere
still
the
formulas.
Speaking
about
development.
I
mentioned
that
it's
a
quite
different
story
of
it
with
the
office.js
and
that's
because
microsoft
development
team-
it's
you
know
when
we
started
four
years
ago.
F
It
was
a
bit
hard
because
there
were
some
proofs
of
concept
at
the
time
being,
I
was
speaking
with
the
michael
sounders,
who
left
the
company,
if
I'm
not
mistaken,
and
the
api
from
microsoft
were
not
really
huge.
Let's
say
there
were
many
things
missing.
For
instance,
there
were
no
custom
functions,
so
we
had
some
workaround
solution
using
a
native.
F
G
Ed,
my
name
is
vladimir
and
are
working
as
a
ux
designer
in
infor.
I've
been
into
development
of
this
dpm
plugin
for
the
last
two
years
and
we
went
through
hundreds
of
ideas
and
design
solutions
on
our
way.
Our
plugin
is
all
about
working
with
the
remote
data,
and
the
amount
of
the
data
can
be
huge,
so
we
need
to
partially
cope
with
it
within
the
limited
area
of
the
plugin.
G
One
of
the
solutions
to
do
this
is
to
always
show
only
relevant
data
to
the
selection
user.
Does
we
provide
only
the
information
the
user
needs
to
use
now
and
our
interface
adapts
in
response
throughout
the
working
process,
when
vit
can
click
on
different
cells,
the
report,
the
plugin,
going
to
be
changing
and
showing
yes
different
data
other
is
to
squeeze
more
into
this
plugin.
G
G
To
I
wouldn't
say
that
everything
went
smooth
on
our
way
and,
in
the
beginning,
we're
almost
every
day
faced
with
some
limitations
and
features
that
bounded
our
ideas,
and
I'm
happy
to
see
that
now
after
two
years,
it's
quite
rare
that
we
have
to
fit
somehow
design
solutions
or
avoid
obstacles,
but
still
we're
patiently
waiting
for
some
features
to
be
implemented
like
setting
the
width
of
the
plugin
by
the
code
and
not
by
the
user,
or
to
improve
top
ribbon
functionality
to
have
enabling
disabling
showing
hiding
elements
with
it,
we
would
be
able
to
deeper
integrate
our
product
into
the
excel
itself.
G
Thank
you.
Veed.
F
It
would
be
really
nice,
for
instance,
to
get
a
possibility
to
define
a
minimum
width,
because
right
now
a
user
can
create
really
small
width
and
then
the
ui
is
not
really
looking
very
well
but
or
it's
looking
very
well
compared
to
what
we
have
available
here.
You
know,
but
also
there
are
some
other
things
I
would
like
to
mention.
For
instance,
storing
the
credentials
like
in
browser
would
be
really
nice
feature
to
have
there,
maybe
shared
authentication
between
the
workbooks.
F
Similarly,
as
it
is
on
mac
where
the
cookies
are
being
shared,
but
with
the
edge
webview,
it's
not
shared.
However,
all
of
that
is
being
handled
with
microsoft
and
microsoft.
Team
does
really
great
job
here
I
would
say,
because
whenever
we
have
some
problem
or
some
issue,
they
they
try
to
help
us
they.
They
help
us
to
really
succeed.
So,
for
instance,
we
are
requiring
some
api
for
for
improving
our
edit
ui,
like
the
precedence,
so
so
it
was
discussed
on
quite
deep
level
with
the
microsoft
guys.
F
Similarly,
for
the
right
back
scenarios,
there
are
some
some
improvements
which
we
need
to,
for
instance,
support
copy
paste
of
the
values
to
the
database
and
and
so
on.
Also
there
were
some
initial
issues
with
the
deployment
of
the
let's
say,
because
we
are
using
multi-tenant
cloud.
F
It
was
then
resolved
using
centralized
deployment
again,
it
was
provided
by
microsoft,
so
so
so
great
job
there.
Also.
What
I
like
is
the
communication
level
with
the
guys,
especially
kr
and
and
raymond
they
do
really
great
stuff
there,
and
for
that
I
think,
that's
all
from
our
site.
Maybe
if
you
have
some
questions.
A
Yeah,
thank
you
so
much
bit
and
yeah.
Thank
you
all
for
for
sharing
your
story
and
not
just
the
add-in,
but,
like
your
experience
developing
it,
I
mean,
I
think
we
have
plenty
of
time
for
for
questions
in
the
chat
I
just
want
to
ask
like,
since
there
are
a
lot
of
developers
on
this
call,
is
there
any
advice,
you'd
give
them
as
they're
starting
to
develop
their
own
add-ins
or
working
on
their
own
add-ins.
F
Definitely
they
should
take
a
look
on
script
lab
also
the
pnp
samples
that
that's
pretty
cool
idea
to
start
with
the
samples
and
learn
to
through
the
practice
start
developing
immediately,
not
reading
just
writing
the
code
and
playing
with
that.
That
would
be
my
advice
and
whenever
they
have
problem
reach
the
microsoft
they
are
really
open
in
github.
A
Awesome
yeah:
we
we
try
to
respond
to
through
github
the
office.js
repo.
Is
there
if
you
have
issues
or
user
voice.
I
know
onr
was
mentioning
that
for
the
powerpoint
apis,
but
we
do
use
uservoice
to
help
prioritize
new
feature,
requests
and
see
what
the
community
needs
also
for
samples
and
the
pnp
we're
working
on
a
new
patterns
and
practice
around
opening
excel.
A
I
saw
care
mentioning
that
in
the
chat,
the
idea
that
you
can
open
an
excel
workbook
with
your
add-in
already
there
so
that'll
be
a
cool
feature
for
y'all
to
try
out
and
for
our
developers
in
the
audience.
So
with
that,
we'll
we'll
go
to
the
q
and
a
portion
of
this.
So
I've
seen
karen
the
chat
answering
some
questions
there.
We
did
have
a
question
about
undo,
support,
yeah
and
it
is
supported
in
powerpoint.
A
A
H
Thanks
alex,
I
think
in
general,
really
the
theme
around
hey
this.
This
community
call
and
the
chats
are
great
because
they
give
us
just
a
opportunity
to
also
understand
hey
some
of
the
things
that
we
may
have
heard
in
the
pra
in
the
past
that
are
still
pressing.
So
a
few
of
the
themes
that
popped
up
today
were
around
undo
redo
inside
of
excel,
as
well
as
our
mobile
strategy,
and
so
I
think
for
for
both
of
those.
H
You
know,
I
think,
we'll
continue
to
work
with
partners
like
infor
and
the
in
the
broader
community,
through
our
different
channels
on
user
voice,
github
and
stack
overflow
to
just
kind
of
continue
to
understand,
hey
what
are
the
critical
things
or
what
are
the
next
things
as
we
continue
to
evolve
the
platform-
and
I
I'd
say
really-
our
goal
is,
as
workflows
become,
modernized
they've
moved
from
just
individual
desktop,
based
workflows
to
things
that
are
more
collaborative
where
now
you're
accessing
your
data
in
a
variety
of
contexts,
as
well
as
in
the
browser
within
microsoft.
H
A
H
Definitely,
thank
you
so
so
I'm
not
adding
well
so
on
on
our
team.
We
have
four
ignite
sessions
to
call
out,
so
the
first
one
is
around
office
scripts,
and
so
we've
talked
about
the
scripting
and
power
automate
integration.
That's
currently
available
for
excel
for
web,
so
we'll
have
a
what's
new
session
there,
so
that
definitely
worth
checking
out
well,
one
of
the
pieces
of
feedback
we've
heard
from
developers
is
when
they've
started
to
speak
to
it
admins
or
end
users.
H
That
admins
may
not
be
aware
of
the
store
and
as
such,
they
may
have
this
store
disabled
within
their
organizations,
and
so
we're
taking
this
opportunity
to
have
a
session
around
that's
targeted
not
for
developers,
but
for
it
professionals
and
it
admins
around
increasing
your
productivity
and
so
we'll
have
a
demo
that,
with
a
sample
scenario,
that
takes
a
few
of
the
add-ins,
a
few
of
them
that
we've
presented
on
this
community
call
and
tells
a
story
around
hey
how
add-ins
help
organizations
become
more
productive
and
then
we'll
also
talk
a
bit
more
about
how
that
new
added
model
helps
in
terms
of
management
to
it,
admins
and
how
it's
more
secure
and
how
deployment
is
a
lot
easier
and
so
we'll
hope
to
help
beat
that
drone.
H
In
addition
to
that,
we
have
two
sessions
on
what's
new
on
the
platform,
so
one
is
what's
new
in
outlook.
Oh,
so
we'll
have
a
video
session
there
with
a
partner
and
then
on
the
excel
side,
we'll
have
a
what's
new
session
within
excel.
For
the
most
part,
it
will
be
a
recap
of
things
that
you
have
seen
on
this
community
call,
but
there's
three
things.
H
We
talked
about
the
open
in
excel,
we'll
have
some
demos
on
shortcut,
keys
and
contextual
tabs,
which
are
approaching
private
preview
and
we'll
be
publicly
available
for
beta
later.
This
fall
hope,
y'all
virtually
attend,
ignite
and
watch
the
videos,
and
then
I
mean
particularly
keen
on
the
it
admins
or
the
increased
productivity
session,
because
we're
hoping
hey
when
you're
having
conversations
with
your
customers,
who
are
new
to
the
web
added
model
that
video
can
serve
as
something
you
can
pass
along
to.
A
Them-
and
I
believe
ignite
is
september
22nd
through
the
24th
and
sign
ups
for
yeah
now
so
yeah
hop
on
we'll
post
links.
Thank
you.
Thank
you.
So
much
for
sharing
that.
A
So
I
think
that's
it
for
the
call
today
we'll
stay
on
the
on
the
chat.
If
you
have
any
additional
questions
or
anything,
if
you
want
to
keep
talking
to
us
or
if
you'd
like
to
engage
with
us,
provide
feedback
or
if
you're
interested
in
presenting
you
know
your
ad
in
on
an
upcoming
call,
you
can
visit
ms
office
add-ins,
engage
and
share
that
with
us.
You
can
also
tell
us
about
your
experience.
Building
add-ins,
we
are
running
a
survey
office
dev,
satisfaction
just
to
see
what
you
know
what's
been
easy.
A
What's
been
hard
and
kind
of
help
you
along
and
understand
that
journey,
and
if
you're
completely
new
to
office
add-ins,
you
can
take
a
look
at
our
five-minute.
Quick
starts
to
get
an
add-in
up
and
running
in
five
minutes.
You
can
start
playing
around
with
the
apis
in
script
lab.
I
know,
vid
gave
a
shout
out
to
that.
A
It's
a
great
tool:
it's
an
add-in
that
sits
in
excel
or
powerpoint
or
word
and
lets
you
or
outlook
and
lets
you
develop
ad
or
yeah
use
the
add-in
apis
in
there
or,
if
you're,
looking
to
automate
more
simple,
excel
tasks
check
out
office
scripts.
It's
a
lightweight
automation,
solution
for
excel
for
the
web.
A
We
also
have
these
developer
resources
that
if
you
need
to
get
an
office
or
a
microsoft,
365
tenant
head
over
on
to
the
developer
program,
you
can
start.
You
know,
testing
out
add-ins
there
on
you
know:
custom
dev,
tenant!
You
can
engage
with
us
on
stack
overflow,
using
those
tags
or
on
github
and
yet
use
user
voice
to
let
us
know
what
features
you
need
in
the
product.
A
Finally,
this
is
one
of
many
of
the
m365
developer
community
calls
if
you're
interested
in
teams,
development
or
sharepoint
head
on
over
these
calls.
We'll
have
all
this
information
in
the
follow-up
blog
post
that'll
be
posted
with
this,
on
the
developer
blog
and
in
the
youtube
video
that
will
get
uploaded
later
and
we'll
post
more
information
about
that
recap
in
the
chat
so
yeah.
Thank
you.
Everyone!
The
next
call
is
going
to
be
october:
14th
8
a.m,
pacific
daylight
time.
So
please
join
us,
then.