Same cell different font

[DaveHenson]

Hi all,
I m trying to create an spreadsheet that having same cells with
different fonts. One font readable and one barcode font. Just wonder
if any sample source code for reference?

I m trying to reference below link but failed. Can't find the
NamedRange even add reference for Microsoft.Office.Tools.Excel
http://msdn.microsoft.com/en-us/lib...tools.excel.namedrange.characters(VS.80).aspx


Many thanks for help!!!

 

[Peter Duniho]

Hi all,
I m trying to create an spreadsheet that having same cells with
different fonts. One font readable and one barcode font. Just wonder
if any sample source code for reference?

I m trying to reference below link but failed. Can't find the
NamedRange even add reference for Microsoft.Office.Tools.Excel
http://msdn.microsoft.com/en-us/lib...tools.excel.namedrange.characters(VS.80).aspx

NamedRange is only going to work if you are using _all_ of Excel. It's
not something you can just pick out and stick into your own program as a
separate component.

As far as the specific question goes, it's hard to know for sure what
your specific need is. If you need a full-featured spreadsheet, then
perhaps what you really want is to host an embedded Excel OLE object in
your program.

If you just need a kind of grid layout, then it's possible it would
suffice for you to use something like FlowLayoutPanel or (more likely)
TableLayoutPanel, with TextBox or Label instances in each cell of the panel.

Pete