Issue 77505

Summary:	RPT: spreadsheet format report should retain data field formats
Product:	Base	Reporter:	Regina Henschel <rb.henschel>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED DUPLICATE	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	recent-trunk	Keywords:	new_implementation, oooqa
Target Milestone:	OOo 2.3
Hardware:	All
OS:	Windows XP
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description Regina Henschel 2007-05-19 01:25:10 UTC

If you generate a spreadsheet format report all entries are formatted as text.
This makes it impossible to do any additional calculation on the exported
spreadsheet.

Those data fields which are numbers of any kind (number, date, time, boolean)
should become a number in the spreadsheet and not a text, and they should have
the same number format in the spreadsheet as in the database.

Comment 1 Frank Schönheit 2007-05-19 20:55:45 UTC

resetting target. In opposite to what has been announced, the iTeam decided to use 

- "not determined" when the iTeam had a look at the issue, but decided it is no
showstopper and no "should fix" for the first release

- "no target" when the issue has not been looked at by the iTeam

Comment 2 Regina Henschel 2007-05-21 13:38:02 UTC

setting keywords

Comment 3 marc.neumann 2007-05-22 16:15:45 UTC

confirm, reassign and set target

Comment 4 ocke.janssen 2007-05-24 13:21:30 UTC

This applies also for writer docs.

*** This issue has been marked as a duplicate of 77097 ***

Comment 5 Frank Schönheit 2007-06-27 13:50:17 UTC

fs-> msc: please verify in CWS oj14

Comment 6 marc.neumann 2007-07-03 10:42:42 UTC

verified in CWS oj14 version 0.5.0

Comment 7 Mechtilde 2007-08-13 20:31:25 UTC

-> closed