Public bug reported: Binary package hint: openoffice.org
Doc reports (both in online help and built in help) that the syntax for LOOKUP function is: =LOOKUP(P1;P2:P3;P4:P5) The semicolons are correct for OOo 2.4, but incorrect for 3.0. 3.0 uses the MS Excel format of commas to separate fields: =LOOKUP(P1,P2:P3,P4:P5) 3.0's documentation on this point appears to be a carryover from 2.x. ProblemType: Bug Architecture: i386 DistroRelease: Ubuntu 8.10 NonfreeKernelModules: fglrx Package: openoffice.org-core 1:2.4.1-11ubuntu2 ProcEnviron: PATH=/usr/lib/openoffice/program:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: openoffice.org Uname: Linux 2.6.27-7-generic i686 ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New ** Tags: apport-bug -- Doc Bug in various spreadsheet functions https://bugs.launchpad.net/bugs/294927 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs