Ask Your Question
0

Calc: Frequent "Adapt row height" anomaly - takes 7 minutes [closed]

asked 2013-12-06 05:05:39 +0200

dcarter gravatar image

Working with large voter data spreadsheet for an entire county - 157,000 voters and lines in spreadsheet. Every thing was working fine until I started adding columns into which I would cut and paste columns from to put them where I wanted them to appear. It's mostly happening when I do operations with columns. I had spent a couple of hours adjusting the size (width) of columns with no problems at all.

Takes it 7 minutes to do its "Adapt row height" thing! Driving me nuts and I can't finish the job.

David Carter cell 409-718-2268

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-16 14:26:05.359334

1 Answer

Sort by » oldest newest most voted
0

answered 2013-12-06 20:16:38 +0200

m.a.riosv gravatar image

Please @dcarter, try resetting to default format for all cells outside the table [Ctrl+M], if this doesn't help, please try again resetting to default format for the all sheet. Maybe there are some formatted cells doing slower row height calculation.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2013-12-06 05:05:39 +0200

Seen: 1,181 times

Last updated: Dec 06 '13