Geek Answers Handbook

Understanding / Modeling Formulas from Excel

I have an Excel spreadsheet that does a lot of calculations based on 4 cells to come up with a specific digit. I was instructed to convert this table to a widget, such as a component that can be embedded in a web application.

Is there an easy way to display or understand the inline formula in an excel spreadsheet, so that it is easier for me to convert them to ActionScript?

Thanks.

+2
source share
5 answers

If I understand you correctly. Tools | Options | Windows Settings, and then select the Formulas check box. This will show formulas instead of values. And he should open the Formula Auditing toolbar. These tools should give you the desire you want.

+2
source

Have you watched Calc4Web? I never used it, so I can’t give an overview, but the main idea is that it generates C ++ code from a spreadsheet.

0
source

If you just want to view the actual formula, not the result (value), then when you are active in the cell that has the formula you want to see, press CTRL + (grave accent). The grave accent is usually one key to the left of the number 1 key on most keyboards. This works as a toggle, so if you press CTRK + (grave accent). The grave accent is usually one key to the left of the number 1 key on most keyboards. This works as a toggle, so if you press CTRK + (grave accent). The grave accent is usually one key to the left of the number 1 key on most keyboards. This works as a toggle, so if you press CTRK + (key of serious accent) again - the value will appear, as it was before pressing the key combination of keys.

Additionally:

If you want to show ALL the forum for the entire book, follow these steps:

  • Click the Office button in the upper left corner, and then click the Excel Options button in the lower right corner of this window.
  • Click the "Advanced" tab in the left pane.
  • Scroll down to display pptions for the "This Worksheet" section.
  • Select the "Show formulas in cells instead of their calculated results" check box, and then click OK .
0
source

Since there is no easy way to convert Excel spreadsheets to ActionScript, I suggest you look at the formulas and try to solve them manually if the amount of data is not large or by writing a throw-out script if you need a lot of data. Thus, you will understand the calculations and be able to implement them in ActionScript, rather than relying on a wizard whose code you can or cannot understand.

0
source

You can also switch this parameter from the keyboard using Ctrl + ~ (this is a tilde, the first key in a string of numbers)

So, if you want to quickly see the formula in the cell and return to normal view, just press Ctrl + ~ twice

0
source

More articles:


All Articles