maik miorandi

Greenhorn
+ Follow
since May 09, 2016
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
1
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by maik miorandi

Seems like it depens form your system settings:
https://www.excel-exercise.com/comma-or-semicolon-in-excel-formula/

For the ^ symbol, i have no clues
But I was able so replace it with the POWER function:
IF((H61-H60)>=0,H61-H60,(POWER(10,D61)+H61-H60))
instead of
IF((H61-H60)>=0,H61-H60,(10^D61)+H61-H60))

I wonder if there is any formula syntax guide around...

prinz reyes wrote:thanks for the reply..i have found the solution..

instead of using ; i used comma(,) in the formula.

so instead of IF(C53=0; 0; C52/C53*100) it should be this way IF(C53=0,  0, C52/C53*100) .

i don't know how it happened but it worked!

thanks for your response!i really appreciate!



I stumbled across the same problem: using , instead of ; worked, but i don't know why...
Now it gives me an error on the ^ symbol. Maybe is there another character to use instead of ^ ??

I have searched around if there is a syntax guide, but I haven't found anything =(
Hi guys, I am using jxl to modify existing excel files, but i stumbled across a problem


I read the file and get my WritableSheet named "foglio", then i get my cell as following:


If the cell has a "Label" cell type, i can write in it using this:

But if the cell has an "Empty" cell type, i cannot write in it (i get a "java.lang.ClassCastException: jxl.write.Blank cannot be cast to jxl.write.Label")

So how can i change the cell type? The Cell class has no setType method or similar...

Any idea about it?
Thanks in advance