Ask Your Question

[Calc 4.1] How do I make column headers [closed]

asked 2014-09-06 01:51:50 +0100

mamamamamamamamario gravatar image

I have a big csv with property data in the following data structure:

Address, sold price, sold date, selling agency, squarefoot, beds, baths, etc...

"123 Maple", "123,000" "1-1-2014", "bob's real estate", "1234", "3", "2", ...

"432 Oak", "321,000", "2-2-2014", "michael's real estate", "2345", "5", "3", ...

So how do I set it up to be able to select a column of criteria, such as price, and filter that while keeping all the data together, while ignoring the top row? I looked everywhere in the menus for headers or anything that looked like it might help but i haven't found anything. It seems to get jumbled up and includes the top row in the sorting. Freezing isn't what i want.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 16:53:59.343324


maybe it has to do with labels?

mamamamamamamamario gravatar imagemamamamamamamamario ( 2014-09-06 02:06:44 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2014-09-06 02:27:59 +0100

m.a.riosv gravatar image

I think the best is define the data range (including headers) in Menu/Data/Define data base range. So options for sort (Menu/Data/Sort) and filter (Menu/Data/Filters) are kept with the range.

image description

edit flag offensive delete link more


@mariosv - Your proposal looks very interesting. Could you possibly show a screen shot with the results you get? Thanks in advance.

ROSt52 gravatar imageROSt52 ( 2014-09-06 05:33:15 +0100 )edit

Sorry @ROSt52, what results?

m.a.riosv gravatar imagem.a.riosv ( 2014-09-06 11:54:47 +0100 )edit

thanks, this is what i needed

mamamamamamamamario gravatar imagemamamamamamamamario ( 2014-09-06 16:58:23 +0100 )edit

Question Tools

1 follower


Asked: 2014-09-06 01:51:50 +0100

Seen: 6,144 times

Last updated: Sep 06 '14