Ask Your Question
0

How to disable cell referencing for xls file

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

Garima gravatar image

How can cell referencing be completely disabled for calc application

edit retag flag offensive close merge delete

Comments

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

2 Answers

Sort by » oldest newest most voted
1

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

JohnSUN gravatar image

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

edit flag offensive delete link more

Comments

I want to disable addition of links too

Garima gravatar imageGarima ( 2018-12-06 09:29:21 +0100 )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 +0100 )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 +0100 )edit
0

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

Mike Kaganski gravatar image

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

Question Tools

1 follower

Stats

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

Seen: 16 times

Last updated: Dec 06