font.name property

[Larin_Andrej]

Hi

I try use style:

    TFlxFormat style = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0));  //xls.GetCellVisibleFormatDef(1, 1);//xls.GetDefaultFormat;
    style.HAlignment = THFlxAlignment.center;
    style.WrapText = true;
    style.Font.Name = "Verdana";
    style.Font.Size20 = 160;
    style.Font.Family = 2;
    style.Font.CharSet = 204;
    xls.SetStyle(enumXlsStyles.normal.ToString( ), style);

                .........

    xls.SetCellFormat(row, col, row, col, xls.GetStyle(styleName.ToString(), styleApply) 

But in generated excel font is 'Calibri'.   I'm doing something wrong ?               

 

Thanks

[adrian]

Hi,

I see you are getting the right "normal" style, with:

TFlxFormat style = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0));

But, when setting it, you use:

enumXlsStyles.normal.ToString( )

Which I imagine returns the string "normal", not the Excel built in name for the "Normal" style (which is a single character, by the way).

Try with:

xls.SetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0), style);

I've tried it here, and the generated file has verdana as normal font.

Regards,

Adrian.

[Larin_Andrej]

I try use my style "normal".

I use   my enum enumXlsStyles for facility.

I try rename style "normal"  to "myNormal" for exclude name conflict. Other property (size, align, wraptext) work right, but name dont work
Thanks

[adrian]

I see the font changed ok. Might there be something different in your machine?  (maybe a corrupted tahoma?)

I've tried the following console application:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using FlexCel.XlsAdapter;
using FlexCel.Core;

namespace ConsoleApplication3
{
class Program
{
static void Main(string[] args)
{
XlsFile xls = new XlsFile(1, true);

        TFlxFormat style = xls.GetStyle(xls.GetBuiltInStyleName(TBuiltInStyle.Normal, 0));  //xls.GetCellVisibleFormatDef(1, 1);//xls.GetDefaultFormat;
        style.HAlignment = THFlxAlignment.center;
        style.WrapText = true;
        style.Font.Name = "Verdana";
        style.Font.Size20 = 160;
        style.Font.Family = 2;
        style.Font.CharSet = 204;

        xls.SetStyle("MyNormal", style);
        xls.Save("r:\\tes.xls");
        xls.Save("r:\\tes.xlsx");
    }
}

}

I then opened the file with Excel, selected "MyNormal" in the cell style, and the font was verdana 8.

Can you run this program and email me the files you get to adrian@tmssoftware.com ?

[Larin_Andrej]

I send files  from zzzabl@gmail.com

[adrian]

Thanks, I got the file.

What happens in your case, is that Excel 2007/10 have a font property named "Scheme" that identifies which scheme of the current theme you are using, and this property has priority over the font name.

This is done this way so when you change the theme of the sheet, say from "Office" to "Apex", the font changes from "calibri" to "book antiqua"  If the font name had priority, the fonts wouldn't change.

So you need to set the scheme of the font, besides the name and size. Try adding:

style.Font.Scheme = TFontScheme.None;

to the font definition in your code. TFontScheme = None means "use the hardcoded name".  TFontScheme = major, means, "use the major font for the theme, no matter what the font name is", and Minor is the same for the minor font of the theme. (a theme defines a major and a minor font, and when you change the theme, all cells that are set to major or minor change with the theme. the cells that are set to none remain with their font).

As your file already had Scheme = Major, when you changed it , it kept being major. Setting it to none will fix your problems.

Ps:

If you really want to set an hyperlink in an image, you can do it with:

SetObjectProperty(int objectIndex, string objectPath, TShapeOption shapeProperty, THyperLink value);

but I think having a template like in your case makes it more flexible, so I would keep it.

[Larin_Andrej]

Yes. All work.

Thanks