Dear,
I use the 7.7.0.0 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 8.7.0.0 and it’s the same thing.
Bests regards
Thanks for your answer.
I have checked the 8.7.1 version but there is always the issue.
find attached files for more informations
Best regards
Hi,
Hi,
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.
Best regards
Hi,
Hi
i post you two files:
- “Sources.zip” is the source code
- “Program.zip” is the exe files
Bests Regards
Hi,
Sample code:
[C#]
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.CalculateFormula();
workbook.Save(filePath + “.out1.xls”);
[VB]
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.CalculateFormula()
workbook.Save(filePath & “.out1.xls”)
I have logged a ticket with an id “CELLSNET-44268” for your issue. We will look into it soon.
Hi
Thanks you for your answer.
Do you have any idea about the delay for the next release.
best regards
Hi Bruno,
Hi,
Hi
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.
Best regards
Hi,
Dear
I send you a little program to show you the issue.
best regards
Hi,
Hi
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.
Best regards
Hi,
Hi,
hi
thanks for this information
bests regards
The issues you have found earlier (filed as CELLSNET-44268) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.