BUG. Excel2007. Named formulas corrupted on save/reopen when edited in Non US locale.

  • Thread starter Thread starter keepITcool
  • Start date Start date
K

keepITcool

I'm Running Excel 2007 English version with a Dutch locale, where a
semicolon is used as listseparator.

When a Name is created or edited that includes a non-US separator in
the refersto string and the workbook is saved that name is marked as
corrupted and removed when the workbook is reopened.

I copied this from workbook.xml
<definedName name="LangPos"
comment="">MATCH(LangID;LangVal;0)</definedName>

When I manually edit the xml and replace the semicolon with comma
the workbook opens without problems.
 
Hi KeepITcool,
When a Name is created or edited that includes a non-US separator in
the refersto string and the workbook is saved that name is marked as
corrupted and removed when the workbook is reopened.
Click to expand...

Filed as bug # 932118926.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com
 
Back
Top