Ubuntu
openoffice.org package

spread sheet issues

Asked by harsh

can we use "sql" query on this. or can we sort data on two or more columns., if yes guide me

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Federico Tello Gentile (federicotg) said : 		#1

Yes, to both.
You can sort using the Data -> Sort menú.
As for SQL, you can connect the spreadsheet to a database or use Base, which is a part of OpenOffice and LibreOffice.
OpenOffice has an excelent help system to get you started on those topics.

Revision history for this message
harsh (santhoorh) said : 		#2

well if I transfer to data base I can do that but with spread sheet, can I sort on 3 columns (eg, city, gender and course selected.) If I select more than one column then sort option does not work.

Revision history for this message
harsh (santhoorh) said : 		#3

Sorry I forgot that I don't have database on my system

Revision history for this message
Federico Tello Gentile (federicotg) said : 		#4

You say sort on 3 columns doesn't work, but it does. You have to use the data menu as i told you. Clearly you did not read the help.

Can you help with this problem?

Provide an answer of your own, or ask harsh for more information if necessary.

To post a message you must log in.