OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Field Name and Field Type

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
anon_private
General User
General User


Joined: 05 Mar 2009
Posts: 21
Location: UK

PostPosted: Sat May 07, 2011 1:07 am    Post subject: Field Name and Field Type Reply with quote

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
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 07, 2011 1:45 am    Post subject: Reply with quote

A spreadsheet is not a database.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
anon_private
General User
General User


Joined: 05 Mar 2009
Posts: 21
Location: UK

PostPosted: Sat May 07, 2011 2:40 am    Post subject: Reply with quote

I know.

Are you saying that 'Field Types' are not appropriate in Calc and, therefore, do not need to be defined.
Back to top
View user's profile Send private message
mgroenescheij
Super User
Super User


Joined: 20 Apr 2011
Posts: 870
Location: Australia

PostPosted: Sat May 07, 2011 2:56 am    Post subject: Reply with quote

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).
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sat May 07, 2011 3:34 am    Post subject: Reply with quote

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 https://forum.openoffice.org
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group