Aspose cells changing default Font style to Calibri


#1

Hello, I’m trying to use Aspose cells to work with page break. It works fine.
However, once workbook saved font style changed from default “Arial” to “Calibri”.
Can you please advise how to avoid this.

Regards,
Natasha


#2

@PamTech

Thanks for using Aspose APIs.

Please provide us your Excel files and the sample code that replicates your issue. We will look into it and help you asap.

Please also download and try the most recent version and see if it makes any difference and resolves your issue. Let us know your feedback.

Download Link:

http://nuget.org/packages/Aspose.Cells/18.6


#3

Thank you so much for getting back to us.
Please find code below and 2 Excel files.

  1. Before formatting
  2. After formatting

var book = new Aspose.Cells.Workbook(FilePath);

            book.Worksheets[0].HorizontalPageBreaks.Clear();
            book.Worksheets[0].VerticalPageBreaks.Clear();
            book.Worksheets[0].PageSetup.FitToPagesTall = 0;
            book.Worksheets[0].PageSetup.FitToPagesWide = 1;
            book.Worksheets[0].IsPageBreakPreview = true;            
            
            book.Save(FilePathOut);

#4

@PamTech,

It seems that files are not attached with the post. Please send the files again.


#5

Trying to upload files, getting the error - The file must be a .nupkg file.


#6

@PamTech,

You may please try once by zip the file and then send. If not sent, please upload them to any file sharing server like Dropbox or Google drive and share the link here.


#7

AsposeFiles.zip (47.3 KB)


#8

@PamTech,

Thank you for sharing the files. We will look into it soon and share feedback here.


#9

Thank you! Just want to confirm that this is free support. Correct?


#10

@PamTech,

Yes, you are right.


#11

Thank you so much!


#12

@PamTech,

It seems that you are using some old version as this issue is not re-produced with the latest version Aspose.Cells for .NET 18.6. Please give it a try and provide your feedback here.


#13

Thank you for the answer. We are using Aspose.Cells.dll can you please provide URL from where we can download latest version.

Thank you!


#14

@PamTech,

You may download the latest version here:
https://downloads.aspose.com/cells/net


#15

Thank you so much for your help! It worked.


#16

@PamTech,

Good to know that the latest version sorted out your issue now. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.