How to disable Drag and drop and Cut paste on a sheet

Creating a macro - Writing a Script - Using the API

How to disable Drag and drop and Cut paste on a sheet

Postby Sulochana » Thu Jul 25, 2013 6:44 am

Hi there,

I have a work sheet that is used by others to enter data. There are many formulas related to the entered data. Users who enter data do not know much about formula's and the formula area of the sheet is protected.

Even though the area is protected, if the users drag and drop data or cut and paste data, the formulas are affected. (The cell reference changes)

I want to stop this because formulas will give error results if the above mentioned happens.

Is there a way to disable cut & paste ,Drag and drop? Or is there a way to keep the cell references without changing even if the above is done?

Really appreciate your support.

Sulochana
OpenOffice 3.1 on Windows 7
Sulochana
 
Posts: 17
Joined: Sat Jun 08, 2013 5:53 am

Re: How to disable Drag and drop and Cut paste on a sheet

Postby MrProgrammer » Sat Jul 27, 2013 11:32 pm

Sulochana wrote:Or is there a way to keep the cell references without changing even if the above is done
You could use INDIRECT, for example, =A2+A3 becomes =INDIRECT("A2")+INDIRECT("A3"). You can probably use Edit > Find & Replace to help with changing the formulas.

If this answered your question please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.
Mr. Programmer
OpenOffice 3.2.0 Build 9483 on Mac OS X 10.6.8.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Volunteer
 
Posts: 1739
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 5 guests