Issue 112441 - iseven() / isodd() | EN <- != -> DE | ist[un]gerade()
Summary: iseven() / isodd() | EN <- != -> DE | ist[un]gerade()
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOO320m18
Hardware: Mac Mac OS X 10
: P2 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2010-06-16 12:26 UTC by alex_rng
Modified: 2013-02-02 03:00 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description alex_rng 2010-06-16 12:26:38 UTC
iseven() & isodd() does not translate to istgerade() & istungerade() and vice
versa. this breaks formulas when eg. uploading a spreadsheet to google docs.

i don't know why, but those two seem to be the only ones which do not translate
into each other.

i really hope you can fix this! (it annoys me XD)

thank you.
Comment 1 Regina Henschel 2010-06-17 00:07:50 UTC
Please tell us, which ODF setting do you use in Tools->Options->Load/Save and
which file format when saving. What is the exact error message and what content
do you see in the input line?
Your UI is German? And your settings for language too?
Comment 2 alex_rng 2010-06-17 01:55:14 UTC
UI & Region : German
Std language for documents is english

ODF File version 1.2 extended
ODF format to be optimized
always warn  when blah

usual Error Message: #Macro?

(and yes, i am sure its no macro, i tend to not use them in my spreadsheets at all)

when the very same file gets saved as ODF & as XLS, this error showed in both files.

it got fixed PARTIALLY, just now: i downloaded and installed the US english pack
(although i usually use GB, but the english GB language pack is not yet avail)
and whoops: now it get imported correctly.

but only the ods. the ods file saved as xls now renders the iseven() / isodd()
formula completely useless for OOO, and the german istgerade() doesn't get it
into google docs as iseven()

though google docs had recently (weeks! it have been weeks!) problems to accept
odf formatted documents ... thus why i saved a copy of it as xls in the first
case. so when interacting with google docs we're still stuck here.

maybe the issue should be reassigned to the excel-export/import team :s

personal ODF-only fix: install an english language pack and it works.
Comment 3 Regina Henschel 2010-06-17 18:24:25 UTC
I have no problems exchanging documents with GoogleDocs, if I use the ods format
and have OOo in German. But I have got WinXp and something might be different
with MAC.

GoogleDocs uses ODF 1.1. Therefore you should try to set Load/Save to "ODF
1.0/1.1" when saving before uploading the file. Perhaps this already helps.

Using xls-format is a different problem and so please write one issue for ods
format (if there still is an issue) and one issue for xls-format. In case of
xls-format you should also make sure, that the file you downloaded from
GoogleDocs can be opened without errors in Excel, for to make sure, that the
problem is in OOo and not in GoogleDocs. The drop down lists in GoogleDocs show
only English functions names, so I doubt, that GoogleDocs is able to use
localized names.

Comment 4 Regina Henschel 2010-06-17 21:03:57 UTC
I do not think, that the #MACRO? error is a problem with GoogleDocs or with
English<->German at all, but it is an error in OOo itself handling the AddIn
functions. I have written issue 112489 for that.

Please look, whether you see any error in connection to GoogleDocs, which goes
beyond the error I described in issue 112489.

Comment 5 Rob Weir 2013-02-02 03:00:29 UTC
This Issue requires more information ('needmoreinfo'), but has not been updated
within the last year. Please provide feedback as requested and re-test with the the latest version of OpenOffice - the problem(s) may already be addressed. 

You can download Apache OpenOffice 3.4.1 from

Please report back the outcome of your testing, so this Issue may be closed or
progressed as necessary - otherwise the issue may be Resolved as Invalid in the