×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
On Wed, Apr 6, 2016 at 4:06 PM, Darren Strong <darren@xxxxxxxxx> wrote:
[Re: Setting a flag to force recalculation]
I don't know if it helped, but I did this once. If you have a way to test
it, you might add that to your code and see if it tricks the iPhone into
evaluating the formulas.
I suppose it's worth a try, but I would not expect that to work. The
issue is that the viewer program most likely doesn't have any facility
to calculate formulas. It's probably just a pure reader, grabbing
whatever data it can that is written into the file.
This happens to also be one of the major reasons that very few
third-party programs out there actually evaluate Excel formulas. There
are a TON of formulas you'd have to support if you want to do it
right, and you can't guarantee you'll get the math *exactly* the same
as how Excel does it. (Not because you don't know the "proper" way to
calculate a formula, but because you don't know if *Excel* is doing it
*exactly* that way.) And that's assuming you've already successfully
parsed all the references, possibly including named ranges and so
on... it's just a stunning amount of work to re-engineer what Excel
does.
John Y.
midrange.com
