reassign 429361 openoffice.org-calc
thanks
Upon some reflection, I am reassigning this bug report. OP states that a
givem .xls file can be read by r-cran-gdata [1] but are corrupted by OOo Calc
when read and written. Samples are attached.
Please direct further questions that are not r-cran-gdata related to the OP.
Thank you, Dirk
[1] This is an add-on package to GNU R which wraps around the Perl xls
reader/writer modules in libspreadsheet-(parse|write)excel-perl
On 17 June 2007 at 14:57, Roger Leigh wrote:
| Package: r-cran-gdata
| Version: 2.3.1-2
| Severity: normal
|
| I can use read.xls() to read in a .xls file saved from MS Excel, but
| if I open the file in OOo Calc to change a few labels, and then save it
| (in either 95 or 97/2000/XP format) all of the numbers are replaced by
| the word "GENERAL". I guess this is the cell type specification for the
| number type, rather than the cell contents I expected.
|
| This might be a bug in OOo Calc, but it can successfully read back in
| the file it saved, so I am suspecting that
| /usr/lib/R/site-library/gdata/perl/xls2csv.pl might be making some
| assumption about the file format which doesn't always hold true.
|
|
| I have attached an original data file (rl-unmodified.xls) and a file
| opened and saved in OOo Calc (rl-modified.xls). By running
|
| /usr/lib/R/site-library/gdata/perl/xls2csv.pl filename
|
| the difference in the output of the two files may be directly compared.
|
|
|
| Regards,
| Roger
|
| -- System Information:
| Debian Release: lenny/sid
| APT prefers unstable
| APT policy: (990, 'unstable')
| Architecture: powerpc (ppc)
|
| Kernel: Linux 2.6.18-3-powerpc
| 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 r-cran-gdata depends on:
| ii r-base-core 2.5.1~20070614-1 GNU R core of statistical
computin
| ii r-cran-gtools 2.3.1-1 GNU R package with R programming
t
|
| r-cran-gdata recommends no packages.
|
| -- no debconf information
--
Hell, there are no rules here - we're trying to accomplish something.
-- Thomas A. Edison
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
