Package: libreoffice-calc Version: 1:4.3.0-2 Severity: normal --- Please enter the report below this line. ---
Hi folks, I'm working on zipcodes from a csv file (structure: zip;town, order by zip). My goal is to de-duplicate zipcodes numbers and towns names for further integration into a database. For towns, I use: VLOOKUP(town name; array=town names+order columns; 2; 0) which returns me the row number of the town's name first occurrence in its list. When town's name has parenthesis, VLOOKUP() returns #N/A instead of the wanted result: TOWN ORDER DE-DOUBLON … 'ARUE' 38875 16686 'FAAA (AEROPORT)' 38876 #N/A 'TETIAROA (ILE)' 38877 #N/A 'FAAA (PUURAI)' 38878 #N/A 'FAAA (DOMICILES)' 38879 #N/A 'HITIAA' 38880 38880 'MAHAENA' 38881 38881 'PAPENOO' 38882 38882 'TIAREI' 38883 38883 'MAHINA (SAUF OROFARA)' 38884 #N/A 'OROFARA' 38885 38885 … I don't think this is a wanted behavior (well, at least for me). BTW, when I changed: …(ILE) to: …[ILE] in the reference column for test (one line only), it hanged AT LEAST FIVE MINUTES before giving hand back! (w/ AutoCalculate still off:( 100% of one core during this time (CPU: i5-4210M w/ 4GB RAM). Sheet is ~40,000 lines, 11 cols. It took about the same time to recalculate (F9), and the same when back to …(ILE). Result: either () or [] triggers the same #N/A. LO multi-core processing would be very welcome. --- System information. --- Architecture: amd64 Kernel: Linux 3.14-2-amd64 Debian Release: jessie/sid 500 unstable www.deb-multimedia.org 500 unstable ftp.fr.debian.org 500 trusty ppa.launchpad.net --- Package information. --- Depends (Version) | Installed =================================================-+-===================== libreoffice-base-core (= 1:4.3.0-2) | 1:4.3.0-2 libreoffice-core (= 1:4.3.0-2) | 1:4.3.0-2 lp-solve (>= 5.5.0.13-5+b1) | 5.5.0.13-7+b1 libboost-iostreams1.55.0 | 1.55.0+dfsg-2 libc6 (>= 2.14) | 2.19-7 libgcc1 (>= 1:4.1.1) | 1:4.9.1-5 libicu52 (>= 52~m1-1~) | 52.1-5 liblcms2-2 (>= 2.2+git20110628) | 2.6-3 libmwaw-0.3-3 | 0.3.1-2 libodfgen-0.1-1 | 0.1.1-2 liborcus-0.8-0 | 0.7.0+dfsg-4 librevenge-0.0-0 | 0.0.1-3 libstdc++6 (>= 4.9) | 4.9.1-5 libwps-0.3-3 | 0.3.0-2 libxml2 (>= 2.7.4) | 2.9.1+dfsg1-4 uno-libs3 (>= 4.3.0~alpha) | 4.3.0-2 ure | 4.3.0-2 zlib1g (>= 1:1.1.4) | 1:1.2.8.dfsg-1 fontconfig | 2.11.0-5 fonts-opensymbol | 2:102.6+LibO4.3.0-2 libreoffice-common (>> 1:4.3.0) | 1:4.3.0-2 ure (>= 4.2~) | 4.3.0-2 libatk1.0-0 (>= 1.12.4) | 2.12.0-1 libboost-date-time1.55.0 | 1.55.0+dfsg-2 libc6 (>= 2.16) | 2.19-7 libcairo2 (>= 1.2.4) | 1.12.16-2 libclucene-contribs1 (>= 2.3.3.4) | 2.3.3.4-4 libclucene-core1 (>= 2.3.3.4) | 2.3.3.4-4 libcmis-0.4-4 (>= 0.4.0) | 0.4.1-7 libcups2 (>= 1.4.0) | 1.7.4-4 libcurl3-gnutls (>= 7.16.2) | 7.37.1-1 libdbus-1-3 (>= 1.0.2) | 1.8.6-1 libdbus-glib-1-2 (>= 0.78) | 0.102-1 libeot0 | 0.01-3 libexpat1 (>= 2.0.1) | 2.1.0-6 libexttextcat-2.0-0 (>= 2.2-8) | 3.4.4-1 libfontconfig1 (>= 2.11) | 2.11.0-5 libfreetype6 (>= 2.3.5) | 2.5.2-1.1 libgcc1 (>= 1:4.1.1) | 1:4.9.1-5 libgdk-pixbuf2.0-0 (>= 2.22.0) | 2.30.7-1 libgl1-mesa-glx | 10.2.4-1 OR libgl1 | libglew1.10 (>= 1.10.0) | 1.10.0-3 libglib2.0-0 (>= 2.15.0) | 2.40.0-3 libglu1-mesa | 9.0.0-2 OR libglu1 | libgraphite2-3 (>= 1.2.2) | 1.2.4-3 libgtk2.0-0 (>= 2.24.0) | 2.24.24-1 libharfbuzz-icu0 (>= 0.9.18) | 0.9.34-1 libharfbuzz0b (>= 0.9.18) | 0.9.34-1 libhunspell-1.3-0 (>= 1.3.3) | 1.3.3-2 libhyphen0 (>= 2.7.1) | 2.8.7-3 libice6 (>= 1:1.0.0) -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
