Open Office Spreadsheet or Data Base?

D

davehenrie

Registered
I'm trying to catalog about 100 items that have 6 or so categories.
I have Name, Tier, Type, BossLvl etc.
I entered the data for about a dozen of the items, then when I wanted to sort by the boss lvl, that is all it did, without keeping the other items for each name associated. Just the column that was under boss lvl sorted, nothing else, so It doesn't keep the rest of the information tied to that colum. Which messes everything up.
I've never worked with office items in any way more than just the barest of tinkering. So if someone can clue me in on how to associate an entire horizontal line of colomns with a sorting process, that would be most helpful.
I'm using the Calc program, but would this info be more conducive to a data base instead?
 
Highlight all the data and select data=>sort and select column to sort by....might be easier with pics;
Here's the data
Calc1.PNG

Highlight the data....exclude row with column names
calc2.PNG

Select Data=> Sort
calc3.PNG

Select column to sort by and click OK
calc4.PNG


and voila
calc5.PNG
 
Last edited:
Why not just apply the AutoFilter!?
Select all your data, go to "Data" tab, and turn on "AutoFilter". Now you can add or delete items and filter or sort the whole list on the fly. Just keep in mind that when you add new columns that you will have to re-apply the AutoFilter to all data to make it work :cool:
 
Maybe not much help, but I find Google Sheets to be better than the few "free" alternatives I've tried.

(Libre Office/Open Office/etc)
 
thanks, all, I'll try the filter next. My biggest gripe is that open office has crashed everytime I've used it. You can recover files, but frustrating.
 
FuNK! said:
Skip OpenOffice, it's very much outdated. Use LibreOffice or if you like to try something else, go for latest SoftMaker Freeoffice :cool:
Click to expand...
I changed over to Libre. seems to work without crashing. I even figured out how to get some background color automatically for certain cells. thanks all.
 
You must log in or register to reply here.
Back
Top