Highest Rated Comments


beyphy358 karma

Do you guys have a preference internally between A1 and R1C1?

Also, what new features are you most excited to introduce into Excel that you're able to talk about?

beyphy10 karma

A flight takes 55 minutes (with driving, airport times, etc, it typically takes me 2h 30m door-to-door) and I usually pay $65 for tickets.

The $65 dollar rate isn't typical from what I can see. A quick search on Google for flights between LA to SF shows that prices range from anywhere between ~$100 - ~$250. I might consider taking a train vs a $100 plane ride if it would save me a bit, would be more comfortable, and I wasn't in a hurry. And my willingness to do that would increase as plane tickets became more expensive.

beyphy9 karma

Yeah, same here. The only advantage I could see for using R1C1 is when using it is when writing a formula across many cells with different ranges in VBA. Something like "range("C1:C1000").formla = "=sum(RC[-2]:RC[-1]"" or something like that

beyphy7 karma

Ah I see. I meant when you have to write a worksheet formula, or a formula in VBA, do you have a preference between A1 and R1C1?

beyphy7 karma

They're putting their efforts in the JavaScript API. Look into ScriptLab. It's a much better development experience than VBE. And JavaScript / typescript offer many of the features you mentioned above. (Fwiw, I'm also employed as a VBA developer)