Local settings in XL2BB

[J.Ty.]

XL2BB translates formulas in an incoherent way. My local settings cause Excel to use ; in place od , in formulas. Now, when I post here:

• cell formulas use ,
• data validation formulas use ;
• conditional formatting formulas use ;
• named ranges are not displayed at all, even though I put them in and they were chosen for translation into BB

You can hava a look at the spreadsheet here.

J.Ty.

Book1
	G
1	A
2	False
3
4	0
Sheet1

Cell Formulas
Range	Formula
G2	G2	=AND(A1=TRUE,OR(EXACT(G1,"D"),EXACT(G1,"E"),EXACT(G1,"A"),EXACT(G1,"R")))
G4	G4	=A

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G3	Expression	=AND(A1=TRUE;OR(EXACT(G1;"D");EXACT(G1;"E");EXACT(G1;"A");EXACT(G1;"R")))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
G1	Custom	=AND(A1=TRUE;OR(EXACT(G1;"D");EXACT(G1;"E");EXACT(G1;"A");EXACT(G1;"R")))

 

[Peter_SSs]

Regarding foreign translations of formulas in cell, DV, CF etc, see here

Regarding Named Ranges we already have this, but perhaps the Named Range also needs to be a 'fixed' range. Does XL2BB work for you if you defined "A" directly as, say, Range("B2").

I have added this to the list of questions but Named Range definitions are turning out to be somewhat problematic so I'm not sure where we will end up with them.

 

[J.Ty.]

Thanks Peter!

As you can see below, if a named range is A1:A3, it does get shown. In my attempt from yesterday it was local to the worksheet (so a different problem than in my previous thread), but an OFFSET rather than a direct range.

As for the formula translation, I am probably experiencing the same problems as Marcelo Branco, because I use English Excel, except that formula separator.

Book1
	G
1	A
2	False
3
4	Daniel
5	Ela
6	Felek
Sheet1

Cell Formulas
Range	Formula
G2	G2	=AND(A1=TRUE,OR(EXACT(G1,"D"),EXACT(G1,"E"),EXACT(G1,"A"),EXACT(G1,"R")))
G4	G4	=A

Named Ranges
Name	Refers To	Cells
A	=Sheet1!A1:A3	G2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G3	Expression	=AND(A1=TRUE;OR(EXACT(G1;"D");EXACT(G1;"E");EXACT(G1;"A");EXACT(G1;"R")))	text	NO

Cells with Data Validation
Cell	Allow	Criteria
G1	Custom	=AND(A1=TRUE;OR(EXACT(G1;"D");EXACT(G1;"E");EXACT(G1;"A");EXACT(G1;"R")))

 

[Peter_SSs]

if a named range is A1:A3, it does get shown.

Thanks for the confirmation re the fixed range
.
Yes, I had looked at your linked file so knew of the OFFSET in your named range. An attempt is being made to cover as many named range issues as possible but no certainty of outcome is possible yet.