I use the 22.214.171.124 version of Aspose.Cells
when i use the cells.DeleteRange function with ShiftType.Up value. the area is well deleted but all the images under this area don’t move up.
Is there a solution to move up the object under the area when i want to delete it?
could you help me for this problem
for your information i check the new version 126.96.36.199 and it’s the same thing.
Thanks for your answer.
I have checked the 8.7.1 version but there is always the issue.
find attached files for more informations
In fact i insert the image in the excel template with Aspose before to delete the range.
Maybe i have to add parameters to the image. i try different things but it’s always the same issue
see the code below.
i post you two files:
- “Sources.zip” is the source code
- “Program.zip” is the exe files
string filePath = @“E:\test2\deleterange\WindowsApplication1\WindowsApplication1\bin\Debug\MyFileWithImage.xls”;
Workbook workbook = new Workbook(filePath);
Range range = workbook.Worksheets.GetRangeByName(“GRAPHE_RULER”);
Worksheet worksheet = range.Worksheet;
Cells cells = range.Worksheet.Cells;
cells.DeleteRange(range.FirstRow, range.FirstColumn, range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1, ShiftType.Up);
workbook.Save(filePath + “.out1.xls”);
Dim filePath As String = “E:\test2\deleterange\WindowsApplication1\WindowsApplication1\bin\Debug\MyFileWithImage.xls”
Dim workbook As New Workbook(filePath)
Dim range As Range = workbook.Worksheets.GetRangeByName(“GRAPHE_RULER”)
Dim worksheet As Worksheet = range.Worksheet
Dim cells As Cells = range.Worksheet.Cells
cells.DeleteRange(range.FirstRow, range.FirstColumn, range.FirstRow + range.RowCount - 1, range.FirstColumn + range.ColumnCount - 1, ShiftType.Up)
workbook.Save(filePath & “.out1.xls”)
I have logged a ticket with an id “CELLSNET-44268” for your issue. We will look into it soon.
Thanks you for your answer.
Do you have any idea about the delay for the next release.
Thank you very much
I try the latest version. The Image move upwards well but i have another issue.
I explain this issues in the attached files.
I send you a little program to show you the issue.
Thanks for that!
It’s OK for the picture with properties regarding Position to “Move but don’t move with cells”.
but the picture don’t move between the startfile and the final file.
we don’t have to change the property of this image.
If you check the graph at the final file, it are the wrong size and it’s a real issue for us.
thanks for this information