Ask Your Question
0

unfreeze line in Calc bugs

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

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 +0100

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 +0100 )edit
0

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

MikeAgner gravatar image

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

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 +0100 )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 +0100 )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 +0100 )edit
0

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

Lupp gravatar image

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

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 +0100 )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 +0100 )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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 82 times

Last updated: May 25 '18