Is it possible to format part of a merged Cell?

Aspose.Cells Product Family
1

All,

We have a merged cell with a date:

WED

22

AUG

and we would like to add:
[3 Aug] in a smaller font in the same cell

Is this possible and how can I do this?

THANKS
PRASHANT

2

Hi,

Please check this document for your reference.

Formatting Selected Characters in a Cell

3

I really wanted know whether its possible to format part of a cell in a webworksheet, on a web page.

Thank you for your brill response tomy eatlier question.

THANKS
PRASHANT

4

Hi,

It seems, its not directly supported but as a workaround, you can use Aspose.Cells and then import the Excel file using WebWorksheets.ImportExcelFile method.

I have also logged this as a New Feature Request with id: CELLSNET-40464

5

Hi,

For this new feature ,we support setting only one style in the same cell, but we do not support set multiple different style to one cell, if you want to set style to a cell, you can use the following similar code.

C#


GridWeb1.WebWorksheets[0].Cells[0,0].PutValue(“hello world”);

Aspose.Cells.GridWeb.TableItemStyle style = new Aspose.Cells.GridWeb.TableItemStyle();

style.Font.Bold = true;

style.Font.Size=new FontUnit(20);

GridWeb1.WebWorksheets[0].Cells[0,0].SetStyle(style);