You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/04/12 01:50:25 UTC
[Issue 124665] New: errors in help for functions ZÄHLENWENN and BASIS (German only)
https://issues.apache.org/ooo/show_bug.cgi?id=124665
Issue ID: 124665
Issue Type: DEFECT
Summary: errors in help for functions ZÄHLENWENN and BASIS
(German only)
Product: Calc
Version: 4.1.0-dev
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: help
Assignee: issues@openoffice.apache.org
Reporter: guenter.marxen@googlemail.com
Errors in german help for Calc functions (english help in 3.4.1 is correct so
far).
In the german help for Calc function ZÄHLENWENN and BASIS are the following
errors:
Funktion ZÄHLENWENN()
Fehler im 3. Beispiel
---
Beispiel
A1:A10 ist ein Zellbereich, der die Zahlen 2000 bis 2009 enthält. Die ...
...
ZÄHLENWENN(a1:a10;">=2006") = 3. Falsch!!!
-
Korrekt ist
Beispiel
A1:A10 ist ein Zellbereich, der die Zahlen 2000 bis 2009 enthält. Die ...
...
ZÄHLENWENN(a1:a10;">=2006") = 4
---
Funktion BASIS()
Falsch!!!
---
Beispiel
=BASIS(17;10;4) gibt 0017 im Hexadezimalsystem zurück.
=BASIS(17;2) gibt 10001 im Hexadezimalsystem zurück.
=BASIS(255;16;4) gibt 00FF im Hexadezimalsystem zurück.
---
Korrekt:
=BASIS(17;10;4) gibt 0017 im Dezimalsystem zurück.
=BASIS(17;2) gibt 10001 im Binär-/Dualsystem zurück.
=BASIS(255;16;4) gibt 00FF im Hexadezimalsystem zurück.
---
Bei der Funktion EUROUMRECHNEN fehlt jeder Hinweis zu den Wechselkursen.
UMRECHNEN hat zwar einen Hinweis auf eine "Liste", der Text sagt aber nichts
aus über die Werte bzw. die Stichtage der Kurse.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124665] Wrong result mentioned in German Calc Help for function ZÄHLENWENN
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124665
--- Comment #3 from g.marxen <gu...@googlemail.com> ---
(In reply to Rainer Bielefeld from comment #1)
> ...
> @g.marxen
> Mandatory language here is English, you may send reports to me by E-Mail.
> Please only 1 issue per report, I submit a second one for BASIS
> It saves time if you attach sample documents
@Rainer
I know, therefore at first I explained in English.
But I think the error will be corrected by a native german speaking committer,
so it seems reasonable to describe (and cite!) the error itself in German.
OK I can cite in German and describe in English. ;-))
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124665] Wrong result mentioned in German Calc Help for function ZÄHLENWENN
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124665
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
Component|help |de
Version|4.1.0-dev |4.0.1
Product|Calc |Native-Lang
Summary|errors in help for |Wrong result mentioned in
|functions ZÄHLENWENN and |German Calc Help for
|BASIS (German only) |function ZÄHLENWENN
Ever confirmed|0 |1
--- Comment #1 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Reproducible with "AOO 4.0.1 Release – German UI / German locale
[AOO401m5(Build:9714) - Rev. 1524958 2013-09-20 11:40:29]" on German WIN7
Home Premium (64bit)", “historic” 4.0 User Profile used for all predecessor
versions:
Help in "Kategorie Mathematik - ZÄHLENWENN" (Countif) contains a wrong result
I checked French and Spanish UI with 4.1.0 RC1: correct!
For BASIS Help I submitted "Issue 124666 - Wrong number system mentioned in
German Calc Help for function BASIS (Base)"
@g.marxen
Mandatory language here is English, you may send reports to me by E-Mail.
Please only 1 issue per report, I submit a second one for BASIS
It saves time if you attach sample documents
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124665] Wrong result mentioned in German Calc Help for function ZÄHLENWENN
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124665
--- Comment #4 from g.marxen <gu...@googlemail.com> ---
Bug exists also in AOO4.1.0 RC4.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124665] Wrong result mentioned in German Calc Help for function ZÄHLENWENN
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124665
--- Comment #2 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Created attachment 83176
--> https://issues.apache.org/ooo/attachment.cgi?id=83176&action=edit
Sample Document
For your own tests
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 124665] Wrong result mentioned in German Calc Help for function ZÄHLENWENN
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124665
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Latest|--- |4.1-dev
Confirmation on| |
--- Comment #5 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
(In reply to g.marxen from comment #4)
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.