Spreadsheet to database

[roy wood]

having transferred my spread sheet to a database i find the formulas have been replaced with numbers.
is it possible to include them in a data base.
many thanks
roy wood

[FJCC]

Databases do not do calculations based on formulas in cells. Queries can do calculations on entire columns or on subsets of columns. What are you trying to do?

[robleyd]

I suspect this question follows from viewtopic.php?f=9&t=87173&p=408493#p408493 Perhaps the two topics might be merged?

[Villeroy]

Databases store raw data and this is what they do much better than sheets. They do simple calculations on rows and columns way easier and better than spreadsheets do. Unfortunately, this capability is somewhat limited when using dBase tables with OpenOffice.
Having data in a flat dBase table, remove all fields that were calculated in the spreadsheet (click table icon, menu:Edit>Edit...).
With the raw data in a dBase table, you have still a lot of options.
You can create queries to show only selected columns and rows in any order of columns and rows.
You can create input forms with specialized input controls for dates, times, currencies etc.
You can create reports for pretty printing. There is a report builder extension availlable for professionally looking reports. This tool has a lot of the calculation capabilities you are missing.
You can link your tables and queries to spreadsheet ranges with formulas, charts, conditional formatting and anything you are missing right now.
Finally you can create pivot tables from database data which is the most easy way to get meaningful aggregations from data without having to fiddle with spreadsheet formulas copied across cell ranges.

Report Builder: http://extensions.openoffice.org/en/pro ... rt-builder
Base and Calc: viewtopic.php?f=75&t=18511
Pivot table (aka "data pilot"): https://wiki.openoffice.org/wiki/Docume ... /DataPilot
A limited set of functions availlable with dBase in OpenOffice: http://www.openoffice.org/dba/specifica ... tions.html (no aggregations).

I managed my private expenses for many years in a simple table which started in the 90ies as an Excel list and a pivot table for the monthly overview and then continued with dBase and OpenOffice.org 1 and 2. Very simple and there are hundreds of programs able to handle dBase tables one way or the other.