http://openoffice.org/bugzilla/show_bug.cgi?id=118259
Issue Type: DEFECT
Summary: cells containing dates become forced numbers with '
preceeding.
Classification: Application
Product: Spreadsheet
Version: OOo 3.3
Platform: PC
URL: http://extranet.awbb.be/
OS/Version: Windows 7
Status: UNCONFIRMED
Severity: enhancement
Priority: P3
Component: open-import
AssignedTo: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
Open the above web site.
Select membres in Données publiques on the left.
Make 2 entries in the selection
write 2543 in Numéro de club and select actif in the selection box Statut.
You are looking for the active basketball players in my club when you click on
"Chercher" button.
Optionnaly you select 100 in Enregistrements par page. Default is 10 as you can
see at the left side and bottom og the list.
You can see that there are 2 colums with dates (naissance (birthdate) &
inscription (start membership)).
Export the excell file with open it or save as membres.xls then open it.
You can see that the dates columns became data and that is my problem.
DETOUR:
After save as membres.xls, open the file with excell viewer (free).
Open a new file for open office calculator.
Copy all the cells then paste special HTML type in open office calc. and the
dates are dates again.
--
Configure bugmail: http://openoffice.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification
from Bugzilla. Please log into the website and enter your comments.
-----------------------------------------------------------------------
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
