Hello,
I have a use case in which I have to export complex Excel files with many formulas.
It is expected that sometimes some formulas are in error, but columns size and margins have been set-up so that errors won't be printed.
Using a PDF printer, or saving as PDF using Excel works like a charm.
Using Aspose.Cells make the error appear.
Please find attached:
1. A very simple example Excel file
2. The PDF generated with Excel
3. The PDF generated with Aspose
4. A snapshot indicating what goes wrong
For your info, this is the C# code used to generate the PDF file:
class Program
{
static void Main(string[] args)
{
Console.WriteLine("Start.");
string inputFilePath = @"\..\..\Files\REF test.xlsx";
string outputFilePattern = @"\..\..\Files\REF test - Saved as pdf with Aspose.pdf";
using (MemoryStream inputStream = new MemoryStream(File.ReadAllBytes(Directory.GetCurrentDirectory() + inputFilePath)))
{
using (MemoryStream PDFStream = new MemoryStream())
{
Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(inputStream);
workbook.CalculateFormula();
workbook.Save(Directory.GetCurrentDirectory() + outputFilePattern, Aspose.Cells.SaveFormat.Pdf);
}
}
Console.WriteLine("End.");
Console.ReadKey();
}
}
Could you help me ?