Ask Your Question
0

unfreeze line in Calc bugs

asked 2018-05-24 15:44:19 +0200

MikeAgner gravatar image

I have a multi page spreadsheet where I froze the top line as it was a header. However there's a bug - it seems you can't unfreeze that line by selecting it again (at least it didn't work when I tried it). You also can't change column widths while the top line is frozen, and I also noticed that the line numbers on the left are gone. I also found, much to my amazement, that the frozen line applied to all pages in the book, not just the one I was working on at the time.

Has anyone found a workaround for these bugs?

Thanks in Advance...Mike

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted
1

answered 2018-05-24 21:01:23 +0200

erAck gravatar image

With a frozen row the menu entry of View -> Freeze Cells -> Freeze Rows and Columns should have a check mark, select that menu entry to unfreeze frozen rows and/or columns.

edit flag offensive delete link more

Comments

Quoting @MikeAgner: "- it seems you can't unfreeze that line ... (at least it didn't work when I tried it). You also can't change column widths while the top line is frozen, and I also noticed that the line numbers on the left are gone. I also found, much to my amazement, that the frozen line applied to all pages in the book, not just the one I was working on at the time."

Lupp gravatar imageLupp ( 2018-05-24 21:22:26 +0200 )edit
0

answered 2018-05-25 22:59:36 +0200

MikeAgner gravatar image

updated 2018-05-25 23:06:15 +0200

There is no checkmark in the freeze menu; probably because I can't select the line by tapping the line number, as they aren't there, so trying the freeze menu again simply doesn't work (remember this is a multi page workbook).

I tried using safe mode - worthless. I tried restore from backup and reset to factory defaults, and the problems are still there. This is a fairly annoying bug; hopefully the developers are reading this and taking notes. I'm not using any extensions

Mike

edit flag offensive delete link more

Comments

1

This is not an answer so should had been added as a comment instead or editing your original question.

Anyway, I've no idea what you're talking about, please share your document.

erAck gravatar imageerAck ( 2018-05-28 11:26:17 +0200 )edit

OK How can I attach a document? There doesn't seem to be any way to do it within a comment, unless I'm not seeing an icon or two..

MikeAgner gravatar imageMikeAgner ( 2018-05-28 23:38:16 +0200 )edit

OK I found a partial answer. As there is no checkmark anywhere to be seen in the freeze line pulldown, for winks and grins, I went to VIEW / FREEZE CELLS / FREEZE ROWS AND COLUMNS and sure enough, the line was unfrozen. If you have a multi page workbook, you must do this for each page - in other words, it only works for the page that you are viewing at the time.

MikeAgner gravatar imageMikeAgner ( 2018-05-28 23:54:07 +0200 )edit
0

answered 2018-05-24 18:34:23 +0200

Lupp gravatar image

updated 2018-05-24 18:35:01 +0200

First try to start your system anew. It may have got a punch.
If this doesn't help, try to (cautiously!) reset your user profile. It may have got corrupted. See this wiki page.

edit flag offensive delete link more

Comments

'Got a punch'?? What does that mean? And I did try to fool around with my user profile, but got nowhere. It seems that if you have a spreadsheet with only 1 page, things work (although I still don't see anything about a checkmark in the freeze menu when you have frozen a line). It seems if there are multiple pages in the spreadsheet, Calc has issues.

MikeAgner gravatar imageMikeAgner ( 2018-05-29 21:35:52 +0200 )edit

A punch applied to a computer system might be a blackout, a system freeze or any failure requiring a forced close down, registry corruption, ... Ok?
Recent versions of LibO don't display a checkmark under View > Freeze, I think. I didn't talk of such a thing.
The additional symptoms except "multi-page" you complained about (quoted in bold in my comment on @erAck 's answer) are simply not to understand without the assumption of severe corruption of the user profile or the LibO install.

Lupp gravatar imageLupp ( 2018-06-07 12:34:30 +0200 )edit

Concerning the many sheets having frozen rows: Freezing an unfreezing always was per-sheet in LibreOffice and its predecessors.
The way you are using terminology, I may suppose you document was probably created with Excel and opened from an alien file-format. If so you should not miss to mention it. in addition: what version? It may be relevant.

Lupp gravatar imageLupp ( 2018-06-07 12:40:32 +0200 )edit

I have the exact same problem as Mike, I am running Version: 6.0.7.3 (x64) and the single spreadsheet was created in LibreO, I can select and freeze the first row but I cannot reverse this action, there is No checkmark against "freeze first row" in the View menu and it also does not appear as an undo in the edit menu, the only way to clear it is select "freeze rows and columns" which again has no checkmark against it. Anyone got any ideas?

leadminer gravatar imageleadminer ( 2019-12-24 12:10:58 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-05-24 15:44:19 +0200

Seen: 172 times

Last updated: May 25 '18