Ask Your Question

hidden cells

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

Mannesty 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 close merge delete

1 Answer

Sort by » oldest newest most voted

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

Regina gravatar image

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

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
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 48 times

Last updated: Jan 06 '18