The NoteTab Clips List is a Public Group with 2007 members.
 The NoteTab Clips List

 Public Group,
 2007 members
Primary Navigation
New Syntax of ^$Calc$ in Ntb 7.01
Expand Messages
 0 Attachment
In the Basic Group, message #22790, Wayne wrote...
> That leads to results some people may find unexpected.
I agree with Wayne that the new calculation in Ntb 7.01 is an improvement. But I also agree that it might "lead to some unexpected results". For example,...
> line 1.2*3=3.6 (Wayne)
comes to 36 on my system caused by German Windows region setting.
Consequently, we have to pay much more attention to the formatting of numbers.
Also, I'm afraid we'll have some trouble with old clips containing ^$Calc$. And, possibly, we'll see some misunderstandings caused by different Windows region settings when exchanging clips in this Clip Group.
Though I made a lot of tests with ^$Calc$ during NT 7.01 betatest, I'm still learning. So I created the following clip. Maybe you'll find it helpful to find out how Ntb 7.01 is processing different formattings on your system.
It deliberately contains some mistakes in order to see their effect  for example, dot and comma in different order.
I'm still playing around with that clip and even more examples. Please let us know if you encounter more issues worth mentioning.
Regards,
Flo
Test Clip

^!InsertText Expl Number Options Result^P
^!InsertText [1] 1000 [none] ^$Calc(1000/1)$^P
^!InsertText [2] 1000 [0;.] ^$Calc(1000/1;0;.)$^P
^!InsertText [3] 1000 [0;.,] ^$Calc(1000/1;0;.,)$^P
^!InsertText [4] 1000 [0;,] ^$Calc(1000/1;0;,)$^P
^!InsertText [5] 1000 [2;.] ^$Calc(1000/1;2;.)$^P
^!InsertText [6] 1000 [2;.,] ^$Calc(1000/1;2;.,)$^P
^!InsertText [7] 11000 [none] ^$Calc(11000/1)$^P
^!InsertText [8] 11000 [2;.] ^$Calc(11000/1;2;.)$^P
^!InsertText [9] 11000 [2;,] ^$Calc(11000/1;2;,)$^P
^!InsertText [10] 11000 [2;.,] ^$Calc(11000/1;2;.,)$^P
^!InsertText [11] 11,000.00 [2;.] ^$Calc(11,000.00/1;2;.)$^P
^!InsertText [12] 11,000 [0;.,] ^$Calc(11,000/1;0;.,)$^P
^!InsertText [13] 11.000 [2;.,] ^$Calc(11.000/1;2;.,)$^P
^!InsertText [14] 9999.00 [2;.,] ^$Calc(9999.00/1;2;.,)$^P
^!InsertText [15] 9999.50 [2;.,] ^$Calc(9999.50/1;2;.,)$^P
^!InsertText [16] 9999.50 [2;,.] ^$Calc(9999.50/1;2;,.)$^P
^!InsertText [17] 50.000,00 [2;,.] ^$Calc(50.000,00/1;2;,.)$^P
^!InsertText [18] 50.000,00 [2;.,] ^$Calc(50.000,00/1;2;.,)$^P
^!InsertText [19] 50,000.00 [2;.,] ^$Calc(50,000.00/1;2;.,)$^P
^!InsertText [20] 50,000.00 [2;,.] ^$Calc(50,000.00/1;2;,.)$^P
^!InsertText [21] 50,000.00 [2;] ^$Calc(50,000.00/1;2)$^P
^!InsertText [22] 7/11 [3;] ^$Calc(7/11;3)$^P
^!InsertText [23] 10000/0.5 [0;.] ^$Calc(10000/0.5;0;.)$^P
^!Set %t%=^%THOUSAND_SYMB%
^!Set %d%=^%DECIMAL_SYMB%
^!InsertText [24] 50t000d00 [2;,.] ^$Calc(50^%t%000^%d%00/1;2;,.)$^P
 end of clip
I hope it will survive the posting to Yahoo ;)
On my system, the result is:
Expl Number Options Result
[1] 1000 [none] 1000
[2] 1000 [0;.] 1000
[3] 1000 [0;.,] 1,000
[4] 1000 [0;,] 1000
[5] 1000 [2;.] 1000.00
[6] 1000 [2;.,] 1,000.00
[7] 11000 [none] 11.000
[8] 11000 [2;.] 11000.00
[9] 11000 [2;,] 11000,00
[10] 11000 [2;.,] 11,000.00
[11] 11,000.00 [2;.] [error in expression]
[12] 11,000 [0;.,] 11,000
[13] 11.000 [2;.,] 11.00
[14] 9999.00 [2;.,] 9,999.00
[15] 9999.50 [2;.,] 9,999.50
[16] 9999.50 [2;,.] 999.950,00
[17] 50.000,00 [2;,.] 50.000,00
[18] 50.000,00 [2;.,] 50.00
[19] 50,000.00 [2;.,] 50,000.00
[20] 50,000.00 [2;,.] 50,00
[21] 50,000.00 [2;] 50,00
[22] 7/11 [3;] 0,636
[23] 10000/0.5 [0;.] 20000
[24] 50t000d00 [2;,.] 50.000,00 0 Attachment
Wow. This ControlE feature used to work simply and consistently but it is now a horror. In just a few quick tests, such as
3*1.75=5.25
this is 3*1.75=<do cntrle here>
highlights .25\Rth and says value can not be evaluated
with a little more playing contrle started deleting seemingly random text.
Also, after scrolling my screen, the cursor was HERE but the delete key was deleting text THERE.
I didn't test any farther than interactive only, but I'm sorry to say it's not good.
Joy
 In ntbclips@yahoogroups.com, "flo.gehrke" <flo.gehrke@...> wrote:
>
> In the Basic Group, message #22790, Wayne wrote...
>
> > That leads to results some people may find unexpected.
>
> I agree with Wayne that the new calculation in Ntb 7.01 is an improvement. But I also agree that it might "lead to some unexpected results". For example,...
>
> > line 1.2*3=3.6 (Wayne)
>
> comes to 36 on my system caused by German Windows region setting.
>
> Consequently, we have to pay much more attention to the formatting of numbers.
 snip  0 Attachment
Hi Flo,
>> That leads to results some people may find unexpected.
It's true that regions using a comma instead of a dot for a decimal
>
> I agree with Wayne that the new calculation in Ntb 7.01 is an
> improvement. But I also agree that it might "lead to some unexpected
> results". For example,...
>
>> line 1.2*3=3.6 (Wayne)
>
> comes to 36 on my system caused by German Windows region setting.
symbol will produce incorrect results. But the vast majority of NoteTab
users won't experience this issue.
> Consequently, we have to pay much more attention to the formatting of
Only if you plan to share Clips with users in other regions from you and
> numbers.
that use different decimal and digit grouping symbols. And NoteTab
provides the necessary features to deal with that.
> Also, I'm afraid we'll have some trouble with old clips containing
True. Users sharing clips using ^$Calc should consider adding the new
> ^$Calc$. And, possibly, we'll see some misunderstandings caused by
> different Windows region settings when exchanging clips in this Clip
> Group.
parameter for decimal and digit grouping symbols.
> Though I made a lot of tests with ^$Calc$ during NT 7.01 betatest,
Note to readers: in Germany the decimal symbol is a comma and the digit
> I'm still learning. So I created the following clip. Maybe you'll
> find it helpful to find out how Ntb 7.01 is processing different
> formattings on your system.
>
> It deliberately contains some mistakes in order to see their effect
>  for example, dot and comma in different order.
>
> I'm still playing around with that clip and even more examples.
> Please let us know if you encounter more issues worth mentioning.
grouping symbol is a dot. It's the exact opposite from the US format.

Regards,
Eric Fookes
http://www.fookes.com/ 0 Attachment
Hi Joy,
It works fine in NoteTab Pro, but there does seem to be a problem in
NoteTab Light/Std. Sorry about that. However, the old method of
selecting the expression first works just the same as in previous versions.

Regards,
Eric Fookes
http://www.fookes.com/
On 15/08/2012 19:00, joy8388608 wrote:
> Wow. This ControlE feature used to work simply and consistently but it is now a horror. In just a few quick tests, such as
>
> 3*1.75=5.25
> this is 3*1.75=<do cntrle here>
> highlights .25\Rth and says value can not be evaluated
>
> with a little more playing contrle started deleting seemingly random text.
>
> Also, after scrolling my screen, the cursor was HERE but the delete key was deleting text THERE.
>
> I didn't test any farther than interactive only, but I'm sorry to say it's not good.
>
> Joy 0 Attachment
Eric Fookes wrote:> Note to readers: in Germany the decimal symbol is a
NO IT IS NOT! Or it only is for those (actually a majority even in
> comma and the digit grouping symbol is a dot.
government agencies) who hail Bill Gates and Microsoft as arbiters over
spelling and not authoritative dictionaries and official industry
standards. The digit grouping symbol in Germany is the space and nothing
but the space, anything alse is WRONG.
Eric, you have the new variables ^%DECIMAL_SYMB% and ^%THOUSAND_SYMB%.
If you were to make those writeable and storeable in setup, just preset
with the Windows values, every user would be able to set Calc up
correctly for their own usage.
For myself I've set all my machines up with an English user interface
and international number standards for a long time. I learnt programming
long before I owned my first own computer so that nothing else seems
natural. I've always seen localisation as eminently silly. Menu entries
are NOT natural language. If you ask normal users claiming to understand
their programs what the terms mean, you'll draw nothing but blanks.
These are technical terms for computing and have to be learnt anyway, so
what's the disadvantage in learning the correct and common term in the
first place instead of some pseudoGerman noone understands?
Axel 0 Attachment
Flo
Good idea with the test calc clip. Since I would be doing this for myself anyway, I took the liberty of adding to your idea.
Also, the syntax specifies the final option be in quotes so I corrected that just in case.
Here is the modified clip and results for my system in the US.
Very interesting and a lot to "watch out" for.
Joy
^!Set %t%=^%THOUSAND_SYMB%
^!Set %d%=^%DECIMAL_SYMB%
^!InsertText On my system, %DECIMAL_SYMB% (%d%) is (^%d%) and %THOUSAND_SYMB% (%t%) is (^%t%)^P^P
^!InsertText Expl Number Options Result^P
^!InsertText [010] 1000 [none] ^$Calc(1000/1)$^P
^!InsertText [020] 1000 [0;"."] ^$Calc(1000/1;0;".")$^P
^!InsertText [030] 1000 [0;".,"] ^$Calc(1000/1;0;".,")$^P
^!InsertText [040] 1000 [0;","] ^$Calc(1000/1;0;",")$^P
^!InsertText [050] 1000 [2;"."] ^$Calc(1000/1;2;".")$^P
^!InsertText [060] 1000 [2;".,"] ^$Calc(1000/1;2;".,")$^P
^!InsertText [070] 11000 [none] ^$Calc(11000/1)$^P
^!InsertText [080] 11000 [0;""] ^$Calc(11000/1;0;"")$^P
^!InsertText [090] 11000 [0;" "] ^$Calc(11000/1;0;" ")$^P
^!InsertText [100] 11000 [0;" "] ^$Calc(11000/1;0;" ")$^P
^!InsertText [110] 11000 [0;""] ^$Calc(11000/1;0;"")$^P
^!InsertText [120] 11000 [0;"."] ^$Calc(11000/1;0;".")$^P
^!InsertText [130] 11000 [0;".,"] ^$Calc(11000/1;0;".,")$^P
^!InsertText [140] 11000 [2;"."] ^$Calc(11000/1;2;".")$^P
^!InsertText [150] 11000 [2;","] ^$Calc(11000/1;2;",")$^P
^!InsertText [160] 11000 [2;".,"] ^$Calc(11000/1;2;".,")$^P
^!InsertText [170] 11000 [2;""] ^$Calc(11000/1;2;"")$^P
^!InsertText [171] 11000 [2;". "] ^$Calc(11000/1;2;". ")$^P
^!InsertText [172] 11000 [2;" ,"] ^$Calc(11000/1;2;" ,")$^P
^!InsertText [180] 11000.00 [none] ^$Calc(11000.00/1)$^P
^!InsertText [190] 11000.00 [0;""] ^$Calc(11000.00/1;0;"")$^P
^!InsertText [200] 11000.00 [0;" "] ^$Calc(11000.00/1;0;" ")$^P
^!InsertText [210] 11000.00 [0;" "] ^$Calc(11000.00/1;0;" ")$^P
^!InsertText [220] 11000.00 [0;""] ^$Calc(11000.00/1;0;"")$^P
^!InsertText [230] 11000.00 [0;"."] ^$Calc(11000.00/1;0;".")$^P
^!InsertText [240] 11000.00 [0;".,"] ^$Calc(11000.00/1;0;".,")$^P
^!InsertText [250] 11000.00 [2;"."] ^$Calc(11000.00/1;2;".")$^P
^!InsertText [260] 11000.00 [2;","] ^$Calc(11000.00/1;2;",")$^P
^!InsertText [270] 11000.00 [2;".,"] ^$Calc(11000.00/1;2;".,")$^P
^!InsertText [280] 11000.00 [2;""] ^$Calc(11000.00/1;2;"")$^P
^!InsertText [281] 11000.00 [2;". "] ^$Calc(11000.00/1;2;". ")$^P
^!InsertText [282] 11000.00 [2;" ,"] ^$Calc(11000.00/1;2;" ,")$^P
^!InsertText [290] 11,000 [none] ^$Calc(11,000/1)$^P
^!InsertText [300] 11,000 [0;""] ^$Calc(11,000/1;0;"")$^P
^!InsertText [310] 11,000 [0;" "] ^$Calc(11,000/1;0;" ")$^P
^!InsertText [320] 11,000 [0;" "] ^$Calc(11,000/1;0;" ")$^P
^!InsertText [330] 11,000 [0;""] ^$Calc(11,000/1;0;"")$^P
^!InsertText [340] 11,000 [0;"."] ^$Calc(11,000/1;0;".")$^P
^!InsertText [350] 11,000 [0;".,"] ^$Calc(11,000/1;0;".,")$^P
^!InsertText [360] 11,000 [2;"."] ^$Calc(11,000/1;2;".")$^P
^!InsertText [370] 11,000 [2;","] ^$Calc(11,000/1;2;",")$^P
^!InsertText [380] 11,000 [2;".,"] ^$Calc(11,000/1;2;".,")$^P
^!InsertText [390] 11,000 [2;""] ^$Calc(11,000/1;2;"")$^P
^!InsertText [391] 11,000 [2;". "] ^$Calc(11,000/1;2;". ")$^P
^!InsertText [392] 11,000 [2;" ,"] ^$Calc(11,000/1;2;" ,")$^P
^!InsertText [400] 11,000.00 [none] ^$Calc(11,000.00/1)$^P
^!InsertText [410] 11,000.00 [0;""] ^$Calc(11,000.00/1;0;"")$^P
^!InsertText [420] 11,000.00 [0;" "] ^$Calc(11,000.00/1;0;" ")$^P
^!InsertText [430] 11,000.00 [0;" "] ^$Calc(11,000.00/1;0;" ")$^P
^!InsertText [440] 11,000.00 [0;""] ^$Calc(11,000.00/1;0;"")$^P
^!InsertText [450] 11,000.00 [0;"."] ^$Calc(11,000.00/1;0;".")$^P
^!InsertText [460] 11,000.00 [0;".,"] ^$Calc(11,000.00/1;0;".,")$^P
^!InsertText [470] 11,000.00 [2;"."] ^$Calc(11,000.00/1;2;".")$^P
^!InsertText [480] 11,000.00 [2;","] ^$Calc(11,000.00/1;2;",")$^P
^!InsertText [490] 11,000.00 [2;".,"] ^$Calc(11,000.00/1;2;".,")$^P
^!InsertText [500] 11,000.00 [2;""] ^$Calc(11,000.00/1;2;"")$^P
^!InsertText [501] 11,000.00 [2;". "] ^$Calc(11,000.00/1;2;". ")$^P
^!InsertText [502] 11,000.00 [2;" ,"] ^$Calc(11,000.00/1;2;" ,")$^P
^!InsertText [510] 11,000.22 [none] ^$Calc(11,000.22/1)$^P
^!InsertText [520] 11,000.22 [0;""] ^$Calc(11,000.22/1;0;"")$^P
^!InsertText [530] 11,000.22 [0;" "] ^$Calc(11,000.22/1;0;" ")$^P
^!InsertText [540] 11,000.22 [0;" "] ^$Calc(11,000.22/1;0;" ")$^P
^!InsertText [550] 11,000.22 [0;""] ^$Calc(11,000.22/1;0;"")$^P
^!InsertText [560] 11,000.22 [0;"."] ^$Calc(11,000.22/1;0;".")$^P
^!InsertText [570] 11,000.22 [0;".,"] ^$Calc(11,000.22/1;0;".,")$^P
^!InsertText [580] 11,000.22 [2;"."] ^$Calc(11,000.22/1;2;".")$^P
^!InsertText [590] 11,000.22 [2;","] ^$Calc(11,000.22/1;2;",")$^P
^!InsertText [600] 11,000.22 [2;".,"] ^$Calc(11,000.22/1;2;".,")$^P
^!InsertText [610] 11,000.22 [2;""] ^$Calc(11,000.22/1;2;"")$^P
^!InsertText [611] 11,000.22 [2;". "] ^$Calc(11,000.22/1;2;". ")$^P
^!InsertText [612] 11,000.22 [2;" ,"] ^$Calc(11,000.22/1;2;" ,")$^P
^!InsertText [620] 9999.00 [2;".,"] ^$Calc(9999.00/1;2;".,")$^P
^!InsertText [630] 9999.50 [2;".,"] ^$Calc(9999.50/1;2;".,")$^P
^!InsertText [640] 9999.50 [2;",."] ^$Calc(9999.50/1;2;",.")$^P
^!InsertText [650] 50.000,00 [2;",."] ^$Calc(50.000,00/1;2;",.")$^P
^!InsertText [660] 50.000,00 [2;".,"] ^$Calc(50.000,00/1;2;".,")$^P
^!InsertText [670] 50,000.00 [2;",."] ^$Calc(50,000.00/1;2;",.")$^P
^!InsertText [680] 50,000.00 [2;""] ^$Calc(50,000.00/1;2;"")$^P
^!InsertText [690] 7/11 [3;""] ^$Calc(7/11;3;"")$^P
^!InsertText [700] 10000/0.5 [0;"."] ^$Calc(10000/0.5;0;".")$^P
^!InsertText [710] 50t000d00 [2;",."] ^$Calc(50^%t%000^%d%00/1;2;",.")$^P
^!InsertText [720] 50,000.00 [2;",."] ^$Calc(50,000.00/1;2;",.")$^P
^!InsertText [730] 50,000.00 [2;".,"] ^$Calc(50,000.00/1;2;",.")$^P
RESULTS
On my system, %DECIMAL_SYMB% (%d%) is (.) and %THOUSAND_SYMB% (%t%) is (,)
Expl Number Options Result
[010] 1000 [none] 1000
[020] 1000 [0;"."] 1000
[030] 1000 [0;".,"] 1,000
[040] 1000 [0;","] 1000
[050] 1000 [2;"."] 1000.00
[060] 1000 [2;".,"] 1,000.00
[070] 11000 [none] 11,000
[080] 11000 [0;""] 11,000
[090] 11000 [0;" "] 11000
[100] 11000 [0;" "] 11000
[110] 11000 [0;""] 11000
[120] 11000 [0;"."] 11000
[130] 11000 [0;".,"] 11,000
[140] 11000 [2;"."] 11000.00
[150] 11000 [2;","] 11000,00
[160] 11000 [2;".,"] 11,000.00
[170] 11000 [2;""] 1100000
[171] 11000 [2;". "] 11000.00
[172] 11000 [2;" ,"] 11,000 00
[180] 11000.00 [none] 11,000
[190] 11000.00 [0;""] 11,000
[200] 11000.00 [0;" "] 11000
[210] 11000.00 [0;" "] 11000
[220] 11000.00 [0;""] 11000
[230] 11000.00 [0;"."] 11000
[240] 11000.00 [0;".,"] 11,000
[250] 11000.00 [2;"."] 11000.00
[260] 11000.00 [2;","] 11000,00
[270] 11000.00 [2;".,"] 11,000.00
[280] 11000.00 [2;""] 1100000
[281] 11000.00 [2;". "] 11000.00
[282] 11000.00 [2;" ,"] 11,000 00
[290] 11,000 [none] 11,000
[300] 11,000 [0;""] 11,000
[310] 11,000 [0;" "] [error in expression]
[320] 11,000 [0;" "] [error in expression]
[330] 11,000 [0;""] [error in expression]
[340] 11,000 [0;"."] [error in expression]
[350] 11,000 [0;".,"] 11,000
[360] 11,000 [2;"."] [error in expression]
[370] 11,000 [2;","] 11,00
[380] 11,000 [2;".,"] 11,000.00
[390] 11,000 [2;""] [error in expression]
[391] 11,000 [2;". "] [error in expression]
[392] 11,000 [2;" ,"] 11,000 00
[400] 11,000.00 [none] 11,000
[410] 11,000.00 [0;""] 11,000
[420] 11,000.00 [0;" "] [error in expression]
[430] 11,000.00 [0;" "] [error in expression]
[440] 11,000.00 [0;""] [error in expression]
[450] 11,000.00 [0;"."] [error in expression]
[460] 11,000.00 [0;".,"] 11,000
[470] 11,000.00 [2;"."] [error in expression]
[480] 11,000.00 [2;","] [error in expression]
[490] 11,000.00 [2;".,"] 11,000.00
[500] 11,000.00 [2;""] [error in expression]
[501] 11,000.00 [2;". "] [error in expression]
[502] 11,000.00 [2;" ,"] 11,000 00
[510] 11,000.22 [none] 11,000.22
[520] 11,000.22 [0;""] 11,000
[530] 11,000.22 [0;" "] [error in expression]
[540] 11,000.22 [0;" "] [error in expression]
[550] 11,000.22 [0;""] [error in expression]
[560] 11,000.22 [0;"."] [error in expression]
[570] 11,000.22 [0;".,"] 11,000
[580] 11,000.22 [2;"."] [error in expression]
[590] 11,000.22 [2;","] [error in expression]
[600] 11,000.22 [2;".,"] 11,000.22
[610] 11,000.22 [2;""] [error in expression]
[611] 11,000.22 [2;". "] [error in expression]
[612] 11,000.22 [2;" ,"] 11,000 22
[620] 9999.00 [2;".,"] 9,999.00
[630] 9999.50 [2;".,"] 9,999.50
[640] 9999.50 [2;",."] 999.950,00
[650] 50.000,00 [2;",."] 50.000,00
[660] 50.000,00 [2;".,"] 50.00
[670] 50,000.00 [2;",."] 50,00
[680] 50,000.00 [2;""] [error in expression]
[690] 7/11 [3;""] 0636
[700] 10000/0.5 [0;"."] 20000
[710] 50t000d00 [2;",."] 50,00
[720] 50,000.00 [2;",."] 50,00
[730] 50,000.00 [2;".,"] 50,00
 In ntbclips@yahoogroups.com, "flo.gehrke" <flo.gehrke@...> wrote:
Calc test clip 0 Attachment
 In ntbclips@yahoogroups.com, "joy8388608" <mycroftj@...> wrote:>
Thanks, Joy, that's great!
> Flo
>
> Good idea with the test calc clip. Since I would be doing this
> for myself anyway, I took the liberty of adding to your idea.
BTW, in my test, the option '[2;""]' wasn't actually meant as two decimals and '' replacing dot and comma. I thought of something like...
[21] 50,000.00 [2;] ^$Calc(50,000.00/1;2)$^P
i.e., two decimals and neither dot nor comma. Perhaps you may want to enlarge your test with that format. Probably, writing "" for that is something different.
Comparing your results...
[010] 1000 [none] 1000 and [070] 11000 [none] 11,000
...I still wonder why '11000' is grouped as '11,000' here but '1000' is not grouped?
Regards,
Flo
P.S. It's always a pleasure to exchange ideas and experiences with you. Unfortunately, there are only a few members out there being prepared to invest so much time and effort!! 0 Attachment
[I still wonder why '11000' is grouped as '11,000' here but '1000' is not grouped?]
The US is one of the most backward countries in the world in terms of weights and measures. There are arbitrary rules
that defy logic. There are only three countries in the world that are not all metric: Myanmar, Liberia, and the US.
(Although some countries still retain remnants of the old, such as pints in Britain.) The US uses an outdated system
brought to the Colonies, then called the 'Imperial' system. But the Brits evolved that to a new version, which the US
did not adopt. That's why there are imperial gallons and US gallons. (Those are the 'old' Imperial gallons.) Yet it is
commonly thought that the US uses the 'Imperial' system. Not true. The US uses the 'US Customary Units' designation to
separate it from the Imperial system, which itself has been abandoned. Most of the professions in the US use the metric
system, while most of the consumer oriented 'stuff' is US Customary. We've crashed satellites due to this issue.
That's the long way of saying that if the number has 4 numbers, you don't add the comma, but if it has 5 or more, you
do. Go figure. The longer the number, the more characters it takes, due to the addition of the commas. (1000=4,
10,000=6) Sigh. I write code that deals with international measurements every day, and find that even the meaning of a
cup is different in different countries. You virtually have to know what country is involved to get any semblance of
accuracy.
Why can't we just all get on the same page?
Regards,
John
RecipeTools Web Site: <http://recipetools.gotdns.com/> http://recipetools.gotdns.com/
From: ntbclips@yahoogroups.com [mailto:ntbclips@yahoogroups.com] On Behalf Of flo.gehrke
Sent: Wednesday, August 15, 2012 18:18
To: ntbclips@yahoogroups.com
Subject: [Clip] Re: New Syntax of ^$Calc$ in Ntb 7.01
 In ntbclips@yahoogroups.com <mailto:ntbclips%40yahoogroups.com> , "joy8388608" <mycroftj@...> wrote:
>
> Flo
>
> Good idea with the test calc clip. Since I would be doing this
> for myself anyway, I took the liberty of adding to your idea.
Thanks, Joy, that's great!
BTW, in my test, the option '[2;""]' wasn't actually meant as two decimals and '' replacing dot and comma. I thought
of something like...
[21] 50,000.00 [2;] ^$Calc(50,000.00/1;2)$^P
i.e., two decimals and neither dot nor comma. Perhaps you may want to enlarge your test with that format. Probably,
writing "" for that is something different.
Comparing your results...
[010] 1000 [none] 1000 and [070] 11000 [none] 11,000
...I still wonder why '11000' is grouped as '11,000' here but '1000' is not grouped?
Regards,
Flo
P.S. It's always a pleasure to exchange ideas and experiences with you. Unfortunately, there are only a few members out
there being prepared to invest so much time and effort!!
[Nontext portions of this message have been removed] 0 Attachment
Hi Axel,
See my comments below...
> Eric Fookes wrote:
Sorry, I should have been more precise and said that those are the
>> Note to readers: in Germany the decimal symbol is a
>> comma and the digit grouping symbol is a dot.
>
> NO IT IS NOT! Or it only is for those (actually a majority even in
> government agencies) who hail Bill Gates and Microsoft as arbiters over
> spelling and not authoritative dictionaries and official industry
> standards. The digit grouping symbol in Germany is the space and nothing
> but the space, anything alse is WRONG.
symbols Windows users in Germany get by default.
> Eric, you have the new variables ^%DECIMAL_SYMB% and ^%THOUSAND_SYMB%.
Why would someone use symbols that are different from what they set in
> If you were to make those writeable and storeable in setup, just preset
> with the Windows values, every user would be able to set Calc up
> correctly for their own usage.
Windows? Doesn't it make more sense to change the Windows regional
settings directly?

Regards,
Eric Fookes
http://www.fookes.com/ 0 Attachment
Hi Joy,
Could you explain why there would be a lot to "watch out" for?
For NoteTabbers in the US and many other countries where a dot
represents a decimal symbol, there will be no noticeable difference from
earlier versions of NoteTab.
The only risk is that someone from a different region designs a Clip
based on his own local instead of using features that make it work
reliably anywhere in the world.

Regards,
Eric Fookes
http://www.fookes.com/
> Flo
>
> Good idea with the test calc clip. Since I would be doing this for myself anyway, I took the liberty of adding to your idea.
>
> Also, the syntax specifies the final option be in quotes so I corrected that just in case.
>
> Here is the modified clip and results for my system in the US.
>
> Very interesting and a lot to "watch out" for.
>
> Joy 0 Attachment
Eric Fookes wrote:> Why would someone use symbols that are different from what they
People do strange things. But seriously, many will choose the region
> set in Windows? Doesn't it make more sense to change the Windows
> regional settings directly?
Germany (which else?) and just not bother to fiddle with individual
details. (How many change defaults at all?). Second they may want the
German standard for Word, Excel (Did you know, that contrary to any
decent spreadsheet by any decent software vendor Excel can't read it's
own files, when written by someone with different Windows (not Excel!)
settings?) but treat Clips more like a programming language, of which,
thank G'd, none was ever localised.
I expect most German Clips users here to have their Windows set up
German and I hope they'll continue to write their clips the comman
standard standard international way to make sharing possible.
Axel 0 Attachment
 In ntbclips@yahoogroups.com, "flo.gehrke" <flo.gehrke@...> wrote:>
Hi Flo,
>  In ntbclips@yahoogroups.com, "joy8388608" <mycroftj@> wrote:
> >
> > Flo
> >
> > Good idea with the test calc clip. Since I would be doing this
> > for myself anyway, I took the liberty of adding to your idea.
>
> Thanks, Joy, that's great!
>
> BTW, in my test, the option '[2;""]' wasn't actually meant as two decimals and '' replacing dot and comma. I thought of something like...
>
> [21] 50,000.00 [2;] calc(50,000.00/1;2)^P
>
> i.e., two decimals and neither dot nor comma. Perhaps you may want to enlarge your test with that format. Probably, writing "" for that is something different.
>
> Comparing your results...
>
> [010] 1000 [none] 1000 and [070] 11000 [none] 11,000
>
> ...I still wonder why '11000' is grouped as '11,000' here but '1000' is not grouped?
>
> Regards,
> Flo
>
>
> P.S. It's always a pleasure to exchange ideas and experiences with you. Unfortunately, there are only a few members out there being prepared to invest so much time and effort!!
Since you had [007] that said [none] I thought you were testing with unsupported characters () just to see what would happen. I frequently do that since (long reason deleted) it's good to know. And I was getting crosseyed. I wanted some decent test cases but didn't want to spend TOO much time...
As for the calc(50,000.00/1;2) case, I believe I covered that in... ah, I didn't, did I? Yes, I have to add cases specifying number of decimals but not the last option as well as some others I haven't taken the time to think of yet. It takes a lot of thought and planning to create a really good test. Writing tests for compilers was one of my first jobs.
Thank you for the compliment. People find the time to do what they like and this is the stuff I like. Besides, there are many others who have contributed much more than I and I figure it's the least I can do to return the favor.
Joy 0 Attachment
Certainly, Eric. Some of the results from my test were surprising and unintuitive to me and probably others. Especially those who are not great in math and/or who have not had much experience programming.
^$Calc(11000/1)$ gives 11,000 and ^$Calc(11,000/1;2;",")$ gives 11,00
^$Calc(11,000.22/1;0;" ")$ gives an error while ^$Calc(11,000.22/1;2;" ,")$ gives 11,000 22
I'm not at my PC so can't yet redo my test by adding cases where the 3rd param is completely omitted so don't know what those will do.
I see now that it seems the 3rd parameter is not only used for output... it is also used to validate and interpret the number (probably all the numbers???) passed to the function. But that makes the 4th example above surprising since the decimal char is passed as a space which is used correctly in the output, but not when validating 11,000.22 like in the 3rd example.
I'm sure I'd see the patterns if I thought long and hard enough and performed many more tests but that's my point... it's not intuitive and, unless someone uses the calc function very often and gets used to it's quirks, there IS a lot to watch out for.
FWIW, I would make some changes in the way it currently works and at the VERY least, provide a lot more documentation to explain EXACTLY how it works in ALL cases but that is, of course, your business. The best thing I can do is create a detailed test program as I've started doing to help me figure out how it works.
I'm also a little concerned that old clips that do not use the 3rd parameter will now return results containing the thousands symbol which may cause problems when that result is fed into the next calculation. But perhaps not I have to test some more.
No offense meant ever. NoteTab is fantastic and I'd be lost without it.
Joy
 In ntbclips@yahoogroups.com, Eric Fookes <egroups@...> wrote:
>
> Hi Joy,
>
> Could you explain why there would be a lot to "watch out" for?
>
> For NoteTabbers in the US and many other countries where a dot
> represents a decimal symbol, there will be no noticeable difference from
> earlier versions of NoteTab.
>
> The only risk is that someone from a different region designs a Clip
> based on his own local instead of using features that make it work
> reliably anywhere in the world.
>
> 
> Regards,
>
> Eric Fookes
> http://www.fookes.com/
>
>
> > Flo
> >
> > Good idea with the test calc clip. Since I would be doing this for myself anyway, I took the liberty of adding to your idea.
> >
> > Also, the syntax specifies the final option be in quotes so I corrected that just in case.
> >
> > Here is the modified clip and results for my system in the US.
> >
> > Very interesting and a lot to "watch out" for.
> >
> > Joy
> 0 Attachment
Hi Joy,
> Certainly, Eric. Some of the results from my test were surprising
In the first example, NoteTab is using your default Windows settings for
> and unintuitive to me and probably others. Especially those who are
> not great in math and/or who have not had much experience
> programming.
>
> ^$Calc(11000/1)$ gives 11,000
numerical symbols. In this case, when a number exceeds 9999, it adds a
digit grouping symbol (a comma in the US). If you don't want numbers
formatted with digit grouping symbols, use this:
^$Calc(11,000/1;^%DECIMAL_SYMB%)$ or ^$Calc(11,000/1;".")$
The double quotes are not necessary, but they make the code clearer.
> and ^$Calc(11,000/1;2;",")$ gives 11,00
In this case, you are telling NoteTab that the decimal symbol is a
comma. So "11,000" is equivalent to "11.000" in the US. You would only
do this if you plan to send your Clips to users wanting a comma as
decimal symbol.
An alternative way to write it, if you intend to share internationally,
is like this:
^$Calc(11^%THOUSAND_SYMB%000/1;2)$
> ^$Calc(11,000.22/1;0;" ")$ gives an error while
Using a space as a symbol will produce unreliable results. The only
> ^$Calc(11,000.22/1;2;" ,")$ gives 11,000 22
valid decimal symbols I know of are a dot or a comma (though there may
be some others). I don't think a space is used anywhere as a decimal
symbol, so why use that?
> I'm not at my PC so can't yet redo my test by adding cases where the
Your default Windows regional symbols are used. In the US, that's a dot
> 3rd param is completely omitted so don't know what those will do.
for the decimal symbol and a comma for the digit grouping symbol.
> I see now that it seems the 3rd parameter is not only used for
It's used for both. Obviously it wouldn't make much sense to use
> output... it is also used to validate and interpret the number
> (probably all the numbers???) passed to the function.
conflicting symbols between input and output.
> I'm sure I'd see the patterns if I thought long and hard enough and
Unless you plan to share Clips with users in other regions, there is no
> performed many more tests but that's my point... it's not intuitive
> and, unless someone uses the calc function very often and gets used
> to it's quirks, there IS a lot to watch out for.
need to use the new parameter.
> FWIW, I would make some changes in the way it currently works and at
To be honest, I think this new feature will only benefit a tiny number
> the VERY least, provide a lot more documentation to explain EXACTLY
> how it works in ALL cases but that is, of course, your business. The
> best thing I can do is create a detailed test program as I've started
> doing to help me figure out how it works.
of NoteTabbers. Those writing Clips with mathematics for users across
regions.
> I'm also a little concerned that old clips that do not use the 3rd
It shouldn't create any problems. The only exception is if you use a
> parameter will now return results containing the thousands symbol
> which may cause problems when that result is fed into the next
> calculation. But perhaps not I have to test some more.
space for the digit grouping symbol, which is valid in some regions.
Invalid symbol characters (like a space decimal symbol or other weird
choices) will produce unexpected results. But why would anyone want to
do that? it defeats the purpose of the parameter.
> No offense meant ever. NoteTab is fantastic and I'd be lost without
Not at all offended. Just trying to understand some of the discussions.
> it.

Regards,
Eric Fookes
http://www.fookes.com/ 0 Attachment
 In ntbclips@yahoogroups.com, Eric Fookes <egroups@...> wrote:>
Eric,
> Hi Joy,...
>
> > I'm also a little concerned that old clips that do not use the 3rd
> > parameter will now return results containing the thousands symbol
> > which may cause problems when that result is fed into the next
> > calculation. But perhaps not I have to test some more.
>
> It shouldn't create any problems. The only exception is if you
> use a space for the digit grouping symbol, which is valid in some
> regions...
Don't we have to remember the calculation of date value integers in this context?
I had to edit clips executing something like this...
^!Set %OldDateValue%=^$GetDateToInt(1.8.2012;d.m.yyyy)$
^!Set %NewDateValue%=^$Calc(^%OldDateValue%+10)$
^!Info New date value is ^%NewDateValue%
^!Info New date is = ^$GetDateFromInt(^%NewDateValue%;d.m.yyyy)$
^$GetDateFromInt$ can't calculate a date value integer like '41.132'. For me, it works fine when changing line #2 to...
^!Set %NewDateValue%=^$Calc(^%OldDateValue%+10;.)$
Maybe some "old hands" will be interested to find out that you changed ^!Inc and ^!Dec too (not mentioned in the WhatsNew.txt). So far, theses commands couldn't deal with a number like '41.132' but now it works fine. The value is returned as a plain integer without dot.
^!Inc and ^!Dec can even deal with numbers in exponential notation now:
^!Set %x%=3e2
^!Info ^%x%=^$Calc(^%x%)$
^!Inc %x%
^!Info New x=^%x%
Regards,
Flo 0 Attachment
 In ntbclips@yahoogroups.com, Eric Fookes <egroups@...> wrote:>
Eric is probably sorry he started the calc function enhancement. :)
> > I'm also a little concerned that old clips that do not use the 3rd
> > parameter will now return results containing the thousands symbol
> > which may cause problems when that result is fed into the next
> > calculation. But perhaps not I have to test some more.
>
> It shouldn't create any problems. The only exception is if you use a
> space for the digit grouping symbol, which is valid in some regions.
> Invalid symbol characters (like a space decimal symbol or other weird
> choices) will produce unexpected results. But why would anyone want to
> do that? it defeats the purpose of the parameter.
> 
> Regards,
>
> Eric Fookes
> http://www.fookes.com/
>
I'm continuing this discussion not for arguing, but for trying to help and pointing out some things.
First, for anyone who has written clips that output numeric reports (as I have) will find the large numbers have grouping commas whereas they did not before. This WILL break clips that are picky about output format and/or output data for input into other programs and routines. I'm sure it's a very small percentage, but still...
Next, I just ran a clip that adds numbers and produces a report. NONE of my calc functions have any parameters and all the individual numbers and totals are in the range of 0 to 9999 at this time. I was surprised and mystified to see some numbers output with a comma and others without even though all the numbers are treated the same way.
Example:
Jan 3324.90 708.30 no commas
Feb 2046.50 296.35 no commas
Mar 1722.25 3320.73 no commas
Apr 344.50 955.67
Tot 8,591.90 6637.12 comma and no comma
(Totals incorrect because I changed the numbers)
I still feel there are many clips out there that will be affected for one reason or another. People are very creative and write clips to do all KINDS of things you'd never expect. I feel the best solution is to NOT have grouping by default.
Finally, for now, I created a much better and more detailed calc test clip for myself and, it may help others. I checked carefully for mistakes, but this is the type of code that makes it easy to miss things.
Joy
; 8:16 PM Friday 08/17/2012
;!Select ALL
;!DeleteSelection
^!Set %t%=^%THOUSAND_SYMB%
^!Set %d%=^%DECIMAL_SYMB%
^!InsertText NoteTab version ^$GetProgVersion$^P
^!InsertText On my system, %DECIMAL_SYMB% (%d%) is (^%d%) and %THOUSAND_SYMB% (%t%) is (^%t%)^P^P
^!InsertText Invalid parameters tested on purpose.^P^P
^!InsertText Test #^TValue^TOptions^TResult^P
^!InsertText [0110] 0.1234 [none] ^$Calc(0.1234/1)$^P
^!InsertText [0115] 0.1234 [0;" "] ^$Calc(0.1234/1;0;" ")$^P
^!InsertText [0120] 0.1234 [0;" "] ^$Calc(0.1234/1;0;" ")$^P
^!InsertText [0125] 0.1234 [0;""] ^$Calc(0.1234/1;0;"")$^P
^!InsertText [0130] 0.1234 [0;""] ^$Calc(0.1234/1;0;"")$^P
^!InsertText [0135] 0.1234 [0;" "] ^$Calc(0.1234/1;0;" ")$^P
^!InsertText [0140] 0.1234 [0;" "] ^$Calc(0.1234/1;0;" ")$^P
^!InsertText [0145] 0.1234 [0;"."] ^$Calc(0.1234/1;0;".")$^P
^!InsertText [0150] 0.1234 [0;". "] ^$Calc(0.1234/1;0;". ")$^P
^!InsertText [0155] 0.1234 [0;" ."] ^$Calc(0.1234/1;0;" .")$^P
^!InsertText [0160] 0.1234 [0;","] ^$Calc(0.1234/1;0;",")$^P
^!InsertText [0165] 0.1234 [0;", "] ^$Calc(0.1234/1;0;", ")$^P
^!InsertText [0170] 0.1234 [0;" ,"] ^$Calc(0.1234/1;0;" ,")$^P
^!InsertText [0175] 0.1234 [0;".,"] ^$Calc(0.1234/1;0;".,")$^P
^!InsertText [0180] 0.1234 [0;",."] ^$Calc(0.1234/1;0;",.")$^P
^!InsertText ^P
^!InsertText [0210] 0.1234 [none] ^$Calc(0.1234/1)$^P
^!InsertText [0215] 0.1234 [1;" "] ^$Calc(0.1234/1;1;" ")$^P
^!InsertText [0220] 0.1234 [1;" "] ^$Calc(0.1234/1;1;" ")$^P
^!InsertText [0225] 0.1234 [1;""] ^$Calc(0.1234/1;1;"")$^P
^!InsertText [0230] 0.1234 [1;""] ^$Calc(0.1234/1;1;"")$^P
^!InsertText [0235] 0.1234 [1;" "] ^$Calc(0.1234/1;1;" ")$^P
^!InsertText [0240] 0.1234 [1;" "] ^$Calc(0.1234/1;1;" ")$^P
^!InsertText [0245] 0.1234 [1;"."] ^$Calc(0.1234/1;1;".")$^P
^!InsertText [0250] 0.1234 [1;". "] ^$Calc(0.1234/1;1;". ")$^P
^!InsertText [0255] 0.1234 [1;" ."] ^$Calc(0.1234/1;1;" .")$^P
^!InsertText [0260] 0.1234 [1;","] ^$Calc(0.1234/1;1;",")$^P
^!InsertText [0265] 0.1234 [1;", "] ^$Calc(0.1234/1;1;", ")$^P
^!InsertText [0270] 0.1234 [1;" ,"] ^$Calc(0.1234/1;1;" ,")$^P
^!InsertText [0275] 0.1234 [1;".,"] ^$Calc(0.1234/1;1;".,")$^P
^!InsertText [0280] 0.1234 [1;",."] ^$Calc(0.1234/1;1;",.")$^P
^!InsertText ^P
^!InsertText [0310] 0.1234 [none] ^$Calc(0.1234/1)$^P
^!InsertText [0315] 0.1234 [2;" "] ^$Calc(0.1234/1;2;" ")$^P
^!InsertText [0320] 0.1234 [2;" "] ^$Calc(0.1234/1;2;" ")$^P
^!InsertText [0325] 0.1234 [2;""] ^$Calc(0.1234/1;2;"")$^P
^!InsertText [0330] 0.1234 [2;""] ^$Calc(0.1234/1;2;"")$^P
^!InsertText [0335] 0.1234 [2;" "] ^$Calc(0.1234/1;2;" ")$^P
^!InsertText [0340] 0.1234 [2;" "] ^$Calc(0.1234/1;2;" ")$^P
^!InsertText [0345] 0.1234 [2;"."] ^$Calc(0.1234/1;2;".")$^P
^!InsertText [0350] 0.1234 [2;". "] ^$Calc(0.1234/1;2;". ")$^P
^!InsertText [0355] 0.1234 [2;" ."] ^$Calc(0.1234/1;2;" .")$^P
^!InsertText [0360] 0.1234 [2;","] ^$Calc(0.1234/1;2;",")$^P
^!InsertText [0365] 0.1234 [2;", "] ^$Calc(0.1234/1;2;", ")$^P
^!InsertText [0370] 0.1234 [2;" ,"] ^$Calc(0.1234/1;2;" ,")$^P
^!InsertText [0375] 0.1234 [2;".,"] ^$Calc(0.1234/1;2;".,")$^P
^!InsertText [0380] 0.1234 [2;",."] ^$Calc(0.1234/1;2;",.")$^P
^!InsertText ^P
^!InsertText [0410] 1234 [none] ^$Calc(1234/1)$^P
^!InsertText [0415] 1234 [0;" "] ^$Calc(1234/1;0;" ")$^P
^!InsertText [0420] 1234 [0;" "] ^$Calc(1234/1;0;" ")$^P
^!InsertText [0425] 1234 [0;""] ^$Calc(1234/1;0;"")$^P
^!InsertText [0430] 1234 [0;""] ^$Calc(1234/1;0;"")$^P
^!InsertText [0435] 1234 [0;" "] ^$Calc(1234/1;0;" ")$^P
^!InsertText [0440] 1234 [0;" "] ^$Calc(1234/1;0;" ")$^P
^!InsertText [0445] 1234 [0;"."] ^$Calc(1234/1;0;".")$^P
^!InsertText [0450] 1234 [0;". "] ^$Calc(1234/1;0;". ")$^P
^!InsertText [0455] 1234 [0;" ."] ^$Calc(1234/1;0;" .")$^P
^!InsertText [0460] 1234 [0;","] ^$Calc(1234/1;0;",")$^P
^!InsertText [0465] 1234 [0;", "] ^$Calc(1234/1;0;", ")$^P
^!InsertText [0470] 1234 [0;" ,"] ^$Calc(1234/1;0;" ,")$^P
^!InsertText [0475] 1234 [0;".,"] ^$Calc(1234/1;0;".,")$^P
^!InsertText [0480] 1234 [0;",."] ^$Calc(1234/1;0;",.")$^P
^!InsertText ^P
^!InsertText [0510] 1234 [none] ^$Calc(1234/1)$^P
^!InsertText [0515] 1234 [1;" "] ^$Calc(1234/1;1;" ")$^P
^!InsertText [0520] 1234 [1;" "] ^$Calc(1234/1;1;" ")$^P
^!InsertText [0525] 1234 [1;""] ^$Calc(1234/1;1;"")$^P
^!InsertText [0530] 1234 [1;""] ^$Calc(1234/1;1;"")$^P
^!InsertText [0535] 1234 [1;" "] ^$Calc(1234/1;1;" ")$^P
^!InsertText [0540] 1234 [1;" "] ^$Calc(1234/1;1;" ")$^P
^!InsertText [0545] 1234 [1;"."] ^$Calc(1234/1;1;".")$^P
^!InsertText [0550] 1234 [1;". "] ^$Calc(1234/1;1;". ")$^P
^!InsertText [0555] 1234 [1;" ."] ^$Calc(1234/1;1;" .")$^P
^!InsertText [0560] 1234 [1;","] ^$Calc(1234/1;1;",")$^P
^!InsertText [0565] 1234 [1;", "] ^$Calc(1234/1;1;", ")$^P
^!InsertText [0570] 1234 [1;" ,"] ^$Calc(1234/1;1;" ,")$^P
^!InsertText [0575] 1234 [1;".,"] ^$Calc(1234/1;1;".,")$^P
^!InsertText [0580] 1234 [1;",."] ^$Calc(1234/1;1;",.")$^P
^!InsertText ^P
^!InsertText [0610] 1234 [none] ^$Calc(1234/1)$^P
^!InsertText [0615] 1234 [2;" "] ^$Calc(1234/1;2;" ")$^P
^!InsertText [0620] 1234 [2;" "] ^$Calc(1234/1;2;" ")$^P
^!InsertText [0625] 1234 [2;""] ^$Calc(1234/1;2;"")$^P
^!InsertText [0630] 1234 [2;""] ^$Calc(1234/1;2;"")$^P
^!InsertText [0635] 1234 [2;" "] ^$Calc(1234/1;2;" ")$^P
^!InsertText [0640] 1234 [2;" "] ^$Calc(1234/1;2;" ")$^P
^!InsertText [0645] 1234 [2;"."] ^$Calc(1234/1;2;".")$^P
^!InsertText [0650] 1234 [2;". "] ^$Calc(1234/1;2;". ")$^P
^!InsertText [0655] 1234 [2;" ."] ^$Calc(1234/1;2;" .")$^P
^!InsertText [0660] 1234 [2;","] ^$Calc(1234/1;2;",")$^P
^!InsertText [0665] 1234 [2;", "] ^$Calc(1234/1;2;", ")$^P
^!InsertText [0670] 1234 [2;" ,"] ^$Calc(1234/1;2;" ,")$^P
^!InsertText [0675] 1234 [2;".,"] ^$Calc(1234/1;2;".,")$^P
^!InsertText [0680] 1234 [2;",."] ^$Calc(1234/1;2;",.")$^P
^!InsertText ^P
^!InsertText [0710] 1,234 [none] ^$Calc(1,234/1)$^P
^!InsertText [0715] 1,234 [0;" "] ^$Calc(1,234/1;0;" ")$^P
^!InsertText [0720] 1,234 [0;" "] ^$Calc(1,234/1;0;" ")$^P
^!InsertText [0725] 1,234 [0;""] ^$Calc(1,234/1;0;"")$^P
^!InsertText [0730] 1,234 [0;""] ^$Calc(1,234/1;0;"")$^P
^!InsertText [0735] 1,234 [0;" "] ^$Calc(1,234/1;0;" ")$^P
^!InsertText [0740] 1,234 [0;" "] ^$Calc(1,234/1;0;" ")$^P
^!InsertText [0745] 1,234 [0;"."] ^$Calc(1,234/1;0;".")$^P
^!InsertText [0750] 1,234 [0;". "] ^$Calc(1,234/1;0;". ")$^P
^!InsertText [0755] 1,234 [0;" ."] ^$Calc(1,234/1;0;" .")$^P
^!InsertText [0760] 1,234 [0;","] ^$Calc(1,234/1;0;",")$^P
^!InsertText [0765] 1,234 [0;", "] ^$Calc(1,234/1;0;", ")$^P
^!InsertText [0770] 1,234 [0;" ,"] ^$Calc(1,234/1;0;" ,")$^P
^!InsertText [0775] 1,234 [0;".,"] ^$Calc(1,234/1;0;".,")$^P
^!InsertText [0780] 1,234 [0;",."] ^$Calc(1,234/1;0;",.")$^P
^!InsertText ^P
^!InsertText [0810] 1,234 [none] ^$Calc(1,234/1)$^P
^!InsertText [0815] 1,234 [1;" "] ^$Calc(1,234/1;1;" ")$^P
^!InsertText [0820] 1,234 [1;" "] ^$Calc(1,234/1;1;" ")$^P
^!InsertText [0825] 1,234 [1;""] ^$Calc(1,234/1;1;"")$^P
^!InsertText [0830] 1,234 [1;""] ^$Calc(1,234/1;1;"")$^P
^!InsertText [0835] 1,234 [1;" "] ^$Calc(1,234/1;1;" ")$^P
^!InsertText [0840] 1,234 [1;" "] ^$Calc(1,234/1;1;" ")$^P
^!InsertText [0845] 1,234 [1;"."] ^$Calc(1,234/1;1;".")$^P
^!InsertText [0850] 1,234 [1;". "] ^$Calc(1,234/1;1;". ")$^P
^!InsertText [0855] 1,234 [1;" ."] ^$Calc(1,234/1;1;" .")$^P
^!InsertText [0860] 1,234 [1;","] ^$Calc(1,234/1;1;",")$^P
^!InsertText [0865] 1,234 [1;", "] ^$Calc(1,234/1;1;", ")$^P
^!InsertText [0870] 1,234 [1;" ,"] ^$Calc(1,234/1;1;" ,")$^P
^!InsertText [0875] 1,234 [1;".,"] ^$Calc(1,234/1;1;".,")$^P
^!InsertText [0880] 1,234 [1;",."] ^$Calc(1,234/1;1;",.")$^P
^!InsertText ^P
^!InsertText [0910] 1,234 [none] ^$Calc(1,234/1)$^P
^!InsertText [0915] 1,234 [2;" "] ^$Calc(1,234/1;2;" ")$^P
^!InsertText [0920] 1,234 [2;" "] ^$Calc(1,234/1;2;" ")$^P
^!InsertText [0925] 1,234 [2;""] ^$Calc(1,234/1;2;"")$^P
^!InsertText [0930] 1,234 [2;""] ^$Calc(1,234/1;2;"")$^P
^!InsertText [0935] 1,234 [2;" "] ^$Calc(1,234/1;2;" ")$^P
^!InsertText [0940] 1,234 [2;" "] ^$Calc(1,234/1;2;" ")$^P
^!InsertText [0945] 1,234 [2;"."] ^$Calc(1,234/1;2;".")$^P
^!InsertText [0950] 1,234 [2;". "] ^$Calc(1,234/1;2;". ")$^P
^!InsertText [0955] 1,234 [2;" ."] ^$Calc(1,234/1;2;" .")$^P
^!InsertText [0960] 1,234 [2;","] ^$Calc(1,234/1;2;",")$^P
^!InsertText [0965] 1,234 [2;", "] ^$Calc(1,234/1;2;", ")$^P
^!InsertText [0970] 1,234 [2;" ,"] ^$Calc(1,234/1;2;" ,")$^P
^!InsertText [0975] 1,234 [2;".,"] ^$Calc(1,234/1;2;".,")$^P
^!InsertText [0980] 1,234 [2;",."] ^$Calc(1,234/1;2;",.")$^P
^!InsertText ^P
^!InsertText [1010] 12345 [none] ^$Calc(12345/1)$^P
^!InsertText [1015] 12345 [0;" "] ^$Calc(12345/1;0;" ")$^P
^!InsertText [1020] 12345 [0;" "] ^$Calc(12345/1;0;" ")$^P
^!InsertText [1025] 12345 [0;""] ^$Calc(12345/1;0;"")$^P
^!InsertText [1030] 12345 [0;""] ^$Calc(12345/1;0;"")$^P
^!InsertText [1035] 12345 [0;" "] ^$Calc(12345/1;0;" ")$^P
^!InsertText [1040] 12345 [0;" "] ^$Calc(12345/1;0;" ")$^P
^!InsertText [1045] 12345 [0;"."] ^$Calc(12345/1;0;".")$^P
^!InsertText [1050] 12345 [0;". "] ^$Calc(12345/1;0;". ")$^P
^!InsertText [1055] 12345 [0;" ."] ^$Calc(12345/1;0;" .")$^P
^!InsertText [1060] 12345 [0;","] ^$Calc(12345/1;0;",")$^P
^!InsertText [1065] 12345 [0;", "] ^$Calc(12345/1;0;", ")$^P
^!InsertText [1070] 12345 [0;" ,"] ^$Calc(12345/1;0;" ,")$^P
^!InsertText [1075] 12345 [0;".,"] ^$Calc(12345/1;0;".,")$^P
^!InsertText [1080] 12345 [0;",."] ^$Calc(12345/1;0;",.")$^P
^!InsertText ^P
^!InsertText [1110] 12345 [none] ^$Calc(12345/1)$^P
^!InsertText [1115] 12345 [1;" "] ^$Calc(12345/1;1;" ")$^P
^!InsertText [1120] 12345 [1;" "] ^$Calc(12345/1;1;" ")$^P
^!InsertText [1125] 12345 [1;""] ^$Calc(12345/1;1;"")$^P
^!InsertText [1130] 12345 [1;""] ^$Calc(12345/1;1;"")$^P
^!InsertText [1135] 12345 [1;" "] ^$Calc(12345/1;1;" ")$^P
^!InsertText [1140] 12345 [1;" "] ^$Calc(12345/1;1;" ")$^P
^!InsertText [1145] 12345 [1;"."] ^$Calc(12345/1;1;".")$^P
^!InsertText [1150] 12345 [1;". "] ^$Calc(12345/1;1;". ")$^P
^!InsertText [1155] 12345 [1;" ."] ^$Calc(12345/1;1;" .")$^P
^!InsertText [1160] 12345 [1;","] ^$Calc(12345/1;1;",")$^P
^!InsertText [1165] 12345 [1;", "] ^$Calc(12345/1;1;", ")$^P
^!InsertText [1170] 12345 [1;" ,"] ^$Calc(12345/1;1;" ,")$^P
^!InsertText [1175] 12345 [1;".,"] ^$Calc(12345/1;1;".,")$^P
^!InsertText [1180] 12345 [1;",."] ^$Calc(12345/1;1;",.")$^P
^!InsertText ^P
^!InsertText [1210] 12345 [none] ^$Calc(12345/1)$^P
^!InsertText [1215] 12345 [2;" "] ^$Calc(12345/1;2;" ")$^P
^!InsertText [1220] 12345 [2;" "] ^$Calc(12345/1;2;" ")$^P
^!InsertText [1225] 12345 [2;""] ^$Calc(12345/1;2;"")$^P
^!InsertText [1230] 12345 [2;""] ^$Calc(12345/1;2;"")$^P
^!InsertText [1235] 12345 [2;" "] ^$Calc(12345/1;2;" ")$^P
^!InsertText [1240] 12345 [2;" "] ^$Calc(12345/1;2;" ")$^P
^!InsertText [1245] 12345 [2;"."] ^$Calc(12345/1;2;".")$^P
^!InsertText [1250] 12345 [2;". "] ^$Calc(12345/1;2;". ")$^P
^!InsertText [1255] 12345 [2;" ."] ^$Calc(12345/1;2;" .")$^P
^!InsertText [1260] 12345 [2;","] ^$Calc(12345/1;2;",")$^P
^!InsertText [1265] 12345 [2;", "] ^$Calc(12345/1;2;", ")$^P
^!InsertText [1270] 12345 [2;" ,"] ^$Calc(12345/1;2;" ,")$^P
^!InsertText [1275] 12345 [2;".,"] ^$Calc(12345/1;2;".,")$^P
^!InsertText [1280] 12345 [2;",."] ^$Calc(12345/1;2;",.")$^P
^!InsertText ^P
^!InsertText [1310] 12,345 [none] ^$Calc(12,345/1)$^P
^!InsertText [1315] 12,345 [0;" "] ^$Calc(12,345/1;0;" ")$^P
^!InsertText [1320] 12,345 [0;" "] ^$Calc(12,345/1;0;" ")$^P
^!InsertText [1325] 12,345 [0;""] ^$Calc(12,345/1;0;"")$^P
^!InsertText [1330] 12,345 [0;""] ^$Calc(12,345/1;0;"")$^P
^!InsertText [1335] 12,345 [0;" "] ^$Calc(12,345/1;0;" ")$^P
^!InsertText [1340] 12,345 [0;" "] ^$Calc(12,345/1;0;" ")$^P
^!InsertText [1345] 12,345 [0;"."] ^$Calc(12,345/1;0;".")$^P
^!InsertText [1350] 12,345 [0;". "] ^$Calc(12,345/1;0;". ")$^P
^!InsertText [1355] 12,345 [0;" ."] ^$Calc(12,345/1;0;" .")$^P
^!InsertText [1360] 12,345 [0;","] ^$Calc(12,345/1;0;",")$^P
^!InsertText [1365] 12,345 [0;", "] ^$Calc(12,345/1;0;", ")$^P
^!InsertText [1370] 12,345 [0;" ,"] ^$Calc(12,345/1;0;" ,")$^P
^!InsertText [1375] 12,345 [0;".,"] ^$Calc(12,345/1;0;".,")$^P
^!InsertText [1380] 12,345 [0;",."] ^$Calc(12,345/1;0;",.")$^P
^!InsertText ^P
^!InsertText [1410] 12,345 [none] ^$Calc(12,345/1)$^P
^!InsertText [1415] 12,345 [1;" "] ^$Calc(12,345/1;1;" ")$^P
^!InsertText [1420] 12,345 [1;" "] ^$Calc(12,345/1;1;" ")$^P
^!InsertText [1425] 12,345 [1;""] ^$Calc(12,345/1;1;"")$^P
^!InsertText [1430] 12,345 [1;""] ^$Calc(12,345/1;1;"")$^P
^!InsertText [1435] 12,345 [1;" "] ^$Calc(12,345/1;1;" ")$^P
^!InsertText [1440] 12,345 [1;" "] ^$Calc(12,345/1;1;" ")$^P
^!InsertText [1445] 12,345 [1;"."] ^$Calc(12,345/1;1;".")$^P
^!InsertText [1450] 12,345 [1;". "] ^$Calc(12,345/1;1;". ")$^P
^!InsertText [1455] 12,345 [1;" ."] ^$Calc(12,345/1;1;" .")$^P
^!InsertText [1460] 12,345 [1;","] ^$Calc(12,345/1;1;",")$^P
^!InsertText [1465] 12,345 [1;", "] ^$Calc(12,345/1;1;", ")$^P
^!InsertText [1470] 12,345 [1;" ,"] ^$Calc(12,345/1;1;" ,")$^P
^!InsertText [1475] 12,345 [1;".,"] ^$Calc(12,345/1;1;".,")$^P
^!InsertText [1480] 12,345 [1;",."] ^$Calc(12,345/1;1;",.")$^P
^!InsertText ^P
^!InsertText [1510] 12,345 [none] ^$Calc(12,345/1)$^P
^!InsertText [1515] 12,345 [2;" "] ^$Calc(12,345/1;2;" ")$^P
^!InsertText [1520] 12,345 [2;" "] ^$Calc(12,345/1;2;" ")$^P
^!InsertText [1525] 12,345 [2;""] ^$Calc(12,345/1;2;"")$^P
^!InsertText [1530] 12,345 [2;""] ^$Calc(12,345/1;2;"")$^P
^!InsertText [1535] 12,345 [2;" "] ^$Calc(12,345/1;2;" ")$^P
^!InsertText [1540] 12,345 [2;" "] ^$Calc(12,345/1;2;" ")$^P
^!InsertText [1545] 12,345 [2;"."] ^$Calc(12,345/1;2;".")$^P
^!InsertText [1550] 12,345 [2;". "] ^$Calc(12,345/1;2;". ")$^P
^!InsertText [1555] 12,345 [2;" ."] ^$Calc(12,345/1;2;" .")$^P
^!InsertText [1560] 12,345 [2;","] ^$Calc(12,345/1;2;",")$^P
^!InsertText [1565] 12,345 [2;", "] ^$Calc(12,345/1;2;", ")$^P
^!InsertText [1570] 12,345 [2;" ,"] ^$Calc(12,345/1;2;" ,")$^P
^!InsertText [1575] 12,345 [2;".,"] ^$Calc(12,345/1;2;".,")$^P
^!InsertText [1580] 12,345 [2;",."] ^$Calc(12,345/1;2;",.")$^P
^!InsertText ^P
^!InsertText [1610] 1234.56 [none] ^$Calc(1234.56/1)$^P
^!InsertText [1615] 1234.56 [0;" "] ^$Calc(1234.56/1;0;" ")$^P
^!InsertText [1620] 1234.56 [0;" "] ^$Calc(1234.56/1;0;" ")$^P
^!InsertText [1625] 1234.56 [0;""] ^$Calc(1234.56/1;0;"")$^P
^!InsertText [1630] 1234.56 [0;""] ^$Calc(1234.56/1;0;"")$^P
^!InsertText [1635] 1234.56 [0;" "] ^$Calc(1234.56/1;0;" ")$^P
^!InsertText [1640] 1234.56 [0;" "] ^$Calc(1234.56/1;0;" ")$^P
^!InsertText [1645] 1234.56 [0;"."] ^$Calc(1234.56/1;0;".")$^P
^!InsertText [1650] 1234.56 [0;". "] ^$Calc(1234.56/1;0;". ")$^P
^!InsertText [1655] 1234.56 [0;" ."] ^$Calc(1234.56/1;0;" .")$^P
^!InsertText [1660] 1234.56 [0;","] ^$Calc(1234.56/1;0;",")$^P
^!InsertText [1665] 1234.56 [0;", "] ^$Calc(1234.56/1;0;", ")$^P
^!InsertText [1670] 1234.56 [0;" ,"] ^$Calc(1234.56/1;0;" ,")$^P
^!InsertText [1675] 1234.56 [0;".,"] ^$Calc(1234.56/1;0;".,")$^P
^!InsertText [1680] 1234.56 [0;",."] ^$Calc(1234.56/1;0;",.")$^P
^!InsertText ^P
^!InsertText [1710] 1234.56 [none] ^$Calc(1234.56/1)$^P
^!InsertText [1715] 1234.56 [1;" "] ^$Calc(1234.56/1;1;" ")$^P
^!InsertText [1720] 1234.56 [1;" "] ^$Calc(1234.56/1;1;" ")$^P
^!InsertText [1725] 1234.56 [1;""] ^$Calc(1234.56/1;1;"")$^P
^!InsertText [1730] 1234.56 [1;""] ^$Calc(1234.56/1;1;"")$^P
^!InsertText [1735] 1234.56 [1;" "] ^$Calc(1234.56/1;1;" ")$^P
^!InsertText [1740] 1234.56 [1;" "] ^$Calc(1234.56/1;1;" ")$^P
^!InsertText [1745] 1234.56 [1;"."] ^$Calc(1234.56/1;1;".")$^P
^!InsertText [1750] 1234.56 [1;". "] ^$Calc(1234.56/1;1;". ")$^P
^!InsertText [1755] 1234.56 [1;" ."] ^$Calc(1234.56/1;1;" .")$^P
^!InsertText [1760] 1234.56 [1;","] ^$Calc(1234.56/1;1;",")$^P
^!InsertText [1765] 1234.56 [1;", "] ^$Calc(1234.56/1;1;", ")$^P
^!InsertText [1770] 1234.56 [1;" ,"] ^$Calc(1234.56/1;1;" ,")$^P
^!InsertText [1775] 1234.56 [1;".,"] ^$Calc(1234.56/1;1;".,")$^P
^!InsertText [1780] 1234.56 [1;",."] ^$Calc(1234.56/1;1;",.")$^P
^!InsertText ^P
^!InsertText [1810] 1234.56 [none] ^$Calc(1234.56/1)$^P
^!InsertText [1815] 1234.56 [2;" "] ^$Calc(1234.56/1;2;" ")$^P
^!InsertText [1820] 1234.56 [2;" "] ^$Calc(1234.56/1;2;" ")$^P
^!InsertText [1825] 1234.56 [2;""] ^$Calc(1234.56/1;2;"")$^P
^!InsertText [1830] 1234.56 [2;""] ^$Calc(1234.56/1;2;"")$^P
^!InsertText [1835] 1234.56 [2;" "] ^$Calc(1234.56/1;2;" ")$^P
^!InsertText [1840] 1234.56 [2;" "] ^$Calc(1234.56/1;2;" ")$^P
^!InsertText [1845] 1234.56 [2;"."] ^$Calc(1234.56/1;2;".")$^P
^!InsertText [1850] 1234.56 [2;". "] ^$Calc(1234.56/1;2;". ")$^P
^!InsertText [1855] 1234.56 [2;" ."] ^$Calc(1234.56/1;2;" .")$^P
^!InsertText [1860] 1234.56 [2;","] ^$Calc(1234.56/1;2;",")$^P
^!InsertText [1865] 1234.56 [2;", "] ^$Calc(1234.56/1;2;", ")$^P
^!InsertText [1870] 1234.56 [2;" ,"] ^$Calc(1234.56/1;2;" ,")$^P
^!InsertText [1875] 1234.56 [2;".,"] ^$Calc(1234.56/1;2;".,")$^P
^!InsertText [1880] 1234.56 [2;",."] ^$Calc(1234.56/1;2;",.")$^P
^!InsertText ^P
^!InsertText [1910] 1,234.56 [none] ^$Calc(1,234.56/1)$^P
^!InsertText [1915] 1,234.56 [0;" "] ^$Calc(1,234.56/1;0;" ")$^P
^!InsertText [1920] 1,234.56 [0;" "] ^$Calc(1,234.56/1;0;" ")$^P
^!InsertText [1925] 1,234.56 [0;""] ^$Calc(1,234.56/1;0;"")$^P
^!InsertText [1930] 1,234.56 [0;""] ^$Calc(1,234.56/1;0;"")$^P
^!InsertText [1935] 1,234.56 [0;" "] ^$Calc(1,234.56/1;0;" ")$^P
^!InsertText [1940] 1,234.56 [0;" "] ^$Calc(1,234.56/1;0;" ")$^P
^!InsertText [1945] 1,234.56 [0;"."] ^$Calc(1,234.56/1;0;".")$^P
^!InsertText [1950] 1,234.56 [0;". "] ^$Calc(1,234.56/1;0;". ")$^P
^!InsertText [1955] 1,234.56 [0;" ."] ^$Calc(1,234.56/1;0;" .")$^P
^!InsertText [1960] 1,234.56 [0;","] ^$Calc(1,234.56/1;0;",")$^P
^!InsertText [1965] 1,234.56 [0;", "] ^$Calc(1,234.56/1;0;", ")$^P
^!InsertText [1970] 1,234.56 [0;" ,"] ^$Calc(1,234.56/1;0;" ,")$^P
^!InsertText [1975] 1,234.56 [0;".,"] ^$Calc(1,234.56/1;0;".,")$^P
^!InsertText [1980] 1,234.56 [0;",."] ^$Calc(1,234.56/1;0;",.")$^P
^!InsertText ^P
^!InsertText [2010] 1,234.56 [none] ^$Calc(1,234.56/1)$^P
^!InsertText [2015] 1,234.56 [1;" "] ^$Calc(1,234.56/1;1;" ")$^P
^!InsertText [2020] 1,234.56 [1;" "] ^$Calc(1,234.56/1;1;" ")$^P
^!InsertText [2025] 1,234.56 [1;""] ^$Calc(1,234.56/1;1;"")$^P
^!InsertText [2030] 1,234.56 [1;""] ^$Calc(1,234.56/1;1;"")$^P
^!InsertText [2035] 1,234.56 [1;" "] ^$Calc(1,234.56/1;1;" ")$^P
^!InsertText [2040] 1,234.56 [1;" "] ^$Calc(1,234.56/1;1;" ")$^P
^!InsertText [2045] 1,234.56 [1;"."] ^$Calc(1,234.56/1;1;".")$^P
^!InsertText [2050] 1,234.56 [1;". "] ^$Calc(1,234.56/1;1;". ")$^P
^!InsertText [2055] 1,234.56 [1;" ."] ^$Calc(1,234.56/1;1;" .")$^P
^!InsertText [2060] 1,234.56 [1;","] ^$Calc(1,234.56/1;1;",")$^P
^!InsertText [2065] 1,234.56 [1;", "] ^$Calc(1,234.56/1;1;", ")$^P
^!InsertText [2070] 1,234.56 [1;" ,"] ^$Calc(1,234.56/1;1;" ,")$^P
^!InsertText [2075] 1,234.56 [1;".,"] ^$Calc(1,234.56/1;1;".,")$^P
^!InsertText [2080] 1,234.56 [1;",."] ^$Calc(1,234.56/1;1;",.")$^P
^!InsertText ^P
^!InsertText [2110] 1,234.56 [none] ^$Calc(1,234.56/1)$^P
^!InsertText [2115] 1,234.56 [2;" "] ^$Calc(1,234.56/1;2;" ")$^P
^!InsertText [2120] 1,234.56 [2;" "] ^$Calc(1,234.56/1;2;" ")$^P
^!InsertText [2125] 1,234.56 [2;""] ^$Calc(1,234.56/1;2;"")$^P
^!InsertText [2130] 1,234.56 [2;""] ^$Calc(1,234.56/1;2;"")$^P
^!InsertText [2135] 1,234.56 [2;" "] ^$Calc(1,234.56/1;2;" ")$^P
^!InsertText [2140] 1,234.56 [2;" "] ^$Calc(1,234.56/1;2;" ")$^P
^!InsertText [2145] 1,234.56 [2;"."] ^$Calc(1,234.56/1;2;".")$^P
^!InsertText [2150] 1,234.56 [2;". "] ^$Calc(1,234.56/1;2;". ")$^P
^!InsertText [2155] 1,234.56 [2;" ."] ^$Calc(1,234.56/1;2;" .")$^P
^!InsertText [2160] 1,234.56 [2;","] ^$Calc(1,234.56/1;2;",")$^P
^!InsertText [2165] 1,234.56 [2;", "] ^$Calc(1,234.56/1;2;", ")$^P
^!InsertText [2170] 1,234.56 [2;" ,"] ^$Calc(1,234.56/1;2;" ,")$^P
^!InsertText [2175] 1,234.56 [2;".,"] ^$Calc(1,234.56/1;2;".,")$^P
^!InsertText [2180] 1,234.56 [2;",."] ^$Calc(1,234.56/1;2;",.")$^P
^!InsertText ^P
^!InsertText [2210] 12345.67 [none] ^$Calc(12345.67/1)$^P
^!InsertText [2215] 12345.67 [0;" "] ^$Calc(12345.67/1;0;" ")$^P
^!InsertText [2220] 12345.67 [0;" "] ^$Calc(12345.67/1;0;" ")$^P
^!InsertText [2225] 12345.67 [0;""] ^$Calc(12345.67/1;0;"")$^P
^!InsertText [2230] 12345.67 [0;""] ^$Calc(12345.67/1;0;"")$^P
^!InsertText [2235] 12345.67 [0;" "] ^$Calc(12345.67/1;0;" ")$^P
^!InsertText [2240] 12345.67 [0;" "] ^$Calc(12345.67/1;0;" ")$^P
^!InsertText [2245] 12345.67 [0;"."] ^$Calc(12345.67/1;0;".")$^P
^!InsertText [2250] 12345.67 [0;". "] ^$Calc(12345.67/1;0;". ")$^P
^!InsertText [2255] 12345.67 [0;" ."] ^$Calc(12345.67/1;0;" .")$^P
^!InsertText [2260] 12345.67 [0;","] ^$Calc(12345.67/1;0;",")$^P
^!InsertText [2265] 12345.67 [0;", "] ^$Calc(12345.67/1;0;", ")$^P
^!InsertText [2270] 12345.67 [0;" ,"] ^$Calc(12345.67/1;0;" ,")$^P
^!InsertText [2275] 12345.67 [0;".,"] ^$Calc(12345.67/1;0;".,")$^P
^!InsertText [2280] 12345.67 [0;",."] ^$Calc(12345.67/1;0;",.")$^P
^!InsertText ^P
^!InsertText [2310] 12345.67 [none] ^$Calc(12345.67/1)$^P
^!InsertText [2315] 12345.67 [1;" "] ^$Calc(12345.67/1;1;" ")$^P
^!InsertText [2320] 12345.67 [1;" "] ^$Calc(12345.67/1;1;" ")$^P
^!InsertText [2325] 12345.67 [1;""] ^$Calc(12345.67/1;1;"")$^P
^!InsertText [2330] 12345.67 [1;""] ^$Calc(12345.67/1;1;"")$^P
^!InsertText [2335] 12345.67 [1;" "] ^$Calc(12345.67/1;1;" ")$^P
^!InsertText [2340] 12345.67 [1;" "] ^$Calc(12345.67/1;1;" ")$^P
^!InsertText [2345] 12345.67 [1;"."] ^$Calc(12345.67/1;1;".")$^P
^!InsertText [2350] 12345.67 [1;". "] ^$Calc(12345.67/1;1;". ")$^P
^!InsertText [2355] 12345.67 [1;" ."] ^$Calc(12345.67/1;1;" .")$^P
^!InsertText [2360] 12345.67 [1;","] ^$Calc(12345.67/1;1;",")$^P
^!InsertText [2365] 12345.67 [1;", "] ^$Calc(12345.67/1;1;", ")$^P
^!InsertText [2370] 12345.67 [1;" ,"] ^$Calc(12345.67/1;1;" ,")$^P
^!InsertText [2375] 12345.67 [1;".,"] ^$Calc(12345.67/1;1;".,")$^P
^!InsertText [2380] 12345.67 [1;",."] ^$Calc(12345.67/1;1;",.")$^P
^!InsertText ^P
^!InsertText [2410] 12345.67 [none] ^$Calc(12345.67/1)$^P
^!InsertText [2415] 12345.67 [2;" "] ^$Calc(12345.67/1;2;" ")$^P
^!InsertText [2420] 12345.67 [2;" "] ^$Calc(12345.67/1;2;" ")$^P
^!InsertText [2425] 12345.67 [2;""] ^$Calc(12345.67/1;2;"")$^P
^!InsertText [2430] 12345.67 [2;""] ^$Calc(12345.67/1;2;"")$^P
^!InsertText [2435] 12345.67 [2;" "] ^$Calc(12345.67/1;2;" ")$^P
^!InsertText [2440] 12345.67 [2;" "] ^$Calc(12345.67/1;2;" ")$^P
^!InsertText [2445] 12345.67 [2;"."] ^$Calc(12345.67/1;2;".")$^P
^!InsertText [2450] 12345.67 [2;". "] ^$Calc(12345.67/1;2;". ")$^P
^!InsertText [2455] 12345.67 [2;" ."] ^$Calc(12345.67/1;2;" .")$^P
^!InsertText [2460] 12345.67 [2;","] ^$Calc(12345.67/1;2;",")$^P
^!InsertText [2465] 12345.67 [2;", "] ^$Calc(12345.67/1;2;", ")$^P
^!InsertText [2470] 12345.67 [2;" ,"] ^$Calc(12345.67/1;2;" ,")$^P
^!InsertText [2475] 12345.67 [2;".,"] ^$Calc(12345.67/1;2;".,")$^P
^!InsertText [2480] 12345.67 [2;",."] ^$Calc(12345.67/1;2;",.")$^P
^!InsertText ^P
^!InsertText [2510] 12,345.67 [none] ^$Calc(12,345.67/1)$^P
^!InsertText [2515] 12,345.67 [0;" "] ^$Calc(12,345.67/1;0;" ")$^P
^!InsertText [2520] 12,345.67 [0;" "] ^$Calc(12,345.67/1;0;" ")$^P
^!InsertText [2525] 12,345.67 [0;""] ^$Calc(12,345.67/1;0;"")$^P
^!InsertText [2530] 12,345.67 [0;""] ^$Calc(12,345.67/1;0;"")$^P
^!InsertText [2535] 12,345.67 [0;" "] ^$Calc(12,345.67/1;0;" ")$^P
^!InsertText [2540] 12,345.67 [0;" "] ^$Calc(12,345.67/1;0;" ")$^P
^!InsertText [2545] 12,345.67 [0;"."] ^$Calc(12,345.67/1;0;".")$^P
^!InsertText [2550] 12,345.67 [0;". "] ^$Calc(12,345.67/1;0;". ")$^P
^!InsertText [2555] 12,345.67 [0;" ."] ^$Calc(12,345.67/1;0;" .")$^P
^!InsertText [2560] 12,345.67 [0;","] ^$Calc(12,345.67/1;0;",")$^P
^!InsertText [2565] 12,345.67 [0;", "] ^$Calc(12,345.67/1;0;", ")$^P
^!InsertText [2570] 12,345.67 [0;" ,"] ^$Calc(12,345.67/1;0;" ,")$^P
^!InsertText [2575] 12,345.67 [0;".,"] ^$Calc(12,345.67/1;0;".,")$^P
^!InsertText [2580] 12,345.67 [0;",."] ^$Calc(12,345.67/1;0;",.")$^P
^!InsertText ^P
^!InsertText [2610] 12,345.67 [none] ^$Calc(12,345.67/1)$^P
^!InsertText [2615] 12,345.67 [1;" "] ^$Calc(12,345.67/1;1;" ")$^P
^!InsertText [2620] 12,345.67 [1;" "] ^$Calc(12,345.67/1;1;" ")$^P
^!InsertText [2625] 12,345.67 [1;""] ^$Calc(12,345.67/1;1;"")$^P
^!InsertText [2630] 12,345.67 [1;""] ^$Calc(12,345.67/1;1;"")$^P
^!InsertText [2635] 12,345.67 [1;" "] ^$Calc(12,345.67/1;1;" ")$^P
^!InsertText [2640] 12,345.67 [1;" "] ^$Calc(12,345.67/1;1;" ")$^P
^!InsertText [2645] 12,345.67 [1;"."] ^$Calc(12,345.67/1;1;".")$^P
^!InsertText [2650] 12,345.67 [1;". "] ^$Calc(12,345.67/1;1;". ")$^P
^!InsertText [2655] 12,345.67 [1;" ."] ^$Calc(12,345.67/1;1;" .")$^P
^!InsertText [2660] 12,345.67 [1;","] ^$Calc(12,345.67/1;1;",")$^P
^!InsertText [2665] 12,345.67 [1;", "] ^$Calc(12,345.67/1;1;", ")$^P
^!InsertText [2670] 12,345.67 [1;" ,"] ^$Calc(12,345.67/1;1;" ,")$^P
^!InsertText [2675] 12,345.67 [1;".,"] ^$Calc(12,345.67/1;1;".,")$^P
^!InsertText [2680] 12,345.67 [1;",."] ^$Calc(12,345.67/1;1;",.")$^P
^!InsertText ^P
^!InsertText [2710] 12,345.67 [none] ^$Calc(12,345.67/1)$^P
^!InsertText [2715] 12,345.67 [2;" "] ^$Calc(12,345.67/1;2;" ")$^P
^!InsertText [2720] 12,345.67 [2;" "] ^$Calc(12,345.67/1;2;" ")$^P
^!InsertText [2725] 12,345.67 [2;""] ^$Calc(12,345.67/1;2;"")$^P
^!InsertText [2730] 12,345.67 [2;""] ^$Calc(12,345.67/1;2;"")$^P
^!InsertText [2735] 12,345.67 [2;" "] ^$Calc(12,345.67/1;2;" ")$^P
^!InsertText [2740] 12,345.67 [2;" "] ^$Calc(12,345.67/1;2;" ")$^P
^!InsertText [2745] 12,345.67 [2;"."] ^$Calc(12,345.67/1;2;".")$^P
^!InsertText [2750] 12,345.67 [2;". "] ^$Calc(12,345.67/1;2;". ")$^P
^!InsertText [2755] 12,345.67 [2;" ."] ^$Calc(12,345.67/1;2;" .")$^P
^!InsertText [2760] 12,345.67 [2;","] ^$Calc(12,345.67/1;2;",")$^P
^!InsertText [2765] 12,345.67 [2;", "] ^$Calc(12,345.67/1;2;", ")$^P
^!InsertText [2770] 12,345.67 [2;" ,"] ^$Calc(12,345.67/1;2;" ,")$^P
^!InsertText [2775] 12,345.67 [2;".,"] ^$Calc(12,345.67/1;2;".,")$^P
^!InsertText [2780] 12,345.67 [2;",."] ^$Calc(12,345.67/1;2;",.")$^P
^!InsertText ^P
^!InsertText [2810] 12.345,67 [none] ^$Calc(12.345,67/1)$^P
^!InsertText [2815] 12.345,67 [0;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2820] 12.345,67 [0;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2825] 12.345,67 [0;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [2830] 12.345,67 [0;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [2835] 12.345,67 [0;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2840] 12.345,67 [0;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2845] 12.345,67 [0;"."] ^$Calc(12.345,67/1;0;".")$^P
^!InsertText [2850] 12.345,67 [0;". "] ^$Calc(12.345,67/1;0;". ")$^P
^!InsertText [2855] 12.345,67 [0;" ."] ^$Calc(12.345,67/1;0;" .")$^P
^!InsertText [2860] 12.345,67 [0;","] ^$Calc(12.345,67/1;0;",")$^P
^!InsertText [2865] 12.345,67 [0;", "] ^$Calc(12.345,67/1;0;", ")$^P
^!InsertText [2870] 12.345,67 [0;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
^!InsertText [2875] 12.345,67 [0;".,"] ^$Calc(12.345,67/1;0;".,")$^P
^!InsertText [2880] 12.345,67 [0;",."] ^$Calc(12.345,67/1;0;",.")$^P
^!InsertText ^P
^!InsertText [2910] 12.345,67 [none] ^$Calc(12.345,67/1)$^P
^!InsertText [2915] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2920] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2925] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [2930] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [2935] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2940] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [2945] 12.345,67 [1;"."] ^$Calc(12.345,67/1;0;".")$^P
^!InsertText [2950] 12.345,67 [1;". "] ^$Calc(12.345,67/1;0;". ")$^P
^!InsertText [2955] 12.345,67 [1;" ."] ^$Calc(12.345,67/1;0;" .")$^P
^!InsertText [2960] 12.345,67 [1;","] ^$Calc(12.345,67/1;0;",")$^P
^!InsertText [2965] 12.345,67 [1;", "] ^$Calc(12.345,67/1;0;", ")$^P
^!InsertText [2970] 12.345,67 [1;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
^!InsertText [2975] 12.345,67 [1;".,"] ^$Calc(12.345,67/1;0;".,")$^P
^!InsertText [2980] 12.345,67 [1;",."] ^$Calc(12.345,67/1;0;",.")$^P
^!InsertText ^P
^!InsertText [3010] 12.345,67 [none] ^$Calc(12.345,67/1)$^P
^!InsertText [3015] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [3020] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [3025] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [3030] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
^!InsertText [3035] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [3040] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
^!InsertText [3045] 12.345,67 [2;"."] ^$Calc(12.345,67/1;0;".")$^P
^!InsertText [3050] 12.345,67 [2;". "] ^$Calc(12.345,67/1;0;". ")$^P
^!InsertText [3055] 12.345,67 [2;" ."] ^$Calc(12.345,67/1;0;" .")$^P
^!InsertText [3060] 12.345,67 [2;","] ^$Calc(12.345,67/1;0;",")$^P
^!InsertText [3065] 12.345,67 [2;", "] ^$Calc(12.345,67/1;0;", ")$^P
^!InsertText [3070] 12.345,67 [2;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
^!InsertText [3075] 12.345,67 [2;".,"] ^$Calc(12.345,67/1;0;".,")$^P
^!InsertText [3080] 12.345,67 [2;",."] ^$Calc(12.345,67/1;0;",.")$^P
^!InsertText ^P
^!InsertText [1010] 7/11 [3;""] ^$Calc(7/11;0;"")$^P
^!InsertText [1015] 10000/0.5 [0;"."] ^$Calc(10000/0.5;0;".")$^P
^!InsertText [1020] 50t000d00 [0;",."] ^$Calc(50^%t%000^%d%00/1;0;",.")$^P
^!InsertText [1025] 50,000.00 [0;",."] ^$Calc(50,000.00/1;0;",.")$^P
^!InsertText [1030] 50,000.00 [0;".,"] ^$Calc(50,000.00/1;0;".,")$^P
^!InsertText ^P
^!InsertText [1010] 7/11 [3;""] ^$Calc(7/11;0;"")$^P
^!InsertText [1015] 10000/0.5 [1;"."] ^$Calc(10000/0.5;1;".")$^P
^!InsertText [1020] 50t000d00 [1;",."] ^$Calc(50^%t%000^%d%00/1;1;",.")$^P
^!InsertText [1025] 50,000.00 [1;",."] ^$Calc(50,000.00/1;1;",.")$^P
^!InsertText [1030] 50,000.00 [1;".,"] ^$Calc(50,000.00/1;1;".,")$^P
^!InsertText ^P
^!InsertText [1010] 7/11 [3;""] ^$Calc(7/11;0;"")$^P
^!InsertText [1015] 10000/0.5 [2;"."] ^$Calc(10000/0.5;2;".")$^P
^!InsertText [1020] 50t000d00 [2;",."] ^$Calc(50^%t%000^%d%00/1;2;",.")$^P
^!InsertText [1025] 50,000.00 [2;",."] ^$Calc(50,000.00/1;2;",.")$^P
^!InsertText [1030] 50,000.00 [2;".,"] ^$Calc(50,000.00/1;2;".,")$^P
^!Replace "\] " >> "]\t" WRSA
^!Replace " \[" >> "\t\[" WRSA
^!Jump Text_Start
 RESULTS 
NoteTab Light version 7.01.25
On my system, %DECIMAL_SYMB% (%d%) is (.) and %THOUSAND_SYMB% (%t%) is (,)
Invalid parameters tested on purpose.
Test # Value Options Result
[0110] 0.1234 [none] 0.12
[0115] 0.1234 [0;" "] 0
[0120] 0.1234 [0;" "] 0
[0125] 0.1234 [0;""] 0
[0130] 0.1234 [0;""] 0
[0135] 0.1234 [0;" "] 0
[0140] 0.1234 [0;" "] 0
[0145] 0.1234 [0;"."] 0
[0150] 0.1234 [0;". "] 0
[0155] 0.1234 [0;" ."] 1.234
[0160] 0.1234 [0;","] 0
[0165] 0.1234 [0;", "] 0
[0170] 0.1234 [0;" ,"] 0
[0175] 0.1234 [0;".,"] 0
[0180] 0.1234 [0;",."] 1.234
[0210] 0.1234 [none] 0.12
[0215] 0.1234 [1;" "] 0 1
[0220] 0.1234 [1;" "] 0 1
[0225] 0.1234 [1;""] 01
[0230] 0.1234 [1;""] 01
[0235] 0.1234 [1;" "] 0 1
[0240] 0.1234 [1;" "] 01
[0245] 0.1234 [1;"."] 0.1
[0250] 0.1234 [1;". "] 0.1
[0255] 0.1234 [1;" ."] 1.234 0
[0260] 0.1234 [1;","] 0,1
[0265] 0.1234 [1;", "] 0,1
[0270] 0.1234 [1;" ,"] 0 1
[0275] 0.1234 [1;".,"] 0.1
[0280] 0.1234 [1;",."] 1.234,0
[0310] 0.1234 [none] 0.12
[0315] 0.1234 [2;" "] 0 12
[0320] 0.1234 [2;" "] 0 12
[0325] 0.1234 [2;""] 012
[0330] 0.1234 [2;""] 012
[0335] 0.1234 [2;" "] 0 12
[0340] 0.1234 [2;" "] 012
[0345] 0.1234 [2;"."] 0.12
[0350] 0.1234 [2;". "] 0.12
[0355] 0.1234 [2;" ."] 1.234 00
[0360] 0.1234 [2;","] 0,12
[0365] 0.1234 [2;", "] 0,12
[0370] 0.1234 [2;" ,"] 0 12
[0375] 0.1234 [2;".,"] 0.12
[0380] 0.1234 [2;",."] 1.234,00
[0410] 1234 [none] 1234
[0415] 1234 [0;" "] 1234
[0420] 1234 [0;" "] 1234
[0425] 1234 [0;""] 1234
[0430] 1234 [0;""] 1234
[0435] 1234 [0;" "] 1234
[0440] 1234 [0;" "] 1234
[0445] 1234 [0;"."] 1234
[0450] 1234 [0;". "] 1234
[0455] 1234 [0;" ."] 1.234
[0460] 1234 [0;","] 1234
[0465] 1234 [0;", "] 1234
[0470] 1234 [0;" ,"] 1,234
[0475] 1234 [0;".,"] 1,234
[0480] 1234 [0;",."] 1.234
[0510] 1234 [none] 1234
[0515] 1234 [1;" "] 1234 0
[0520] 1234 [1;" "] 1234 0
[0525] 1234 [1;""] 12340
[0530] 1234 [1;""] 12340
[0535] 1234 [1;" "] 1234 0
[0540] 1234 [1;" "] 12340
[0545] 1234 [1;"."] 1234.0
[0550] 1234 [1;". "] 1234.0
[0555] 1234 [1;" ."] 1.234 0
[0560] 1234 [1;","] 1234,0
[0565] 1234 [1;", "] 1234,0
[0570] 1234 [1;" ,"] 1,234 0
[0575] 1234 [1;".,"] 1,234.0
[0580] 1234 [1;",."] 1.234,0
[0610] 1234 [none] 1234
[0615] 1234 [2;" "] 1234 00
[0620] 1234 [2;" "] 1234 00
[0625] 1234 [2;""] 123400
[0630] 1234 [2;""] 123400
[0635] 1234 [2;" "] 1234 00
[0640] 1234 [2;" "] 123400
[0645] 1234 [2;"."] 1234.00
[0650] 1234 [2;". "] 1234.00
[0655] 1234 [2;" ."] 1.234 00
[0660] 1234 [2;","] 1234,00
[0665] 1234 [2;", "] 1234,00
[0670] 1234 [2;" ,"] 1,234 00
[0675] 1234 [2;".,"] 1,234.00
[0680] 1234 [2;",."] 1.234,00
[0710] 1,234 [none] 1,234
[0715] 1,234 [0;" "] [error in expression]
[0720] 1,234 [0;" "] [error in expression]
[0725] 1,234 [0;""] [error in expression]
[0730] 1,234 [0;""] [error in expression]
[0735] 1,234 [0;" "] [error in expression]
[0740] 1,234 [0;" "] [error in expression]
[0745] 1,234 [0;"."] [error in expression]
[0750] 1,234 [0;". "] [error in expression]
[0755] 1,234 [0;" ."] [error in expression]
[0760] 1,234 [0;","] 1
[0765] 1,234 [0;", "] 1
[0770] 1,234 [0;" ,"] 1,234
[0775] 1,234 [0;".,"] 1,234
[0780] 1,234 [0;",."] 1
[0810] 1,234 [none] 1,234
[0815] 1,234 [1;" "] [error in expression]
[0820] 1,234 [1;" "] [error in expression]
[0825] 1,234 [1;""] [error in expression]
[0830] 1,234 [1;""] [error in expression]
[0835] 1,234 [1;" "] [error in expression]
[0840] 1,234 [1;" "] [error in expression]
[0845] 1,234 [1;"."] [error in expression]
[0850] 1,234 [1;". "] [error in expression]
[0855] 1,234 [1;" ."] [error in expression]
[0860] 1,234 [1;","] 1,2
[0865] 1,234 [1;", "] 1,2
[0870] 1,234 [1;" ,"] 1,234 0
[0875] 1,234 [1;".,"] 1,234.0
[0880] 1,234 [1;",."] 1,2
[0910] 1,234 [none] 1,234
[0915] 1,234 [2;" "] [error in expression]
[0920] 1,234 [2;" "] [error in expression]
[0925] 1,234 [2;""] [error in expression]
[0930] 1,234 [2;""] [error in expression]
[0935] 1,234 [2;" "] [error in expression]
[0940] 1,234 [2;" "] [error in expression]
[0945] 1,234 [2;"."] [error in expression]
[0950] 1,234 [2;". "] [error in expression]
[0955] 1,234 [2;" ."] [error in expression]
[0960] 1,234 [2;","] 1,23
[0965] 1,234 [2;", "] 1,23
[0970] 1,234 [2;" ,"] 1,234 00
[0975] 1,234 [2;".,"] 1,234.00
[0980] 1,234 [2;",."] 1,23
[1010] 12345 [none] 12,345
[1015] 12345 [0;" "] 12345
[1020] 12345 [0;" "] 12345
[1025] 12345 [0;""] 12345
[1030] 12345 [0;""] 12345
[1035] 12345 [0;" "] 12345
[1040] 12345 [0;" "] 12345
[1045] 12345 [0;"."] 12345
[1050] 12345 [0;". "] 12345
[1055] 12345 [0;" ."] 12.345
[1060] 12345 [0;","] 12345
[1065] 12345 [0;", "] 12345
[1070] 12345 [0;" ,"] 12,345
[1075] 12345 [0;".,"] 12,345
[1080] 12345 [0;",."] 12.345
[1110] 12345 [none] 12,345
[1115] 12345 [1;" "] 12345 0
[1120] 12345 [1;" "] 12345 0
[1125] 12345 [1;""] 123450
[1130] 12345 [1;""] 123450
[1135] 12345 [1;" "] 12345 0
[1140] 12345 [1;" "] 123450
[1145] 12345 [1;"."] 12345.0
[1150] 12345 [1;". "] 12345.0
[1155] 12345 [1;" ."] 12.345 0
[1160] 12345 [1;","] 12345,0
[1165] 12345 [1;", "] 12345,0
[1170] 12345 [1;" ,"] 12,345 0
[1175] 12345 [1;".,"] 12,345.0
[1180] 12345 [1;",."] 12.345,0
[1210] 12345 [none] 12,345
[1215] 12345 [2;" "] 12345 00
[1220] 12345 [2;" "] 12345 00
[1225] 12345 [2;""] 1234500
[1230] 12345 [2;""] 1234500
[1235] 12345 [2;" "] 12345 00
[1240] 12345 [2;" "] 1234500
[1245] 12345 [2;"."] 12345.00
[1250] 12345 [2;". "] 12345.00
[1255] 12345 [2;" ."] 12.345 00
[1260] 12345 [2;","] 12345,00
[1265] 12345 [2;", "] 12345,00
[1270] 12345 [2;" ,"] 12,345 00
[1275] 12345 [2;".,"] 12,345.00
[1280] 12345 [2;",."] 12.345,00
[1310] 12,345 [none] 12,345
[1315] 12,345 [0;" "] [error in expression]
[1320] 12,345 [0;" "] [error in expression]
[1325] 12,345 [0;""] [error in expression]
[1330] 12,345 [0;""] [error in expression]
[1335] 12,345 [0;" "] [error in expression]
[1340] 12,345 [0;" "] [error in expression]
[1345] 12,345 [0;"."] [error in expression]
[1350] 12,345 [0;". "] [error in expression]
[1355] 12,345 [0;" ."] [error in expression]
[1360] 12,345 [0;","] 12
[1365] 12,345 [0;", "] 12
[1370] 12,345 [0;" ,"] 12,345
[1375] 12,345 [0;".,"] 12,345
[1380] 12,345 [0;",."] 12
[1410] 12,345 [none] 12,345
[1415] 12,345 [1;" "] [error in expression]
[1420] 12,345 [1;" "] [error in expression]
[1425] 12,345 [1;""] [error in expression]
[1430] 12,345 [1;""] [error in expression]
[1435] 12,345 [1;" "] [error in expression]
[1440] 12,345 [1;" "] [error in expression]
[1445] 12,345 [1;"."] [error in expression]
[1450] 12,345 [1;". "] [error in expression]
[1455] 12,345 [1;" ."] [error in expression]
[1460] 12,345 [1;","] 12,3
[1465] 12,345 [1;", "] 12,3
[1470] 12,345 [1;" ,"] 12,345 0
[1475] 12,345 [1;".,"] 12,345.0
[1480] 12,345 [1;",."] 12,3
[1510] 12,345 [none] 12,345
[1515] 12,345 [2;" "] [error in expression]
[1520] 12,345 [2;" "] [error in expression]
[1525] 12,345 [2;""] [error in expression]
[1530] 12,345 [2;""] [error in expression]
[1535] 12,345 [2;" "] [error in expression]
[1540] 12,345 [2;" "] [error in expression]
[1545] 12,345 [2;"."] [error in expression]
[1550] 12,345 [2;". "] [error in expression]
[1555] 12,345 [2;" ."] [error in expression]
[1560] 12,345 [2;","] 12,35
[1565] 12,345 [2;", "] 12,35
[1570] 12,345 [2;" ,"] 12,345 00
[1575] 12,345 [2;".,"] 12,345.00
[1580] 12,345 [2;",."] 12,35
[1610] 1234.56 [none] 1234.56
[1615] 1234.56 [0;" "] 1235
[1620] 1234.56 [0;" "] 1235
[1625] 1234.56 [0;""] 1235
[1630] 1234.56 [0;""] 1235
[1635] 1234.56 [0;" "] 1235
[1640] 1234.56 [0;" "] 1235
[1645] 1234.56 [0;"."] 1235
[1650] 1234.56 [0;". "] 1235
[1655] 1234.56 [0;" ."] 123.456
[1660] 1234.56 [0;","] 1235
[1665] 1234.56 [0;", "] 1235
[1670] 1234.56 [0;" ,"] 1,235
[1675] 1234.56 [0;".,"] 1,235
[1680] 1234.56 [0;",."] 123.456
[1710] 1234.56 [none] 1234.56
[1715] 1234.56 [1;" "] 1234 6
[1720] 1234.56 [1;" "] 1234 6
[1725] 1234.56 [1;""] 12346
[1730] 1234.56 [1;""] 12346
[1735] 1234.56 [1;" "] 1234 6
[1740] 1234.56 [1;" "] 12346
[1745] 1234.56 [1;"."] 1234.6
[1750] 1234.56 [1;". "] 1234.6
[1755] 1234.56 [1;" ."] 123.456 0
[1760] 1234.56 [1;","] 1234,6
[1765] 1234.56 [1;", "] 1234,6
[1770] 1234.56 [1;" ,"] 1,234 6
[1775] 1234.56 [1;".,"] 1,234.6
[1780] 1234.56 [1;",."] 123.456,0
[1810] 1234.56 [none] 1234.56
[1815] 1234.56 [2;" "] 1234 56
[1820] 1234.56 [2;" "] 1234 56
[1825] 1234.56 [2;""] 123456
[1830] 1234.56 [2;""] 123456
[1835] 1234.56 [2;" "] 1234 56
[1840] 1234.56 [2;" "] 123456
[1845] 1234.56 [2;"."] 1234.56
[1850] 1234.56 [2;". "] 1234.56
[1855] 1234.56 [2;" ."] 123.456 00
[1860] 1234.56 [2;","] 1234,56
[1865] 1234.56 [2;", "] 1234,56
[1870] 1234.56 [2;" ,"] 1,234 56
[1875] 1234.56 [2;".,"] 1,234.56
[1880] 1234.56 [2;",."] 123.456,00
[1910] 1,234.56 [none] 1,234.56
[1915] 1,234.56 [0;" "] [error in expression]
[1920] 1,234.56 [0;" "] [error in expression]
[1925] 1,234.56 [0;""] [error in expression]
[1930] 1,234.56 [0;""] [error in expression]
[1935] 1,234.56 [0;" "] [error in expression]
[1940] 1,234.56 [0;" "] [error in expression]
[1945] 1,234.56 [0;"."] [error in expression]
[1950] 1,234.56 [0;". "] [error in expression]
[1955] 1,234.56 [0;" ."] [error in expression]
[1960] 1,234.56 [0;","] [error in expression]
[1965] 1,234.56 [0;", "] [error in expression]
[1970] 1,234.56 [0;" ,"] 1,235
[1975] 1,234.56 [0;".,"] 1,235
[1980] 1,234.56 [0;",."] 1
[2010] 1,234.56 [none] 1,234.56
[2015] 1,234.56 [1;" "] [error in expression]
[2020] 1,234.56 [1;" "] [error in expression]
[2025] 1,234.56 [1;""] [error in expression]
[2030] 1,234.56 [1;""] [error in expression]
[2035] 1,234.56 [1;" "] [error in expression]
[2040] 1,234.56 [1;" "] [error in expression]
[2045] 1,234.56 [1;"."] [error in expression]
[2050] 1,234.56 [1;". "] [error in expression]
[2055] 1,234.56 [1;" ."] [error in expression]
[2060] 1,234.56 [1;","] [error in expression]
[2065] 1,234.56 [1;", "] [error in expression]
[2070] 1,234.56 [1;" ,"] 1,234 6
[2075] 1,234.56 [1;".,"] 1,234.6
[2080] 1,234.56 [1;",."] 1,2
[2110] 1,234.56 [none] 1,234.56
[2115] 1,234.56 [2;" "] [error in expression]
[2120] 1,234.56 [2;" "] [error in expression]
[2125] 1,234.56 [2;""] [error in expression]
[2130] 1,234.56 [2;""] [error in expression]
[2135] 1,234.56 [2;" "] [error in expression]
[2140] 1,234.56 [2;" "] [error in expression]
[2145] 1,234.56 [2;"."] [error in expression]
[2150] 1,234.56 [2;". "] [error in expression]
[2155] 1,234.56 [2;" ."] [error in expression]
[2160] 1,234.56 [2;","] [error in expression]
[2165] 1,234.56 [2;", "] [error in expression]
[2170] 1,234.56 [2;" ,"] 1,234 56
[2175] 1,234.56 [2;".,"] 1,234.56
[2180] 1,234.56 [2;",."] 1,23
[2210] 12345.67 [none] 12,345.67
[2215] 12345.67 [0;" "] 12346
[2220] 12345.67 [0;" "] 12346
[2225] 12345.67 [0;""] 12346
[2230] 12345.67 [0;""] 12346
[2235] 12345.67 [0;" "] 12346
[2240] 12345.67 [0;" "] 12346
[2245] 12345.67 [0;"."] 12346
[2250] 12345.67 [0;". "] 12346
[2255] 12345.67 [0;" ."] 1.234.567
[2260] 12345.67 [0;","] 12346
[2265] 12345.67 [0;", "] 12346
[2270] 12345.67 [0;" ,"] 12,346
[2275] 12345.67 [0;".,"] 12,346
[2280] 12345.67 [0;",."] 1.234.567
[2310] 12345.67 [none] 12,345.67
[2315] 12345.67 [1;" "] 12345 7
[2320] 12345.67 [1;" "] 12345 7
[2325] 12345.67 [1;""] 123457
[2330] 12345.67 [1;""] 123457
[2335] 12345.67 [1;" "] 12345 7
[2340] 12345.67 [1;" "] 123457
[2345] 12345.67 [1;"."] 12345.7
[2350] 12345.67 [1;". "] 12345.7
[2355] 12345.67 [1;" ."] 1.234.567 0
[2360] 12345.67 [1;","] 12345,7
[2365] 12345.67 [1;", "] 12345,7
[2370] 12345.67 [1;" ,"] 12,345 7
[2375] 12345.67 [1;".,"] 12,345.7
[2380] 12345.67 [1;",."] 1.234.567,0
[2410] 12345.67 [none] 12,345.67
[2415] 12345.67 [2;" "] 12345 67
[2420] 12345.67 [2;" "] 12345 67
[2425] 12345.67 [2;""] 1234567
[2430] 12345.67 [2;""] 1234567
[2435] 12345.67 [2;" "] 12345 67
[2440] 12345.67 [2;" "] 1234567
[2445] 12345.67 [2;"."] 12345.67
[2450] 12345.67 [2;". "] 12345.67
[2455] 12345.67 [2;" ."] 1.234.567 00
[2460] 12345.67 [2;","] 12345,67
[2465] 12345.67 [2;", "] 12345,67
[2470] 12345.67 [2;" ,"] 12,345 67
[2475] 12345.67 [2;".,"] 12,345.67
[2480] 12345.67 [2;",."] 1.234.567,00
[2510] 12,345.67 [none] 12,345.67
[2515] 12,345.67 [0;" "] [error in expression]
[2520] 12,345.67 [0;" "] [error in expression]
[2525] 12,345.67 [0;""] [error in expression]
[2530] 12,345.67 [0;""] [error in expression]
[2535] 12,345.67 [0;" "] [error in expression]
[2540] 12,345.67 [0;" "] [error in expression]
[2545] 12,345.67 [0;"."] [error in expression]
[2550] 12,345.67 [0;". "] [error in expression]
[2555] 12,345.67 [0;" ."] [error in expression]
[2560] 12,345.67 [0;","] [error in expression]
[2565] 12,345.67 [0;", "] [error in expression]
[2570] 12,345.67 [0;" ,"] 12,346
[2575] 12,345.67 [0;".,"] 12,346
[2580] 12,345.67 [0;",."] 12
[2610] 12,345.67 [none] 12,345.67
[2615] 12,345.67 [1;" "] [error in expression]
[2620] 12,345.67 [1;" "] [error in expression]
[2625] 12,345.67 [1;""] [error in expression]
[2630] 12,345.67 [1;""] [error in expression]
[2635] 12,345.67 [1;" "] [error in expression]
[2640] 12,345.67 [1;" "] [error in expression]
[2645] 12,345.67 [1;"."] [error in expression]
[2650] 12,345.67 [1;". "] [error in expression]
[2655] 12,345.67 [1;" ."] [error in expression]
[2660] 12,345.67 [1;","] [error in expression]
[2665] 12,345.67 [1;", "] [error in expression]
[2670] 12,345.67 [1;" ,"] 12,345 7
[2675] 12,345.67 [1;".,"] 12,345.7
[2680] 12,345.67 [1;",."] 12,3
[2710] 12,345.67 [none] 12,345.67
[2715] 12,345.67 [2;" "] [error in expression]
[2720] 12,345.67 [2;" "] [error in expression]
[2725] 12,345.67 [2;""] [error in expression]
[2730] 12,345.67 [2;""] [error in expression]
[2735] 12,345.67 [2;" "] [error in expression]
[2740] 12,345.67 [2;" "] [error in expression]
[2745] 12,345.67 [2;"."] [error in expression]
[2750] 12,345.67 [2;". "] [error in expression]
[2755] 12,345.67 [2;" ."] [error in expression]
[2760] 12,345.67 [2;","] [error in expression]
[2765] 12,345.67 [2;", "] [error in expression]
[2770] 12,345.67 [2;" ,"] 12,345 67
[2775] 12,345.67 [2;".,"] 12,345.67
[2780] 12,345.67 [2;",."] 12,35
[2810] 12.345,67 [none] 12.35
[2815] 12.345,67 [0;" "] [error in expression]
[2820] 12.345,67 [0;" "] [error in expression]
[2825] 12.345,67 [0;""] [error in expression]
[2830] 12.345,67 [0;""] [error in expression]
[2835] 12.345,67 [0;" "] [error in expression]
[2840] 12.345,67 [0;" "] [error in expression]
[2845] 12.345,67 [0;"."] [error in expression]
[2850] 12.345,67 [0;". "] [error in expression]
[2855] 12.345,67 [0;" ."] [error in expression]
[2860] 12.345,67 [0;","] [error in expression]
[2865] 12.345,67 [0;", "] [error in expression]
[2870] 12.345,67 [0;" ,"] 12
[2875] 12.345,67 [0;".,"] 12
[2880] 12.345,67 [0;",."] 12.346
[2910] 12.345,67 [none] 12.35
[2915] 12.345,67 [1;" "] [error in expression]
[2920] 12.345,67 [1;" "] [error in expression]
[2925] 12.345,67 [1;""] [error in expression]
[2930] 12.345,67 [1;""] [error in expression]
[2935] 12.345,67 [1;" "] [error in expression]
[2940] 12.345,67 [1;" "] [error in expression]
[2945] 12.345,67 [1;"."] [error in expression]
[2950] 12.345,67 [1;". "] [error in expression]
[2955] 12.345,67 [1;" ."] [error in expression]
[2960] 12.345,67 [1;","] [error in expression]
[2965] 12.345,67 [1;", "] [error in expression]
[2970] 12.345,67 [1;" ,"] 12
[2975] 12.345,67 [1;".,"] 12
[2980] 12.345,67 [1;",."] 12.346
[3010] 12.345,67 [none] 12.35
[3015] 12.345,67 [2;" "] [error in expression]
[3020] 12.345,67 [2;" "] [error in expression]
[3025] 12.345,67 [2;""] [error in expression]
[3030] 12.345,67 [2;""] [error in expression]
[3035] 12.345,67 [2;" "] [error in expression]
[3040] 12.345,67 [2;" "] [error in expression]
[3045] 12.345,67 [2;"."] [error in expression]
[3050] 12.345,67 [2;". "] [error in expression]
[3055] 12.345,67 [2;" ."] [error in expression]
[3060] 12.345,67 [2;","] [error in expression]
[3065] 12.345,67 [2;", "] [error in expression]
[3070] 12.345,67 [2;" ,"] 12
[3075] 12.345,67 [2;".,"] 12
[3080] 12.345,67 [2;",."] 12.346
[1010] 7/11 [3;""] 1
[1015] 10000/0.5 [0;"."] 20000
[1020] 50t000d00 [0;",."] 50
[1025] 50,000.00 [0;",."] 50
[1030] 50,000.00 [0;".,"] 50,000
[1010] 7/11 [3;""] 1
[1015] 10000/0.5 [1;"."] 20000.0
[1020] 50t000d00 [1;",."] 50,0
[1025] 50,000.00 [1;",."] 50,0
[1030] 50,000.00 [1;".,"] 50,000.0
[1010] 7/11 [3;""] 1
[1015] 10000/0.5 [2;"."] 20000.00
[1020] 50t000d00 [2;",."] 50,00
[1025] 50,000.00 [2;",."] 50,00
[1030] 50,000.00 [2;".,"] 50,000.00 0 Attachment
Hi John,
 In ntbclips@yahoogroups.com, "John Shotsky" <jshotsky@...> wrote:
>
> I write code that deals with international measurements every
> day, and find that even the meaning of a
> cup is different in different countries.
"Cup" is ambiguous from the start. It's what you drink from, and there is no rule fixing the size of your morning coffee container.
My morning coffee comes in a 12 oz cup, filled from an "8 cup" machine, which fills about 3.5 of my cups. Perhaps the coffe machine comes from China, like everything else (has anyone ever wondered where this trend will end?). Perhaps the Chinese farmers, who specified the 8 cups used ceremonial tea cups?
What's this got to do with NoteTab clips? or this thread?
H="Form Letter"
;variables set before running this clip
To: ^%recipient%
^%recaddress%
Date: ^$GetDate$
Dear ^%recipient%,
I recently purchased a ^%product% from ^%retailer%, which turned out to be ^%problem%. I want my money back!
I paid $^%paid%, including tax, for the ^%product%, and wasted ^%waste% at a cost of ^%wastecost% testing your ^%product%.
Please send your remittance of $^$Calc(^%waste% + ^%paid%;2)$ to
^%address%
along with instructions about which city dump you would like your ^%product% to be deposited.
With warmest regards,
^%author%
;end of clip 0 Attachment
joy8388608 wrote:> Eric is probably sorry he started the calc function enhancement. :)
I too don't see the advantage. So far I haven't hit any snags or
disadvantages for myself either, so I'll keep out of it, but it does
seem a violation of KISS.
Axel 0 Attachment
 In ntbclips@yahoogroups.com, "joy8388608" <mycroftj@...> wrote:>
Joy,
> Finally, for now, I created a much better and more detailed calc
> test clip for myself and, it may help others. I checked carefully
> for mistakes, but this is the type of code that makes it easy to
> miss things.
I suppose there are some mistakes in this version of your test.
In [2915] to [2980], you intend to output 1 decimal but, actually, you are calculating with 0 decimals:
> ^!InsertText [2915] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
From [3015] to [3080] it's 2 decimals vs 0 in ^$Calc$:
> ^!InsertText [2920] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [2925] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
> ^!InsertText [2930] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
> ^!InsertText [2935] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [2940] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [2945] 12.345,67 [1;"."] ^$Calc(12.345,67/1;0;".")$^P
> ^!InsertText [2950] 12.345,67 [1;". "] ^$Calc(12.345,67/1;0;". ")$^P
> ^!InsertText [2955] 12.345,67 [1;" ."] ^$Calc(12.345,67/1;0;" .")$^P
> ^!InsertText [2960] 12.345,67 [1;","] ^$Calc(12.345,67/1;0;",")$^P
> ^!InsertText [2965] 12.345,67 [1;", "] ^$Calc(12.345,67/1;0;", ")$^P
> ^!InsertText [2970] 12.345,67 [1;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
> ^!InsertText [2975] 12.345,67 [1;".,"] ^$Calc(12.345,67/1;0;".,")$^P
> ^!InsertText [2980] 12.345,67 [1;",."] ^$Calc(12.345,67/1;0;",.")$^P
> ^!InsertText [3015] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
Certainly, this will affect the expected results...
> ^!InsertText [3020] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [3025] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
> ^!InsertText [3030] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
> ^!InsertText [3035] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [3040] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> ^!InsertText [3045] 12.345,67 [2;"."] ^$Calc(12.345,67/1;0;".")$^P
> ^!InsertText [3050] 12.345,67 [2;". "] ^$Calc(12.345,67/1;0;". ")$^P
> ^!InsertText [3055] 12.345,67 [2;" ."] ^$Calc(12.345,67/1;0;" .")$^P
> ^!InsertText [3060] 12.345,67 [2;","] ^$Calc(12.345,67/1;0;",")$^P
> ^!InsertText [3065] 12.345,67 [2;", "] ^$Calc(12.345,67/1;0;", ")$^P
> ^!InsertText [3070] 12.345,67 [2;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
> ^!InsertText [3075] 12.345,67 [2;".,"] ^$Calc(12.345,67/1;0;".,")$^P
> ^!InsertText [3080] 12.345,67 [2;",."] ^$Calc(12.345,67/1;0;",.")$^P
Regards,
Flo 0 Attachment
 In ntbclips@yahoogroups.com, "flo.gehrke" <flo.gehrke@...> wrote:>
Ahhh! I TOLD you my eyes had crossed! Sorry and thank you for catching that. I've now checked VERY carefully and think that is all the errors EXCEPT the last 3 [1010] lines which should be
>  In ntbclips@yahoogroups.com, "joy8388608" <mycroftj@> wrote:
> >
> > Finally, for now, I created a much better and more detailed calc
> > test clip for myself and, it may help others. I checked carefully
> > for mistakes, but this is the type of code that makes it easy to
> > miss things.
>
> Joy,
>
> I suppose there are some mistakes in this version of your test.
>
> In [2915] to [2980], you intend to output 1 decimal but, actually, you are calculating with 0 decimals:
>
> > ^!InsertText [2915] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [2920] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [2925] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
> > ^!InsertText [2930] 12.345,67 [1;""] ^$Calc(12.345,67/1;0;"")$^P
> > ^!InsertText [2935] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [2940] 12.345,67 [1;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [2945] 12.345,67 [1;"."] ^$Calc(12.345,67/1;0;".")$^P
> > ^!InsertText [2950] 12.345,67 [1;". "] ^$Calc(12.345,67/1;0;". ")$^P
> > ^!InsertText [2955] 12.345,67 [1;" ."] ^$Calc(12.345,67/1;0;" .")$^P
> > ^!InsertText [2960] 12.345,67 [1;","] ^$Calc(12.345,67/1;0;",")$^P
> > ^!InsertText [2965] 12.345,67 [1;", "] ^$Calc(12.345,67/1;0;", ")$^P
> > ^!InsertText [2970] 12.345,67 [1;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
> > ^!InsertText [2975] 12.345,67 [1;".,"] ^$Calc(12.345,67/1;0;".,")$^P
> > ^!InsertText [2980] 12.345,67 [1;",."] ^$Calc(12.345,67/1;0;",.")$^P
>
> From [3015] to [3080] it's 2 decimals vs 0 in ^$Calc$:
>
> > ^!InsertText [3015] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [3020] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [3025] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
> > ^!InsertText [3030] 12.345,67 [2;""] ^$Calc(12.345,67/1;0;"")$^P
> > ^!InsertText [3035] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [3040] 12.345,67 [2;" "] ^$Calc(12.345,67/1;0;" ")$^P
> > ^!InsertText [3045] 12.345,67 [2;"."] ^$Calc(12.345,67/1;0;".")$^P
> > ^!InsertText [3050] 12.345,67 [2;". "] ^$Calc(12.345,67/1;0;". ")$^P
> > ^!InsertText [3055] 12.345,67 [2;" ."] ^$Calc(12.345,67/1;0;" .")$^P
> > ^!InsertText [3060] 12.345,67 [2;","] ^$Calc(12.345,67/1;0;",")$^P
> > ^!InsertText [3065] 12.345,67 [2;", "] ^$Calc(12.345,67/1;0;", ")$^P
> > ^!InsertText [3070] 12.345,67 [2;" ,"] ^$Calc(12.345,67/1;0;" ,")$^P
> > ^!InsertText [3075] 12.345,67 [2;".,"] ^$Calc(12.345,67/1;0;".,")$^P
> > ^!InsertText [3080] 12.345,67 [2;",."] ^$Calc(12.345,67/1;0;",.")$^P
>
> Certainly, this will affect the expected results...
>
> Regards,
> Flo
>
^!InsertText [3110] 7/11 [0;""] ^$Calc(7/11;0;"")$^P
^!InsertText [3210] 7/11 [1;""] ^$Calc(7/11;1;"")$^P
^!InsertText [3310] 7/11 [2;""] ^$Calc(7/11;2;"")$^P
and also renumbered.
All in all, the new parameter does mostly make sense once you understand it
(Still working on understanding [2970] 12.345,67 [1;" ,"] 12 3)
I hope the corrected clip helps anyone who is a little confused or unsure. (I doubt anyone wants it posted again. Let me know if I should or if there is a better place to put it.)
Thanks!
Joy 0 Attachment
Hi Flo,
> I had to edit clips executing something like this...
Thanks for this info. This issue will be fixed in the next maintenance
>
> ^!Set %OldDateValue%=^$GetDateToInt(1.8.2012;d.m.yyyy)$
> ^!Set %NewDateValue%=^$Calc(^%OldDateValue%+10)$
> ^!Info New date value is ^%NewDateValue%
> ^!Info New date is = ^$GetDateFromInt(^%NewDateValue%;d.m.yyyy)$
>
> ^$GetDateFromInt$ can't calculate a date value integer like '41.132'. For me, it works fine when changing line #2 to...
>
> ^!Set %NewDateValue%=^$Calc(^%OldDateValue%+10;.)$
release...

Regards,
Eric Fookes
http://www.fookes.com/
Your message has been successfully submitted and would be delivered to recipients shortly.