Aswin Ravikumar 2 Posted February 15, 2022 Share Posted February 15, 2022 Hi, We are in the process of upgrading from 8105M to 8207.27.0. Compound reports with EXL2K outputs are not working due to the locale setting is being supported. Is there any way we can change the locale settings (FOC3409) Locale settings not supported in Excel 2000 formats. Thanks, Aswin Ravikumar Link to comment Share on other sites More sharing options...
SATHEESH B Posted February 15, 2022 Share Posted February 15, 2022 This is known issue. https://kb.informationbuilders.com/solution/table-hold-format-exl2k-results-error-foc3409-locale-settings-not-supported-excel-2000 I think XLSX Format is recommended since 8201 Release. Link to comment Share on other sites More sharing options...
Aswin Ravikumar 2 Posted February 15, 2022 Author Share Posted February 15, 2022 I agree but we have EXL2K PIVOT reports that does not work in the upgrade environment. I thought there should be some locale setting that can change to make EXL2K work. Link to comment Share on other sites More sharing options...
Ron Moore Posted February 16, 2022 Share Posted February 16, 2022 You could try adding SET DATE_ORDER=DEFAULT. I see in several cases that this resolved the error Link to comment Share on other sites More sharing options...
Aswin Ravikumar 2 Posted February 16, 2022 Author Share Posted February 16, 2022 ron.moore: SET DATE_ORDER=DEFAULT This fixed the issue. Thanks Ron! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now