Services & Resources / Wolfram Forums
-----
 /
MathGroup Archive
2005
*January
*February
*March
*April
*May
*June
*July
*August
*September
*October
*November
*December
*Archive Index
*Ask about this page
*Print this page
*Give us feedback
*Sign up for the Wolfram Insider

MathGroup Archive 2005

[Date Index] [Thread Index] [Author Index]

Search the Archive

Re: Re: precission/accuracy in mathlink for excel

  • To: mathgroup at smc.vnet.net
  • Subject: [mg53378] Re: [mg53356] Re: precission/accuracy in mathlink for excel
  • From: Peter Lizak <plizak at gmail.com>
  • Date: Sat, 8 Jan 2005 23:02:38 -0500 (EST)
  • References: <crknom$9fo$1@smc.vnet.net> <200501080739.CAA17712@smc.vnet.net>
  • Reply-to: Peter Lizak <plizak at gmail.com>
  • Sender: owner-wri-mathgroup at wolfram.com

Nopt, not that.

Needed to set $ExcelPrecision.
I just upped it to 10.

On Sat, 8 Jan 2005 02:39:23 -0500 (EST), nafod40 <noneya at business.com> wrote:
> plizak wrote:
> > I have some code running in a spreadsheet on a M-code worksheet in
> > excel.
> >
> > I can call the code in either a VBA macro or in a cell, but it only
> > returns four digits of accuracy.  Yet when I run it in a notebook in
> > Mathematica I get more precision.
> >
> > Is there a way to get more precision?
> 
> Double check the settings in Excel under the Format-Cell dialog box to
> see if you aren't truncating the precision there.
> 
> I use the mathlink, and get full precision coming across.
> 
>


  • Prev by Date: easy question about random numbers
  • Next by Date: Re: Export Animation
  • Previous by thread: Re: precission/accuracy in mathlink for excel
  • Next by thread: Evaluation of NSum arguments