Ask Your Question

How to disable cell referencing for xls file

asked 2018-12-06 07:09:22 +0200

Garima gravatar image

How can cell referencing be completely disabled for calc application

edit retag flag offensive close merge delete


Context missing. Calc is about spreadsheets, which are built around formulas referencing other cells. But possibly you need to be able to write some text into cells which looks like formulas? then simply set default cell style to have Text cell formatting (or simply select all and apply Text format in cell formatting) before entering anything to cells. Please expand on your requirements/use case to be able to suggest something.

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-06 07:14:37 +0200 )edit

I want to disable the access of other spreadsheets data through cell referencing. If it is happening in the same sheet thats not an issue.

Garima gravatar imageGarima ( 2018-12-06 07:18:08 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-12-06 08:06:00 +0200

JohnSUN gravatar image

Perhaps you are looking for the Edit - Links - Break Link command?

edit flag offensive delete link more


I want to disable addition of links too

Garima gravatar imageGarima ( 2018-12-06 09:29:21 +0200 )edit

Ha! Do you mean call this function (Break Link) after each edit cell or recalculate sheet? So, small macro on event "Formulas calculated", why not?

JohnSUN gravatar imageJohnSUN ( 2018-12-06 09:54:01 +0200 )edit

BreakLink works for a specific link, not all the links as far as I understand. Also is there any such event "Formulas calculated"?

Garima gravatar imageGarima ( 2018-12-06 11:14:26 +0200 )edit

answered 2018-12-06 07:24:02 +0200

There's no such an option in Calc. A use case for this is still unclear (why could one need to disable referencing across different spreadsheets), but even if there's a valid case, it would be so niche that there would be no reason to implement such mode.

edit flag offensive delete link more


We are building a solution over the framework... where we want to disable the cell referencing for some security reasons. setting UpdateDocMode to false is working for ods file completely but its working only partially for microsoft office extensions. Why is it so?

Garima gravatar imageGarima ( 2018-12-10 15:30:49 +0200 )edit

/me cannot decode the text in your comment. "its working only partially for microsoft office extensions" means what exactly? and why isn't that a question on its own, with detailed description? with possibility to create a bug report later if it turns out to be a defect?

Mike Kaganski gravatar imageMike Kaganski ( 2018-12-10 15:34:32 +0200 )edit

loading a file with updateDocMode doesn't load the already existing links but loads all the data if a new link is added for microsoft office extensions but for ods file it doesnt update the newly referenced link also and shows a zero in place of data. I can add that as a different question.

Garima gravatar imageGarima ( 2018-12-10 15:37:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-12-06 07:09:22 +0200

Seen: 31 times

Last updated: Dec 06 '18