4 Replies Latest reply on Oct 26, 2010 2:37 PM by Bryan Obermeyer

    General table formulas

    Bryan Obermeyer

      Is there a way to enter a formula in a general table?

      I would like to enter an English dimension and have a conversation be created automatically.

      We do not use OLE items because of resizing issues.

      I've seen copy/past from ecell but was wondering if a general table could do the same thins.

        • Re: General table formulas
          Deepak Gupta

          Click on the cell and select equation. Now select the cell having the English dimension/value and then use multiple/divide or plus minus (as required) to get the desired value.

            • Re: General table formulas
              Bryan Obermeyer

              Thanks Deepak!

              I love your responses (to all questions) and your a wealth of knowledge and a great resource!

               

               

              I do exactly as you suggest but I find there are some tricks to it:

              click on the cell,

              select equation,

              select the cell,

              multiple by 25.4, (i find I need to select in the "=" field and NOT use the  numerical keypad to enter symbols and values)

               

              Can you lock relative cell value (such as excel)?

              (That answer may answer this question) can you copy/paste?

              Is there a way to add " [ " " ]" to the resulting value?

               

              Thanks in advance.

                • Re: General table formulas
                  Deepak Gupta

                  Bryan Obermeyer wrote:

                   

                  Can you lock relative cell value (such as excel)?

                  (That answer may answer this question) can you copy/paste?

                  Is there a way to add " [ " " ]" to the resulting value?

                   

                  Thanks in advance.

                  Thanks for the compliments Brian and sorry answers to your questions are NO. You may copy paste the value but it will keep the same equation.

                   

                  Say you have the equation "= A1*2" in a cell. You copy and paste it in a different cell. The resulting equation in that cell will be "= A1*2". So you'll have to manually change it.

                   

                  Sorry if there is way to do it, I don't know.