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-common1.8.46common framework for packaging dat
ii debconf [debconf-2.0] 1.5.33Debian 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-mcrypt5.3.2-2 MCrypt module for php5
ii php5-mysql 5.3.2-2 MySQL module for php5
ii ucf3.0025Update 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-2GD 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
