XL2BB translation of formulas (Portuguese to English)

[Marcelo Branco]

Using Excel 2010 - Portuguese - Brazilian version

When I paste the range using XL2BB the formulas are correctly translated from Portuguese to English.
See cell D2 where the MÁXIMO function was translated to MAX - Perfect!

Book1
	A	B	C	D
1	Name	Score		MaxScore
2	Anthony	10		12
3	John	11
4	Mary	12
Plan3

Cell Formulas
Range	Formula
D2	D2	=MAX(B2:B4)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B4	Expression	=B2=MÁXIMO(B$2:B$4)	text	NO

However, the same is not true of the formulas used in Conditional Formatting - note above that the MÁXIMO has not been translated to MAX.
I don't know why, but maybe CF formulas are being treated as text.

It's not serious - I can live with this by translating formulas with a macro I've been using for a long time - but I thought it was important to report.

M.

 

[Peter_SSs]

Marcelo, I will add it to the list of things to be considered for improvement. Thanks for reporting it.
Can you check if the same thing happens for a formula used in custom Data Validation please?

 

[Marcelo Branco]

Peter

Thanks for answering

As requested: testing Data Validation using formulas

Book1
	A
1	Completed
2	Yes
3	No
4	No
5	Yes
6	Yes
Plan4

Cells with Data Validation
Cell	Allow	Criteria
A2:A6	Custom	=CONT.SE($A$2:$A$6;"No")<=2

Formula was not translated - neither the CONT.SE function nor the argument separator were presented as per US - version.

Should be
=COUNTIF($A$2:$A$6,"No")<=2

M.

 

[Peter_SSs]

Thanks Marcelo. I will pass that on too. No promises about the result. though.

 

[Marcelo Branco]

More tests...

Book1
	A	B	C	D	E
1	Name	Score	MaxScore		CF_Formula
2	Anthony	10	12		Falso
3	John	11			Falso
4	Mary	12			Verdadeiro
Plan3

Cell Formulas
Range	Formula
C2	C2	=MAX(B2:B4)
E2:E4	E2	=B2=MAX(B$2:B$4)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B4	Expression	=B2=MÁXIMO(B$2:B$4)	text	NO

The logical results in E2:E4 (Falso/Verdadeiro) were not translated to False/True

M.

 

[Marcelo Branco]

Thanks Marcelo. I will pass that on too. No promises about the result. though.

Tks

M.