https://bugs.freedesktop.org/show_bug.cgi?id=46773
Bug #: 46773
Summary: : Format change between database and spreadsheet
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 RC2
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 57805
--> https://bugs.freedesktop.org/attachment.cgi?id=57805
Image of the pivot table. I could also send the database, if it is needed,
tell me, so I will clean it up a bit to make it easier.
Problem description:
I am having a change of formats between a database and a spreadsheet (both made
with libreoffice). Original types in the database are DECIMAL and in the
spreadsheet they appear like DATE or DECIMAL.
Steps to reproduce (not very sure at what moment it appear):
1. I made a table in database.
2. The a query.
3. Import them in a "pivot table" in spreadsheet. At first, everything was Ok
(not really, they seem to be just text for spreadsheet).
4. After a few days it became crazy an started to see both DECIMAL and DATE in
the same original DECIMAL data.
Current behavior:
I think, every new value I insert in database is seen as DATE in spreadsheet.
Expected behavior:
I think spreadsheet should see DECIMAL as it is.
Platform (if different from the browser):
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) AppleWebKit/534.53.11
(KHTML, like Gecko) Version/5.1.3 Safari/534.53.10
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
