TABULUS^®, The Table Oriented Spreadsheet

TABULUS^® 2010 - Simply put, TABULUS is a better spreadsheet!

home	recent topics	recent posts	search	faq

Home » Support & Discussion » Can I edit a formula in the formula browser?

9/4/2009 4:05:20 AM rado Posts: 47	Formula browser is mainly for searching and navigation purposes. There you can see all formulas in the worksheet, or to filter them by table or by type. You can highlight the cells where formula is applied (formula scope) or to change priority of formula in cases when two or more formulas are overlapped. You can lock the formula which prevents the user to write over formula results accidentally. In order to make user’s life easier we have put add, delete and edit buttons in formula browser toolbar so if you want to edit a formula from there you have to select it and to press edit button. The formula editor is activated and you can start editing. We are considering inline editing as a future improvement. We have so called formula editor where you can edit the cell content including formulas. It is very standard feature similar to other spreadsheet products. It is placed on top of worksheet which is also pretty standard. In addition to manual editing we have added four power features – “Auto complete”, “Click to refer”, “Scope editor” and “Selection auditing”. “Auto complete” uses entered letter and filter possible model objects which could be participate in formula. It also suggests proper syntax elements. In this way you can write formulas easier without knowing our syntax completely. “Click to refer” helps you to refer model objects (tables, categories, groups etc.) visually. You have simply to click on cell or header in the worksheet or to select range of cells – the references are added automatically in the formula’s body at the cursor position. “Selection auditing” is useful in cases you are looking where is the source of error. You can select part from the formula, the program evaluates it and the result is shown as a tooltip. “Scope editor” is a visual too where you can edit where the formula is applied (formula scope). It keeps you from manual describing of scopes. edited by rado on 3/12/2010 -- Radoslav Nemchev CTO, Diehl Technology LLC Attachments: FormulaBrowser.jpg AutoCompleteFeature.jpg ClickToRefer.jpg SelectionAuditing.jpg ScopeEditor.jpg
permalink
pages: 1

9/4/2009 4:05:20 AM

rado
Posts: 47

Formula browser is mainly for searching and navigation purposes. There you can see all formulas in the worksheet, or to filter them by table or by type. You can highlight the cells where formula is applied (formula scope) or to change priority of formula in cases when two or more formulas are overlapped. You can lock the formula which prevents the user to write over formula results accidentally.

In order to make user’s life easier we have put add, delete and edit buttons in formula browser toolbar so if you want to edit a formula from there you have to select it and to press edit button. The formula editor is activated and you can start editing. We are considering inline editing as a future improvement.

We have so called formula editor where you can edit the cell content including formulas. It is very standard feature similar to other spreadsheet products. It is placed on top of worksheet which is also pretty standard. In addition to manual editing we have added four power features – “Auto complete”, “Click to refer”, “Scope editor” and “Selection auditing”.

“Auto complete” uses entered letter and filter possible model objects which could be participate in formula. It also suggests proper syntax elements. In this way you can write formulas easier without knowing our syntax completely.

“Click to refer” helps you to refer model objects (tables, categories, groups etc.) visually. You have simply to click on cell or header in the worksheet or to select range of cells – the references are added automatically in the formula’s body at the cursor position.

“Selection auditing” is useful in cases you are looking where is the source of error. You can select part from the formula, the program evaluates it and the result is shown as a tooltip.