Hi,
I have tested with the version you suggested but the problem remains.
I have created a demo project to demonstrate the effect.
The code might be slightly bulky but I extracted the code I am working with.
The application defaults to 'horizontal' orientation.
You can crete the 'vertical' orientation by passing an 'v' as an argument.
The result is saved to either "horizontal.xlsx" or "vertical.xlsx".
A link to the table is created on the page "inhoudsopgave". If you click on the link the named region will be selected. This demonstrates that the region does not grow horizontally.
Kind regards, Bas.
Hi,
Hi,
Thank you for acknowledging the problem.
Can you give an estimate on when this will be picked up/fixed?
We will need this to work for the next release of our software (it needs to be fixed or we need to find an alternative) so we are on a schedule:
< 3 days - Wonderful!
< 2 week - Acceptable.
< 1 month - Problematic.
> 1 month - Not OK.
Thank you for your time,
Bas.
Hi,
Hi,
I am going to test this with in an hour or two, if it works, then you guys are totally awesome.
I'll keep you up to date with my findings.
Cheers, Bas.
Hi Guys,
The code now works as expected.
Totally awesome, thanks,
Bas.
The issues you have found earlier (filed as CELLSNET-40651) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by aspose.notifier.
Hello guys,
I have noticed that still exists (I downloaded the latest version) when the region is only a single cell.
Can you please take a look (and possibly fix) this?
Hi Bas,
I have modified your previously provided sample application according to your recently shared scenario, and executed it with latest build of Aspose.Cells for .NET 7.7.2.3. I am afraid, I was unable to notice any problem in the resultant file. There could be a difference in my understanding or the mentioned issue does not exist in the latest version of the API. Therefore, I would request you to please give a try to the latest build on your end. In case the problem persists, please provide us a fresh sample application replicating the issue on our end. We will look into it at earliest to provide further assistance in this regard.
Thank you for your cooperation and understanding.
Sorry for the delay, we’ve been busy working on some other things.
However, the issue still exists that ‘Horizontal growth’ works fine when the named region you start with has 2 columns or more… however it does not work when the starting region is only one column wide.
Please advice,
Bas.
Hi Bas,
Thanks for your posting and using Aspose.Cells.
Could you provide us a simpler console application with your expected and actual output xlsx files illustrating this issue. Screenshots will also be helpful. It will help us look into your issue precisely and we will be able to fix it.
Hi
You can use Smart Markers
&=TableName.ColumnName(horizontal) -> it will add column horizontal
&=TableName.ColumnName(horizontal,copystyle) -> it will add column horizontal with first column style
&=TableName.ColumnName(horizontal,copystyle,noadd) -> it will add column horizontal with first column style and it will add new columns overwrite existing column.
Regards,
Jaganlal
Dear sir,
My problem is not with getting the values parsed into excel sheet. I know how to do that quite comfortably. The problem I am having is that the 'Named regions' will not grow with the number of rows.
Strangely I am not able to reproduce the original point (P1), that the 'named region will not grow if it is a single cell', in the attached test application, instead the regions now refuse to grow at all (P2).
Perhaps (P1) only occurs when the sheets are more complex or contain more that one table.
EDIT: I am able to reproduce (P1) by removing the 'copystyle' element from the marker. In that case 'GrowingRegion' DOES grow while 'NotGrowing' DOES NOT.
Note that the Style is copied anyways!
As requested, I have attached an expected and an actual result plus a copy of the dll version we are currently using.
To summarize:
Named regions are not growing as expected.
I hope that I have provided enough information
to reproduce and resolve the issue.
The code used to parse the values:
DataSet demoSet = new DataSet("Demo");
var table = new DataTable("Table1");
demoSet.Tables.Add(table);
table.Columns.Add("Column1", typeof(string));
table.Rows.Add("row 1");
table.Rows.Add("row 2");
table.Rows.Add("row 3");
var workbook = new Workbook("GrowDemo.xlsx");
var designer = new WorkbookDesigner();
designer.Workbook = workbook;
designer.SetDataSource(demoSet);
designer.Process();
workbook.CalculateFormula(false); // <-- not really needed, for this demo, I am mimicking production.
// fetch value of the regions.
var tableRange1 = workbook.Worksheets.GetRangeByName("GrowingRegion");
var tableRange2 = workbook.Worksheets.GetRangeByName("NotGrowing");
workbook.Save("GrowDemo_Out.xlsx", SaveFormat.Xlsx);
Process.Start("GrowDemo_Out.xlsx");
Hi,
Thanks for your posting and using Aspose.Cells.
As a workaround, you can create a named range like this
=Blad1!$B$1:$B$1
instead of like this
=Blad1!$B$1
It will then work fine.
I have attached GrowDemo.xlsx in which I have added another named range Test2 which refers to single cell B6 like this =Blad1!$B$6:$B$6.
After the execution of application, it generates GrowDemo_Out.xlsx and Test2 grows to be =Blad1!$B$6:$D$6
Hi Bas,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue. The name range should grow when it is referring to a single cell like =Blad1!$B$1. It grows successfully when it is referring like this =Blad1!$B$1:$B$1.
We have logged this issue in our database for investigation so that it could be fixed in this scenario too. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as CELLSNET-42525.
Hi,
Thanks for using Aspose.Cells
Please download and try this fix: Aspose.Cells
for .NET v8.0.0.3 and let us know your feedback.
Hi all,