Grid - Registered Users - Helpdesk
getting formula to work
Thread Starter: Rael Bauer Started: 6/25/2008 11:02 PM UTC
Replies: 5
6/25/2008 11:02 PM UTC
getting formula to work
Reply Quote

Rael Bauer

Hi,

 Profgrid1.CellByName('A1').Value := '$30';
 Profgrid1.CellByName('B1').Value := '8';
 Profgrid1.CellByName('C1').Formula := 'A1*B1';

C1 shows #Value!.

What do I need to do to get the formula to work (i.e. treat A1 as a number)? and can I even get it to show the '$'?

Thanks
Rael
6/26/2008 12:21 PM UTC
Re: getting formula to work
Reply Quote

profgrid.com

Hi Rael:

Profgrid1.CellByName('A1').Value := CompToCurrency(30);
Profgrid1.CellByName('B1').Value := 8;
Profgrid1.CellByName('C1').Formula := 'A1*B1';


-Nicholas
6/26/2008 2:17 PM UTC
Re: getting formula to work
Reply Quote

Rael Bauer

Is there a way for the end user to achieve this (i.e. not via code)?

The user is able to set the format string.

Rael


"profgrid.com" <helpdesk@profgrid.com> wrote in message news:6d8c0b5b$24750096$2804@vlad...
Hi Rael:

Profgrid1.CellByName('A1').Value := CompToCurrency(30);
Profgrid1.CellByName('B1').Value := 8;
Profgrid1.CellByName('C1').Formula := 'A1*B1';


-Nicholas
6/28/2008 12:30 PM UTC
Re: getting formula to work
Reply Quote

profgrid.com

The end user should simply enter a dollar sign along with the number in the inplace editor:
$30
or
30$


-Nicholas
6/28/2008 7:42 PM UTC
Re: getting formula to work
Reply Quote

Rael Bauer

The end user should simply enter a dollar sign along with the number in the inplace editor:
$30

This does not work for me:
In  a new project I add a profgrid, set SpreadsheetEnabled and Spreadsheet headers to true.
Then Run

I type in A1: "$30"
B1: "8"
C1: "=A1*B1"

C1 says #VALUE!

-Rael
6/29/2008 1:55 PM UTC
Re: getting formula to work
Reply Quote

profgrid.com

If your regional and language options (in Control Panel) are set to South
Africa, then your currency symbol is R (not $). So either enter your native
currency symbol (which is R) or change the currency symbol in Control Panel
to dollar sign.


-Nicholas