Will dbBee show calculated fields?
dbBee only reads data from
data sources (Excel workbook or Access database), ignoring all the formatting,
macros, charts, reports, forms, etc. However, calculated fields can be used as
read-only fields (you can not add/update them using CD / Admin / CUD wizards)
and in case of Excel sheet, they have to be calculated using the Excel program.
This means that in case of Access database, if you have a calculated field named "Amount" with expression
Price*Quantity, it is enough to add values to fields Price and Quantity and
field Amount will be automatically calculated. On the other hand, if you have
same field in Excel sheet ("Amount" with formula "=C1*D1" where C1 and D1 are
cells in columns Price and Quantity respectively), you can add values to fields
Price and Quantity but your field Amount will NOT be calculated until you
download your excel workbook and open it in Excel.
BACK
