Re: getting formula Cell values

Thank you for your reply. This procedure is working fine. But it is
there any other way of getting those values other than saving the
workbook using Excel and reopening using jxl.

Rayudu.
--- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com, "Bill Seddon&quot; <bill.seddon...> wrote:
&gt;
> If you create a workbook using JXL, open it in Excel (where the correct
> values will be displayed), save the workbooks from within Excel and then
>; re-open in JXL you will see the numbers Excel has saved into the
> respective formula records. But you have to save in Excel.
>
>
>
> If you follow these steps and you do not see correct values you need to
> look at what you are doing as these are commonly used steps and one of
> them is going wrong or the file you are opening/creating not the one you
> think it is.
>
>
>
>
>
> From: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com [mailto: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com] On
> Behalf Of avsrit2005
> Sent: 07 July 2008 09:48
&gt; To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com
&gt; Subject: [JExcelApi] Re: getting formula Cell values
&gt;
>
>
> But the workbook is displaying those values correctly... is there any
> other way of getting those values.
>
> Rayudu
&gt; -- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>; ,
> "Bill Seddon&quot; <bill.seddon> wrote:
&gt; >
>;
> > JXL doesn't compute formulas so what number can it put into the value
&gt; > field of the formula record other than zero?
&gt; >
> > Bill
> >
> >
> >
> > From: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>;
> [mailto: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>; ]
> On
> > Behalf Of avsrit2005
> > Sent: 07 July 2008 09:27
&gt; > To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>;
> > Subject: [JExcelApi] getting formula Cell values
&gt; >
> >
> >
> > Hi,
> > I have a problem in reading the formula cell content.This is the
> > case only with The workbook that is modified using jxl .For example If
> > a new row is inserted/deleted to the worksheet which contains a
> > formula and that workbook is closed. If this workbook is reopened and
> > if I try to get the content of a formula cell it is returning the
> > value 0 if it is a Numerical Formula cell.(but returning the Formula
> > correctly), can anybody help
>; >
> > Thanks in advance
> >
> > Rayudu.
> >
>;

Messages in this topic (5) Reply (via web post) | Start a new topic

.

--- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com, "avsrit2005"; <avsrit2005...> wrote:
&gt;
> Thank you for your reply. This procedure is working fine. But it is
> there any other way of getting those values other than saving the
> workbook using Excel and reopening using jxl. When I compare the two
workboks using Excel-Properties, the workbook property(which is saved
by jxl) shows 'saved' option property to false where the other one
which is saved by Excel shows it as true.
&gt;
> Rayudu.
> --- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com, "Bill Seddon&quot; <bill.seddon> wrote:
&gt; >
>; > If you create a workbook using JXL, open it in Excel (where the
correct
> > values will be displayed), save the workbooks from within Excel
and then
>; > re-open in JXL you will see the numbers Excel has saved into the
> > respective formula records. But you have to save in Excel.
> >
> >
> >
> > If you follow these steps and you do not see correct values you
need to
> > look at what you are doing as these are commonly used steps and one of
> > them is going wrong or the file you are opening/creating not the
one you
> > think it is.
> >
> >
> >
> >
> >
> > From: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com [mailto: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com] On
> > Behalf Of avsrit2005
> > Sent: 07 July 2008 09:48
&gt; > To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com
&gt; > Subject: [JExcelApi] Re: getting formula Cell values
&gt; >
> >
> >
> > But the workbook is displaying those values correctly... is there any
> > other way of getting those values.
> >
> > Rayudu
&gt; > -- In JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>; ,
> > "Bill Seddon&quot; <bill.seddon> wrote:
&gt; > >
>; >
> > > JXL doesn't compute formulas so what number can it put into the
value
> > > field of the formula record other than zero?
&gt; > >
> > > Bill
> > >
> > >
> > >
> > > From: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>;
> > [mailto: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com
&lt;mailto:JExcelApi%40yahoogroups.com> ]
> > On
> > > Behalf Of avsrit2005
> > > Sent: 07 July 2008 09:27
&gt; > > To: JExcelApi%40yahoogroups.com">JExcelApiyahoogroups.com <mailto:JExcelApi%40yahoogroups.com>;
> > > Subject: [JExcelApi] getting formula Cell values
&gt; > >
> > >
> > >
> > > Hi,
> > > I have a problem in reading the formula cell content.This is the
> > > case only with The workbook that is modified using jxl .For
example If
> > > a new row is inserted/deleted to the worksheet which contains a
> > > formula and that workbook is closed. If this workbook is
reopened and
> > > if I try to get the content of a formula cell it is returning the
> > > value 0 if it is a Numerical Formula cell.(but returning the Formula
> > > correctly), can anybody help
>; > >
> > > Thanks in advance
> > >
> > > Rayudu.
> > >
>; >
>;

Messages in this topic (6) Reply (via web post) | Start a new topic

.

Messages in this topic (7) Reply (via web post) | Start a new topic

.