HEX2DEC excel export problem

Discuss the spreadsheet application
Post Reply
pase
Posts: 2
Joined: Mon Apr 07, 2008 10:52 am

HEX2DEC excel export problem

Post by pase »

I exported calc file including HEX2DEC function (openoffice 2.4 both Windows and Linux Czech localisation) and resulting Excel worksheet includes function HEXINDEZ (german version of function). Exported function is not understandable for neither Czech nor English localization of excel.

Could anybody help me with Calc setup avoiding this strange behavior?

thanks

Similar things occur with DEC2HEX.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: HEX2DEC excel export problem

Post by acknak »

I think maybe you need to read this: Issue 57772: Some functions are exported as German names in Excel format.

I can't quite tell what's going on there--the developers seem to be saying that Calc is copying Excel's behavior.

If you can understand what the situation is, maybe you can see a workaround, or at least add your functions to the list that's there.

Either way, please report here what conclusions you come to.
AOO4/LO5 • Linux • Fedora 23
pase
Posts: 2
Joined: Mon Apr 07, 2008 10:52 am

Re: HEX2DEC excel export problem

Post by pase »

Thank you for link to issue.

I verify all similar functions (DEC2BIN, ...) and post it back to issue 57772.

I'm sorry to miss known issue, I searched only for HEX functions, not for german. Once more thanks.
User avatar
acknak
Moderator
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: HEX2DEC excel export problem

Post by acknak »

No problem, thanks for providing that info.
AOO4/LO5 • Linux • Fedora 23
Post Reply