Package: phpmyadmin Version: 4:3.3.5-1 Severity: important Tags: sid Hello,
I am trying to import from an ODS file, but the import is not being done correctly: if a cell has the same value as the cell in the previous column, then the cell gets ignored. I attach a sample ODS file (created it from scratch as a test). My file has: +------+------+------+------+------+ | A | B | C | D | E | +------+------+------+------+------+ | a | b | b | c | d | | a | b | c | d | e | | a | b | c | c | d | | a | b | c | d | e | +------+------+------+------+------+ But after export the table shows: +------+------+------+------+------+ | A | B | C | D | E | +------+------+------+------+------+ | a | b | c | d | NULL | | a | b | c | d | e | | a | b | c | d | NULL | | a | b | c | d | e | +------+------+------+------+------+ This is not nice for an input file of several thousand rows... :-( Thanks, George. -- System Information: Debian Release: squeeze/sid APT prefers unstable APT policy: (500, 'unstable'), (1, 'experimental') Architecture: i386 (i686) Kernel: Linux 2.6.32-5-686 (SMP w/2 CPU cores) Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/dash Versions of packages phpmyadmin depends on: ii dbconfig-common 1.8.46 common framework for packaging dat ii debconf [debconf-2.0] 1.5.33 Debian configuration management sy ii libjs-mootools 1.2.4.0~debian1-1 compact JavaScript framework ii perl 5.10.1-14 Larry Wall's Practical Extraction ii php5-cgi 5.3.2-2 server-side, HTML-embedded scripti ii php5-mcrypt 5.3.2-2 MCrypt module for php5 ii php5-mysql 5.3.2-2 MySQL module for php5 ii ucf 3.0025 Update Configuration File: preserv Versions of packages phpmyadmin recommends: ii lighttpd [httpd] 1.4.26-3 A fast webserver with minimal memo ii mysql-client-5.1 [mysql-clien 5.1.49-1 MySQL database client binaries ii php5-gd 5.3.2-2 GD module for php5 Versions of packages phpmyadmin suggests: ii mysql-server 5.1.49-1 MySQL database server (metapackage ii mysql-server-5.1 [mysql-serve 5.1.49-1 MySQL database server binaries and -- Configuration Files: /etc/phpmyadmin/config.inc.php changed [not included] -- debconf information: phpmyadmin/remove-error: abort phpmyadmin/setup-username: admin phpmyadmin/db/app-user: phpmyadmin phpmyadmin/remote/host: * phpmyadmin/dbconfig-install: true phpmyadmin/remote/port: * phpmyadmin/dbconfig-upgrade: true phpmyadmin/missing-db-package-error: abort phpmyadmin/upgrade-error: abort phpmyadmin/dbconfig-reinstall: false phpmyadmin/db/dbname: phpmyadmin phpmyadmin/database-type: mysql phpmyadmin/dbconfig-remove: phpmyadmin/mysql/method: unix socket phpmyadmin/purge: false phpmyadmin/install-error: abort * phpmyadmin/reconfigure-webserver: lighttpd phpmyadmin/mysql/admin-user: root phpmyadmin/internal/reconfiguring: false phpmyadmin/remote/newhost: phpmyadmin/internal/skip-preseed: false phpmyadmin/upgrade-backup: true phpmyadmin/passwords-do-not-match:
test1.ods
Description: application/vnd.oasis.opendocument.spreadsheet
