Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||iseven() / isodd() | EN <- != -> DE | ist[un]gerade()|
|Component:||code||Assignee:||AOO issues mailing list <issues>|
|Status:||UNCONFIRMED ---||QA Contact:|
|OS:||Mac OS X 10|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 Save/Load: 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 http://www.openoffice.org/download 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 future.