Ask Your Question

In Calc, can you lock the results of a formula to the row?

asked 2019-01-03 23:12:35 +0100

RAR gravatar image

I am working with large spreadsheets (5000 rows x over 25 columns). After a sort, I need to tag rows into groups based on the row's position in the sort. I can write a formula to assign each row a tag, but is there a way to make that tag "Stick" to the row after the next sort? All I have found is to manually re-enter the tag on each row, not practical with 5000 rows.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-01-04 10:14:05 +0100

m.a.riosv gravatar image

Maybe playing with the option Menu/Toools/Options/LibreOffice calc/General - Update references when sorting range of cells could help

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-01-03 23:12:35 +0100

Seen: 55 times

Last updated: Jan 04