Dropdowns driven data issues

Aspose.Cells Product Family
1

Hello,

I have an excel with drop down data as YES/NO values. Based on the selection, I am hiding or showing data by changing the font color + background color of the cells. But this functionality is somewhat working but not to its fullest extent whereas it is working as expected in excel. Please use the link here to download the sample project with the sample excel inside it to investigate the issue.
Sample project with file

2

@ashokComdyn

You mentioned that the dropdown‑driven font‑color and background‑color changes work in Excel but not fully when the file is processed with Aspose.Cells.

To investigate this further, could you provide the following information?

  • The exact Aspose.Cells SDK you are using (e.g., .NET, Java, Python) and its version.
  • A minimal code snippet that applies the font‑color/background‑color changes based on the dropdown selection.
  • A clear description of the behavior that is failing (e.g., colors not updating, cells that should be hidden remain visible, etc.).
  • Whether you have tried the same file with the latest Aspose.Cells release.

With these details I can attempt to reproduce the issue and determine the next steps. Please share the requested information here in this thread.

3

@ashokComdyn
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): CELLSGRIDJS-2231

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.