Styjun

What effect does the “loading” weapon property have in practical terms?

CiviEvent: Public link for events of a specific type

Why is my p-value correlated to difference between means in two sample tests?

Should I use my personal or workplace e-mail when registering to external websites for work purpose?

What does "sndry explns" mean in one of the Hitchhiker's guide books?

Is "plugging out" electronic devices an American expression?

How can I create a character who can assume the widest possible range of creature sizes?

Where does the "burst of radiance" from Holy Weapon originate?

Does it makes sense to buy a new cycle to learn riding?

Why did Howard Stark use all the Vibranium they had on a prototype shield?

Manuscript was "unsubmitted" because the manuscript was deposited in Arxiv Preprints

How are circuits which use complex ICs normally simulated?

Is three citations per paragraph excessive for undergraduate research paper?

What does Linus Torvalds mean when he says that Git "never ever" tracks a file?

"What time...?" or "At what time...?" - what is more grammatically correct?

How to make payment on the internet without leaving a money trail?

In microwave frequencies, do you use a circulator when you need a (near) perfect diode?

Understanding the implication of what "well-defined" means for the operation in quotient group

What are the motivations for publishing new editions of an existing textbook, beyond new discoveries in a field?

What is the use of option -o in the useradd command?

The difference between dialogue marks

I looked up a future colleague on LinkedIn before I started a job. I told my colleague about it and he seemed surprised. Should I apologize?

Does duplicating a spell with Wish count as casting that spell?

Are there any other methods to apply to solving simultaneous equations?

range.formulas assignment is not updating the Formula Bar in Excel add-in

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

2

I'm in an Excel web Add-in (office-js), in a .xlsx file

In Range C3: C6 there are formulas that in the same type VLOOKUP

Snapshot of before code execution

And In index.js my code is

let data=[
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
]
range.formulasR1C1 = data; // Here range is C3: C6
range.select();
return ctx.sync();

Before the code above runs, the range C3: C6 is selected, it looks like the first picture.

So I expect after the code execution, the formula in the Formula Bar to update itself automatically.

What I've hoped for - an updated formula bar

But that doesn't happen and it fails to update the Formula bar.

What I'm seeing

Only if I select another cell or range, and then, re-select the Range C3: C6, the formulas in Formula Bar shows the Right Formula.

Can Anyone tell me what should I do? thx!

ms-office office-js office-app

share|improve this question

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It looks like you're assigning formulas before selecting the range - perhaps that's it?
  
  – Mavi Domates
  Mar 22 at 8:13
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @MaviDomates Thank u for replying. I have tried the order that Firstly, select the range, and Secondly assign the formulas, but No luck, still Doesn't update the Formula Bar Automatically.
  
  – 国贵棠
  Mar 22 at 13:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Actually here's an interesting thought. After the assignment, if you read the contents of the cells again (in the code) do you see what you've updated / or what's there before the update. I'm trying to understand if it's writing but not updating the UI
  
  – Mavi Domates
  Mar 22 at 13:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Oh - the last bit I've re-read. So it is updating the formulas assigned to those cells, just not the formula bar! Interesting. So there's probably a bug in terms of updating the display. Can you try (programmatically) selecting another group of cells and then re-selecting the same cells which you changed the formula? Does that refresh?
  
  – Mavi Domates
  Mar 22 at 13:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. After assigning the formulas, If I select another group of cells (or range) and then re-select the same cells. The Formula Bar shows the right formulas as we expect. I also think this is a bug.
  
  – 国贵棠
  Mar 23 at 12:52
  

  
  
  
  

add a comment | 

1

2

I'm in an Excel web Add-in (office-js), in a .xlsx file

In Range C3: C6 there are formulas that in the same type VLOOKUP

Snapshot of before code execution

And In index.js my code is

let data=[
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
]
range.formulasR1C1 = data; // Here range is C3: C6
range.select();
return ctx.sync();

Before the code above runs, the range C3: C6 is selected, it looks like the first picture.

So I expect after the code execution, the formula in the Formula Bar to update itself automatically.

What I've hoped for - an updated formula bar

But that doesn't happen and it fails to update the Formula bar.

What I'm seeing

Only if I select another cell or range, and then, re-select the Range C3: C6, the formulas in Formula Bar shows the Right Formula.

Can Anyone tell me what should I do? thx!

ms-office office-js office-app

share|improve this question

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  It looks like you're assigning formulas before selecting the range - perhaps that's it?
  
  – Mavi Domates
  Mar 22 at 8:13
  

  
  
  
  


• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  @MaviDomates Thank u for replying. I have tried the order that Firstly, select the range, and Secondly assign the formulas, but No luck, still Doesn't update the Formula Bar Automatically.
  
  – 国贵棠
  Mar 22 at 13:10
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Actually here's an interesting thought. After the assignment, if you read the contents of the cells again (in the code) do you see what you've updated / or what's there before the update. I'm trying to understand if it's writing but not updating the UI
  
  – Mavi Domates
  Mar 22 at 13:15
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Oh - the last bit I've re-read. So it is updating the formulas assigned to those cells, just not the formula bar! Interesting. So there's probably a bug in terms of updating the display. Can you try (programmatically) selecting another group of cells and then re-selecting the same cells which you changed the formula? Does that refresh?
  
  – Mavi Domates
  Mar 22 at 13:22
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. After assigning the formulas, If I select another group of cells (or range) and then re-select the same cells. The Formula Bar shows the right formulas as we expect. I also think this is a bug.
  
  – 国贵棠
  Mar 23 at 12:52
  

  
  
  
  

add a comment | 

I'm in an Excel web Add-in (office-js), in a .xlsx file

In Range C3: C6 there are formulas that in the same type VLOOKUP

Snapshot of before code execution

And In index.js my code is

let data=[
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
]
range.formulasR1C1 = data; // Here range is C3: C6
range.select();
return ctx.sync();

Before the code above runs, the range C3: C6 is selected, it looks like the first picture.

So I expect after the code execution, the formula in the Formula Bar to update itself automatically.

What I've hoped for - an updated formula bar

But that doesn't happen and it fails to update the Formula bar.

What I'm seeing

Only if I select another cell or range, and then, re-select the Range C3: C6, the formulas in Formula Bar shows the Right Formula.

Can Anyone tell me what should I do? thx!

ms-office office-js office-app

share|improve this question

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

let data=[
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
 ["=INDEX(R2C11:R9C11,MATCH(R[0]C2,R2C10:R9C10,0))"],
]
range.formulasR1C1 = data; // Here range is C3: C6
range.select();
return ctx.sync();

share|improve this question

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

share|improve this question

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

edited Mar 22 at 14:39

Mavi Domates

1,81921022

edited Mar 22 at 14:39

Mavi Domates

1,81921022

asked Mar 22 at 2:48

国贵棠国贵棠

62

asked Mar 22 at 2:48

国贵棠国贵棠

62