Field Name and Field Type

anon_private · General User Joined: 05 Mar 2009 Posts: 21 Location: UK

I have set up a spreadsheet in Calc.

I can't see how to define the Field Types, as I have done in Base.

Can anyone advise?

Thanks

A

Villeroy · Posted: Sat May 07, 2011 1:45 am Post subject:

A spreadsheet is not a database.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org

anon_private · General User Joined: 05 Mar 2009 Posts: 21 Location: UK

I know.

Are you saying that 'Field Types' are not appropriate in Calc and, therefore, do not need to be defined.

mgroenescheij · Posted: Sat May 07, 2011 2:56 am Post subject:

Hi,

In Base you have records and fields.
In a Spreadsheet you have Cells for which you can define Formats.
If you go to Format -> Cells you're able to define properties for the Cell.
In the Format Cells popup window you see 7 Tabs
The first tab is Numbers here you can set id a Cell contains Numbers, Currency, Date etc.
For each selection you can set the display format.

Regards,
Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

Villeroy · Posted: Sat May 07, 2011 3:34 am Post subject:

No matter how you format your cells, each and every cell can have any type of data. In fact text and numbers are only 2 types of valid data not counting errors and empty cells. Numbers can be formatted to be displayed as dates. Text is just text. Number formatting is just a visual effect without any effect on the numeric values. There are no row sets nor relations nor field names. A cell is addressed by means of column letters and row numbers.
The most prominent purpose of a spreadsheet is the calculation of interdependent numeric values.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org