R12.1.3 - Custom WebADI : 2 Headers on French laptop - LOV doesn't open due to VBA error
Hello,
I'm creating a custom WebADI and I'm facing one issue, LOV doesn't open while double-clicking.
I checked VBA code and found that there is an issue when we have 2 headers defined, in "GetBneInterfaceColNameOfRange" procedure, while checking "loName.RefersToRange.Parent.name". When we have 2 headers, we have, for example, "Sheet1!$B$3:$D$20,Sheet1!$F$3:$H$12", which corresponds to your 2 headers ranges and "," which separate two ranges, raised an error, with French or Brazlian Portuguese.
If I change the language of my laptop to English (American) it works.
Then, I modified my custom WebADI to have only one header, in French language, and it works, because we only have ""Sheet1!$B$3:$D$40" and no more many ranges for HEADER section.