Export spreadsheet to PDF with formula calculated values
I use the Gembox.Spreadsheet dll to convert a Excel document to PDF by:
ExcelFile.Load(formExcelPath).Save(formPdfPath);
Which works as expected except for one thing: values which are calculated from formulas show up in the PDF as if they were never calculated.
From Gembox's site , it says "Formulas can't be exported to CSV, HTML, PDF or XPS file formats."
However, I do not want to export the formulas, I just want the values present in the cell. Is there a workaround for this? Some way of forcing formulas to be calculated before the conversion to PDF?
EDIT 28-09-2016:
We have released a new version of GemBox.Spreadsheet (version 4.1) in which we implemented a support for cell formula calculation, see the version history page.
Also, you can find the calculation example here.
ORIGINAL ANSWER
Unfortunately the problem is that currently GemBox.Spreadsheet (version 3.9) does not have a calculation engine.
In other words it is able to read the last calculated values from the input file, but it's unable to recalculate formula results on its own.
Note that we do have this feature request in our collection and please feel free to vote for it in order to boost its priority.
But at this moment I cannot tell you exactly when it will be implemented, this feature is not in our current roadmap.
- How to perform addition of two vectors of 8-bit integers with a single addition in C/C++
- GNU RISC-V Embedded GCC throws "x ISA extension `xw' must be set with the versions" error
- How to implement variable sized array within C struct
- Counting pulses using a swiss flow meter with an Arduino, how is it done?
- How to create a folder in C (need to run on both Linux and Windows)
- Is there any way to compute the width of an integer type at compile-time?
- What kind of implementation can I use for a static associative array on a vintage system with very limited resources?
- How can I initialize all members of an array to the same value?
- Is C notably faster than C++
- How to get the Windows SDK version number a program is compiling with at compile time
- Confused by difference between expression inside if and expression outside if
- Equivalent of atoi for unsigned integers
- k&r: Exercise 1-18. Program takes input but doesnt produce any output?
- Using in C thrd_sleep() to either wait for time or interrupt by signal. Example?
- How to get the sign, mantissa and exponent of a floating point number
- How can I compute `exp(x)/2` when `x` is large?
- c programming: answer always equates to 0
- Is it possible to access a parameter of a function from another function in C?
- Will this expression evaluate to true or false (1 or 0) in C?
- What Is the Return Value of strcspn() When Str1 Does not Contain Str2?
- Mapping a numeric range onto another
- Signalled and non-signalled state of event
- Why is faster to do a branch than a lookup?
- Avoid security.ArrayBound warning when using container_of
- Forcing 64-bit long doubles?
- "error: redeclaration of 'myVariable' with no linkage:" - what's the linkage?
- Branchlessly map one list of integers to another
- SQLBindCol for long integer value on 64Bit platform?
- What's wrong with my code? CS50 Pset2: Readability
- Is there a way to redirect stdout/stderr to a string?