charts and shapes does not move when row inserted in excel in c# programmatically

Question

4.00/5 (1 vote)

See more:

When i insert a row in excel, charts and other shapes does not move with their cells.
Lets say i have a chart at A5:D10, then i insert a row below 2nd row, so now chart should be at A6:D11, but chart stays their and hides the 5th row.

I design a template containing chart and shape, then at runtime i am supplying data for chart and changing few properties of shapes. Now my sheet contains some data in first 5 rows and i insert row after 2nd row then everything should go one row down, but this is not happening.

At design time i have checked that charts property to move and size with cells is set to true. Yet this is not happening at runtime programmatically. Although at design time inserting rows have no issues.

Following is code used to insert row :

C#

range.Insert(XlInsertShiftDirection.xlShiftDown, XlInsertFormatOrigin.xlFormatFromRightOrBelow);

Please help me to solve my problem
Thnx.

Posted 18-Apr-12 20:34pm

j4m4l

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Eugene Sadovoi · Answer 1 · 2012-04-20T10:35:00

Solution 1

The charts are not part of spreadsheet. They are displayed in separate 'windows' and overlay the sheet. You need to get the instance of the chart and update its position relative to top left corner. In other words you need to shift position of the chart down by the value based on the hight of the inserted row.

Posted 20-Apr-12 10:35am

Eugene Sadovoi

Comments

j4m4l 20-Apr-12 23:25pm

There is a property for charts and shapes i.e. 'move and size with cell', if i set this property at rutime like this :
chartObject.Placement = Excel.XlPlacement.xlMoveAndSize;
than it should work, but its not working.