Does Aspose Cells Support Complex Data Type Cards

Aspose.Cells Product Family
1

My application appears to be using a Aspose version from 2023. I have recently attempted to read values of cells where they are a dropdown connected to a complex data type. A single cell value has a data card associated with it. ex.
Id, Name, Address, Status

In excel the cell only displays Name, but has a small icon attached to it to open the data card up to see other options.

When viewing this cell in Aspose Cells, I expected the value to be Name, but its #VALUE and indicating the cell has a error.

I suspect my version of Aspose doesnt support this feature, but I am wondering if newer versions do?

2

@OpenDevSolutions

Could you please provide more details about the specific version of Aspose.Cells you are using and the exact code snippet you are using to read the cell values?

3

I am using version 23.3.0. I have attached a screenshot of a example of a cell using a data type card.

image.png (9.2 KB)

4

@OpenDevSolutions
Would you like to provide your excel sample file? We will check it soon.

5

@OpenDevSolutions
By creating sample files for testing on the latest version v25.4, we can reproduce the issue. Cell.StringValue returns #VALUE! when using complex data type cards. Please check the attachment. linked-data-types-sample-workbook.zip (233.4 KB)

Workbook wb = new Workbook(filePath + "linked-data-types-sample-workbook.xlsx");
Cells cells = wb.Worksheets[0].Cells;
Console.WriteLine(cells["B11"].StringValue);

The output:

#VALUE!

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-58350

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

6

@OpenDevSolutions
What do you want to get ? A string value “Second Option” or all properties of the card?

7

I would imagine to be consistent, just the textual value of the cell will suffice. I would imagine retrieving any other properties would be similar to something like retrieving the cells notes (previously comments).

ex.

Comment comment = worksheet.Comments[row, column];
// Attempt to retrieve a classic comment
if (comment != null)
{
    return comment.HtmlNote;
}
return String.Empty;
8

@OpenDevSolutions,

Thanks for your feedback and further details on your requirements.

We have noted it down against you logged ticket “CELLSNET-58350” into our database. We will evaluate and look into it soon.