I have one document with minimum 2 sheets. on the first sheet I integrate the formula "=DBSUMME(Konto.$C2:$I591;0;Z$3:Z$45)", searching in the named sheet with arguments from the first sheet. Open it with LO 3.3 under Windows works well. Opening it under Linux results in "#WERT" content in the specific cell.
Changing the second argument from zero to one "=DBSUMME(Konto.$C2:$I591;1;Z$3:Z$45)" solves this behavior.
Is this correct?
Please attach a sample document!
Created attachment 42963 [details]
test file with these sheets and formulas
tested under LibreOffice running on Windows 7 x64 and Ubuntu 11.04 x64
I only can confirm result 220 € in 'E8' with "LibreOffice 3.3.0 RC4 - WIN7 Home Premium (64bit) German UI [OOO330m19 (build 6 / tag 18.104.22.168)]"
Thats correct, the problem occurs on linux.
It works well with LibreOffice 22.214.171.124 OOO330m19 (Build:202) on x64 Suse 11.4 ,
but not with (Suse -)LibreOffice 126.96.36.199 OOO330m19 (Build:8) on same OS
Dietmar, opening the attached file via the Terminal:
cd ~/Desktop && wget -c https://bugs.freedesktop.org/attachment.cgi?id=42963 -O example.ods && localc -nologo example.ods
and noting in cell E8 the malformed syntax:
getting an error notice is expected as putting a 0 in the DatabaseField criteria is instructing DSUM to use column 0 in the function, which does not exist. This was further verified converting the attachment to xls and opening in Excel 2003 (11.5612.6505) via the Terminal:
unoconv --listener && unoconv -f xls example.ods && wine ~/.wine/drive_c/Program\ Files/Microsoft\ Office/OFFICE11/EXCEL.EXE example.xls
More information on DSUM may be found at:
If using 0 in Windows does not produce an error, then this is a bug in the Windows port of LO.
An expected error was produced using a 0 in Ubuntu 11.04, 32-bit.
Description: Ubuntu 11.04
apt-cache policy libreoffice-calc
*** 1:3.3.2-1ubuntu5 0
500 http://us.archive.ubuntu.com/ubuntu/ natty-updates/main i386 Packages
500 http://us.archive.ubuntu.com/ubuntu/ natty/main i386 Packages
Please check if this bug is still reproducible on Linux with the latest stable release (4.1.x).
(In reply to comment #6)
> If using 0 in Windows does not produce an error, then this is a bug in the
> Windows port of LO.
> An expected error was produced using a 0 in Ubuntu 11.04, 32-bit.
Build ID: 087a610fcd5c0c354a9ed6bfccd3451b667d62a3
TinderBox: Win-x86@6-debug, Branch:master, Time: 2013-08-04_21:41:24
Windows 8.1 Enterprise Preview 64 bit
No errors for E8 cell - result is still 220 Euro for:
Adding self to CC if not already on
All cells appear to be working as intended. Perhaps this should be marked as "Resolved - WorksForMe"?
OS: Linux Mint 17.2
(In reply to David Fischer from comment #10)
> All cells appear to be working as intended. Perhaps this should be marked
> as "Resolved - WorksForMe"?
> OS: Linux Mint 17.2
> LO: 188.8.131.52