problems while copying and pasting data with the XL2BB-tool,

[BSALV]

when i copy the data in from this post Linear interpolation of 2-way array using spill functions, then i get the data like here below.
There are sometimes 2 points in a number, sometimes very thing is multiplied with a factor ?
There is no logic in it.
What is going wrong ? A setting ?
important : i use the comma as decimal separator and the point for the thousands

Map1
	A	B	C	D	E	F
1	Bar	1	2	3	4	5
2
3
4
5
6
7
8
9
10
11
12
13
14	x1 [m]	-11.15	-10.057.881	-8.618.945	-8.219.738	-8.219.738
15	x2 [m]	-11.149.999	-912.788	-8.618.944	-7.529.737	-7.529.737
16	x3 [m]	-8.618.946	-8.618.946	-0.500001	-5.209.739	-5.909.739
17	x4 [m]	-8.618.945	-8.618.945	-0.5	-4.519.738	-5.219.738
18	y1 [mm2]	0	0	245.436.926.061.703	0	0
19	y2 [mm2]	15.707.963.267.949	245.436.926.061.703	245.436.926.061.703	785.398.163.397.448	785.398.163.397.448
20	y3 [mm2]	15.707.963.267.949	245.436.926.061.703	245.436.926.061.703	785.398.163.397.448	785.398.163.397.448
21	y4 [mm2]	0	0	245.436.926.061.703	0	0
22
Blad3

 

[MARK858]

important : i use the comma as decimal separator and the point for the thousands

Just to say that it is pasting fine for me so I think you may be right that it has something to do with the issue.
Will probably have to wait for @smozgur to have a look at the issue (he is tagged in but will have to wait until he is online obviously).

x1 [m]	-11.1500000000	-10.0578810000	-8.6189450000	-8.2197380000	-8.2197380000
x2 [m]	-11.1499990000	-9.1278800000	-8.6189440000	-7.5297370000	-7.5297370000
x3 [m]	-8.6189460000	-8.6189460000	-0.5000010000	-5.2097390000	-5.9097390000
x4 [m]	-8.6189450000	-8.6189450000	-0.5000000000	-4.5197380000	-5.2197380000
y1 [mm2]	0.0000000000	0.0000000000	2454.3692606170	0.0000000000	0.0000000000
y2 [mm2]	1570.7963267949	2454.3692606170	2454.3692606170	785.3981633974	785.3981633974
y3 [mm2]	1570.7963267949	2454.3692606170	2454.3692606170	785.3981633974	785.3981633974
y4 [mm2]	0.0000000000	0.0000000000	2454.3692606170	0.0000000000	0.0000000000

 

[BSALV]

the comma and point, that are my regional settings, so i can't change that.
Is there the same problem when i upload something ?
1st column is a double value between 1 and 2 in the numberformat "0.000".
The 2nd column is a double variable >1E12
,

Map2
	A	B
1	1,005	4.751.754.471.304,2800
2	1,002	7.060.715.171.607,4000
3	1,003	6.712.706.764.010,7200
4	1,001	1.198.081.086.553,1300
5	1,004	3.354.559.392.818,0900
6	1,005	3.825.867.734.575,3200
7	1,010	1.583.521.727.523,6900
8	1,006	1.142.894.638.037,6200
9	1,008	8.650.951.097.051,0500
10	1,002	6.090.955.811.107,1100
11	1,006	3.296.146.307.197,9500
Blad1

Cell Formulas
Range	Formula
A1:A11	A1	=1+RAND()/100
B1:B11	B1	=RANDBETWEEN(1000000000000,10000000000000)+RAND()

 

[MARK858]

Is there the same problem when i upload something ?

It copies across ok, but then it will as you have formulas in the cells so it will just recalculate the formulas in the destination sheet

 

[BSALV]

Oeps, first 5 lines are constants now.

Map1
	A	B	C
1	1,683	1.005.591.715.023,280	values
2	1,535	6.423.170.712.223,680
3	1,888	2.953.776.222.649,480
4	1,764	8.655.523.153.149,140
5	1,039	6.908.281.891.117,600
6	1,334	2.232.118.287.577,310	formulas
7	1,892	3.096.233.272.681,860
8	1,201	6.693.878.924.405,580
9	1,700	4.449.923.301.451,120
10	1,017	4.516.956.467.097,500
Blad1

Cell Formulas
Range	Formula
A6:A10	A6	=1+RAND()
B6:B10	B6	=RANDBETWEEN(1000000000000,10000000000000)+RAND()

if i drag with the mouse over it, it seems okay.

 

[smozgur]

When you create a mini-sheet in Excel, it doesn't matter which regional settings are being used. The numbers will be displayed however they are formatted in the current regional setting (comma vs period). Just like below ("comma" is used as the decimal separator in the sample mini-sheet. Move your mouse pointer over the cells, and you will see the value with "period as decimal separator" that will be copied when you click on the copy button).

Book 5.xlsx
	A	B	C	D	E	F
1	x1 [m]	-11,15	-10,05788	-8,618945	-8,219738	-8,219738
2	x2 [m]	-11,15	-9,12788	-8,618944	-7,529737	-7,529737
3	x3 [m]	-8,618946	-8,618946	-0,500001	-5,209739	-5,909739
4	x4 [m]	-8,618945	-8,618945	-0,5	-4,519738	-5,219738
5	y1 [mm2]	0	0	2454,3693	0	0
6	y2 [mm2]	1570,7963	2454,3693	2454,3693	785,39816	785,39816
7	y3 [mm2]	1570,7963	2454,3693	2454,3693	785,39816	785,39816
8	y4 [mm2]	0	0	2454,3693	0	0
Sheet1

However, BB2XL (BB2XL: as I call "copy from the mini-sheet to the worksheet") must assume a default decimal separator, and it is "period" in XL2BB. So, no matter what regional settings you used to create the mini-sheet in Excel, it will be displayed as formatted in Excel BUT it will be copied that the decimal separator is "period".

You can see the same behavior in Excel Online. For example:
1- Enter a number in a worksheet in Excel Online, where the decimal separator is "period". I entered 1570.796327
2- Copy this cell and paste it into a worksheet in Excel Windows where the decimal separator is "comma".
3- You will get 1570796327

Copy from Excel Online (HTML version - Decimal separator: period)

Paste into Excel Windows (Decimal separator: comma)

Right, we usually have some difficulties between the HTML and the Desktop worlds and especially when the user's computer's regional setting is unknown. So, all that can be done is to make it work with a default setting, which is "period is the decimal separator" in this case.

Hope this explains it.

 

[smozgur]

It copies across ok, but then it will as you have formulas in the cells so it will just recalculate the formulas in the destination sheet

This is correct by the way (Thanks @MARK858). When it comes to formulas, it just recalculates the result where it is pasted in Excel with the system's regional settings.

 

[BSALV]

That's okay concerning the explanation, but how do i correctly import BB2XL into my PC ?
Have to do it like importing a TXT-file ?

I tried copy and paste it the normal way by clicking on the icon, a 2nd time with the Alt-key, a 3rd time by just selecting the values in the screen and then CTRL+C and CTRL+V.
Non of them gave a good result.

 

[smozgur]

but how do i correctly import BB2XL into my PC ?

I am really forcing myself to think of a solution for this.
Have I thought about this before? Yes, but considering it has been only asked twice in 2.5 years, so, it's not a high priority issue especially also considering the applicability.

I admit that it is not like converting function names to another language, so we use English function names as default obviously, but this is still a complicated issue. I am not promising anything, but I am thinking.

 

[smozgur]

I tried copy and paste it the normal way by clicking on the icon, a 2nd time with the Alt-key, a 3rd time by just selecting the values in the screen and then CTRL+C and CTRL+V.
Non of them gave a good result.

No, none of these will work. As I explained, it is designed to work with "period" as the decimal separator.

Please let me think.