Package: libreoffice-calc Version: 1:4.3.1-1 Severity: normal --- Please enter the report below this line. ---
Hi folks, This one's very wrong. I'm programming my DB on a spreadsheet; after a mouse copy that returned an error, I saw that the copy was wrong (and I've not any clue why). CALC (only line 1 & 3 are on 3 columns, others on 1): ===================================================== CREATE VIEW common.vtier_name AS SELECT T.id, N.id AS name_id, N.label AS name FROM common.tier T INNER JOIN common.name N ON N.id = T.ri_name; REVOKE ALL ON common.vtier_name FROM public; MOUSE SELECTION =============== MOUSE PASTE INTO DB (middle button): ==================================== test=# CREATE VIEW common.vtier_name_commercial AS test-# SELECT test-# T.id, test-# N.id AS name_id, test-# N.label AS name test-# FROM common.tier T test-# INNER JOIN common.name N ON N.id = T.ri_name; ERROR: relation "vtier_name_commercial" already exists Of course it exist, as I copied 'common.vtier_name' :(( I really don't know where it could come from, as another copy of another block of cells is working correctly. NB: Thinking it could come from a former line, I closed the file (there were others still open) and re-opened it: same error. NB2: I also closed completely LO and re-opened this file: same error. --- 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.1-1 libreoffice-core (= 1:4.3.0-2) | 1:4.3.1-1 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-10 libgcc1 (>= 1:4.1.1) | 1:4.9.1-12 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-6 librevenge-0.0-0 | 0.0.1-3 libstdc++6 (>= 4.9) | 4.9.1-12 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.1-1 ure | 4.3.1-1 zlib1g (>= 1:1.1.4) | 1:1.2.8.dfsg-2 fontconfig | 2.11.0-6.1 fonts-opensymbol | 2:102.6+LibO4.3.1-1 libreoffice-common (>> 1:4.3.0) | 1:4.3.1-1 ure (>= 4.2~) | 4.3.1-1 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-10 libcairo2 (>= 1.2.4) | 1.12.16-3 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.5-1 libcurl3-gnutls (>= 7.16.2) | 7.37.1-1 libdbus-1-3 (>= 1.0.2) | 1.8.6-2 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-6.1 libfreetype6 (>= 2.3.5) | 2.5.2-1.1 libgcc1 (>= 1:4.1.1) | 1:4.9.1-12 libgdk-pixbuf2.0-0 (>= 2.22.0) | 2.30.8-1 libgl1-mesa-glx | 10.2.6-1 OR libgl1 | libglew1.10 (>= 1.10.0) | 1.10.0-3 libglib2.0-0 (>= 2.15.0) | 2.40.0-5 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.35-1 libharfbuzz0b (>= 0.9.18) | 0.9.35-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) | 2:1.0.9-1 libicu52 -- To UNSUBSCRIBE, email to debian-openoffice-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: https://lists.debian.org/20140905184200.5597d9a8@msi.defcon1