Ask Your Question

hidden cells [closed]

asked 2018-01-06 13:49:59 +0100

Mannesty gravatar image

updated 2020-08-07 22:20:40 +0100

Alex Kemp gravatar image

I have a number of hidden columns (Columns L to P) in a spreadsheet that contain formulas. When I insert new rows of data and fill (not copy) columns K to Q to the newly inserted rows, the contents of the hidden cells do not get filled.

This procedure works in Excel 2016, should it also work in LibreOffice Calc?

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 2020-08-07 22:20:50.153792

1 Answer

Sort by » oldest newest most voted

answered 2018-01-06 15:18:18 +0100

Regina gravatar image

updated 2018-01-06 15:20:34 +0100

No, it should not work that way. It is common agreement, that hidden cells must not be affected. See e.g. tdf#35345, tdf#44545, tdf#45020, tdf#56799 or tdf#81803. (tdf =

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2018-01-06 13:49:59 +0100

Seen: 109 times

Last updated: Jan 06 '18