Ask Your Question

How i automatically sort data upon data entry on a table at calc?

asked 2017-03-28 10:49:09 +0200

teo1985 gravatar image

Hey this might be kind of answered already but I still didn't manage to figure out how I can automatically sort data descending on the last column of a table that I fill up every month. The problem I got is that I want a dynamic table that I fill numbers in rows, for every month of the year for 10 persons and it changes by descending order. Should I use a macro? should I use formula? this is a link of my table

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-03-28 11:10:21 +0200

What you describe can be described by term "relational database", where the order of record hasn't significance. This is best handled by Base.

Of course, you may use a macro to do that in Calc, too (or even in Writer, if you're creative)... but I suppose that using a tool specifically suited for the job is the best. In Base, you may apply sorting to the dataset either on table level, or on view level as you need (including dynamically).

edit flag offensive delete link more


I don't know how to use base at all but thnx for the answer. I ve found some usefull info here but when I use the 1st (with copy paste) and I try to run it at args1(0).Value = oRange.AbsoluteName I cant figure how to use the range I want because the I don't know how to pick values.

teo1985 gravatar imageteo1985 ( 2017-03-28 13:20:20 +0200 )edit

answered 2017-03-28 23:32:10 +0200

m.a.riosv gravatar image

Not automatic, but easy.

Defining a range for you data Menu/Data/Define Range,
you can then define a Menu/Data/Sort with the options preserved for above range.

To use it:
1-Click in the Data range or Menu/Data/Select Range
2-Menu/Data/Sort [Ok]

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2017-03-28 10:49:09 +0200

Seen: 944 times

Last updated: Mar 28 '17