Public bug reported:
Using the Settings of SMSListener to set the port number, we can only
select upto port 15 using the drop down. Some computers seem to allocate
the GSM modem to a higher COM port and hence the GUI does not have any
way to save this setting.
The /.smslistener/SMSListener.inf ha
Public bug reported:
SMSListener throws ClassCastException and stops processing messages
after a operator flash message is received. Operator flash messages are
commonly sent and should be ignored by SMSListener.
** Affects: dhis2
Importance: Critical
Assignee: Saptarshi (sunbiz)
That's a question to resolve the problem as example below :
I've got three cells as A1, B1 and C1
A1 contains value as 8 (A1 = 8)
B1 contains value as 10 (B1 = 10)
and:
C1 = A1 + B1
So, how can i get the calculated value as 18 from input formula string "A1 +
B1" by* jxl *or *POI*
p.s: I cou
in POI place formula like this: A1 + B1 . Note no need for equal = sign.
murod
From: Hieu Dang Duy
To: dhis2-devs@lists.launchpad.net
Sent: Monday, June 29, 2009 11:23:35 AM
Subject: [Dhis2-devs] How to get the calculated value from an input formula
string ?
Oh, (so supsire) hi Murod !
I mean which method in which class either POI or JXL using for input formula
string ?
Can u give an sample ?
Thank a lot !
On Mon, Jun 29, 2009 at 5:26 PM, Murodullo Latifov
wrote:
> in POI place formula like this: A1 + B1 . Note no need for equal = sign.
>
> murod
Hi
I don't know if I have the right understanding of this, but please do
remember that POI and JXL are only wrappers around the file format -
they do not replace the formula engine in the spreadsheet application.
So if you create a spreadsheet using your application (in combination
with the JXL or
Hi,
Have you looked at this part of sample code I sent you earlier:
String celFormula1 = "C30+C31+C35+C36+C37+C38+C39+C40+C41+C42";
r = s.getRow(42);
c = r.createCell((short)2);
c.setCellFormula(celFormula1);
This will do all, no need
Oh, Nice to see both of you (Murod and Bob) again at this issue.
[Hehe, I'm so fun]
Thanks for your breaking idea, Bob.
I understood your opinion about this.
"When you save again the calculated values
will be saved" - Bob said right, the calculated values which is saved after
re-open the generat
2009/6/29 Murodullo Latifov :
>
> Hi,
>
> Have you looked at this part of sample code I sent you earlier:
> String celFormula1 = "C30+C31+C35+C36+C37+C38+C39+C40+C41+C42";
>
> r = s.getRow(42);
> c = r.createCell((short)2);
> c.setCellFormula(celFormula1)
2009/6/29 Hieu Dang Duy :
> Oh, Nice to see both of you (Murod and Bob) again at this issue.
>
> [Hehe, I'm so fun]
>
> Thanks for your breaking idea, Bob.
> I understood your opinion about this.
>
> "When you save again the calculated values
> will be saved" - Bob said right, the calculated values
In POI you can do it by:
String celFormula1 = "SUM( ROUND( DIV(RAND(WHATEVER) ) ) )";
String celFormula1 = "DAYS360(NOW(),C1, FALSE)";
String celFormula1 = "ANY SUPPORTED EXCEL FORMULA"; depending which version of
excel document you are using.
r = s.getRow(42);
c = r.createCe
Hi
2009/6/29 Murodullo Latifov :
>
> In POI you can do it by:
> String celFormula1 = "SUM( ROUND( DIV(RAND(WHATEVER) ) ) )";
> String celFormula1 = "DAYS360(NOW(),C1, FALSE)";
> String celFormula1 = "ANY SUPPORTED EXCEL FORMULA"; depending which version
> of excel document you are using.
>
revno: 400
committer: Lars Helge Oeverland larshe...@gmail.com
branch nick: trunk
timestamp: Mon 2009-06-29 17:07:39 +0200
message:
Upgraded to staxwax 1.0.6
modified:
dhis-2/pom.xml
=== modified file 'dhis-2/pom.xml'
--- dhis-2/pom.
Dear Murod and Bob,
Murod, do you remember this mail ?
-- Forwarded message --
From: Hieu Dang Duy
Date: Mon, Jun 22, 2009 at 5:47 PM
Subject: Re: [Dhis2-devs] Needed for support with jxl package
To: Murodullo Latifov
Cc: bobjolli...@gmail.com, dhis2-devs@lists.launchpad.net
Hi Hieu,
Yes, that was answer to your question. If you had chance to look here
http://poi.apache.org/spreadsheet/eval.html you could get some helpful tips.
When you clarified what you really want, answer was to use formula from its
source, not the reference (e.g. if you had somewhere "A1+B1" pla
15 matches
Mail list logo
