This is an automated notification sent by LCG Savannah.
It relates to:
task #12232, project CDS Invenio
==============================================================================
LATEST MODIFICATIONS of task #12232:
==============================================================================
Follow-up Comment #2, task #12232 (project cdsware):
Even though it can be imported into Excel, it's not at all an XLS file, and
should not be named as such. CSV would be much better, since it would have
179 characters less per line (HTML tr/td), 83 characters less per file (HTML
start/end) of output, and would be supported by just about any spreadsheet
application under the sky.
Regarding the restrictions, I'm not sure valign, border-color, border-style
and border-width are really necessary for nice output.
==============================================================================
OVERVIEW of task #12232:
==============================================================================
URL:
<http://savannah.cern.ch/task/?12232>
Summary: CDS Excel output format produces invalid HTML, not
Excel files
Project: CDS Invenio
Submitted by: vengmark
Submitted on: 2009-10-30 08:13
Should Start On: 2009-10-29 00:00
Should be Finished on: 2009-10-29 00:00
Category: WebSearch
Priority: 5 - Normal
Status: Invalid
Privacy: Public
Percent Complete: 0%
Assigned to: None
Open/Closed: Open
Discussion Lock: Any
Effort: 0.00
_______________________________________________________
How to reproduce:
1. Do a search in CDS, e.g.
<http://cdsweb.cern.ch/search?cc=Books+%26+Proceedings&ot=020&ot=970&ln=en&p=020%3A'1->z'&f=&action_search=Search&c=Books+%26+Proceedings&c=&sf=&so=d&rm=&rg=10&sc=0&of=hx>.
2. Set "Output format" to "Excel"
3. Click "Search"
4. Save result.xls to disk
The resulting file is not an Excel file, and should therefore not have the
extension .xls. It is also not an HTML file, first because it's missing the
<html>, <head>, <title>, and <body> tags, and second because it's not valid
according to the W3C validator <http://validator.w3.org/>, even after adding
those tags.
_______________________________________________________
Follow-up Comments:
-------------------------------------------------------
Date: 2009-10-30 10:18 By: Victor Engmark <vengmark>
Even though it can be imported into Excel, it's not at all an XLS file, and
should not be named as such. CSV would be much better, since it would have
179 characters less per line (HTML tr/td), 83 characters less per file (HTML
start/end) of output, and would be supported by just about any spreadsheet
application under the sky.
Regarding the restrictions, I'm not sure valign, border-color, border-style
and border-width are really necessary for nice output.
-------------------------------------------------------
Date: 2009-10-30 08:36 By: Jerome Caffaro <jcaffaro>
"Excel" output is in fact an "Excel-compatible" output, that is an output
that can be transposed to an Excel stylesheet (unless we do an .xslx output,
we cannot produce a real Excel output AFAIK).
The output has been reported to be incompatible with Apple "Numbers"
application, and must be correctly imported into OpenOffice "Calc"
application.
For a less surprising results for non-Windows users, we could go to a comma,
tab or space delimited output, with all the consequent restrictions.
See task #3493
_______________________________________________________
Carbon-Copy List:
CC Address | Comment
------------------------------------+-----------------------------
2407 | -COM-
3964 | -SUB-
==============================================================================
This item URL is:
<http://savannah.cern.ch/task/?12232>
_______________________________________________
Message sent via/by LCG Savannah
http://savannah.cern.ch/
