Bug 132095 - Splitted HSQLDB 2.3.2: Decimal-fields are formatted as currency when table or view used in Calc
Summary: Splitted HSQLDB 2.3.2: Decimal-fields are formatted as currency when table or...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-HSQLDB
  Show dependency treegraph
 
Reported: 2020-04-14 09:44 UTC by Hans
Modified: 2023-05-31 17:52 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Test Split Database with HSQLDB 2.3.2 and Calc and Writer files: Decimal wrongly formatted as currency (1.50 MB, application/zip)
2020-04-14 09:45 UTC, Hans
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Hans 2020-04-14 09:44:00 UTC
Description:
I have a split HSQLDB version 2.3.2, with embedded or split HSQLDB version 1.8 there was no bug.

When a table or view is used in Calc, a decimal field (length 4, decimal places 2, format example 0,00) is formatted as currency. Even if manually formatted as 0,00 in Calc, after Data →Refresh Range, the currency symbol is there again. This is very annoying, because I use the column to store weights.

This behavior occurs not in Writer.

I'll attach an example database and Writer and Calc documents.

The bug still exists in 6.4.2.2, I already experienced it in 6.0.7. I don't know, what the earliest affected version is.


Steps to Reproduce:
1. Create a split database with HSQLDB 2.3.2. Create a table with a column with field type Decimal, lenght 4,  decimal places 2. The format example shows 0,00 € then, so change it to 0,00. 
2. Fill in some values.
3. Register the database and import the table in Calc via View -> Data Sources -> Select the database -> select the table -> Data to Text

Actual Results:
The table is imported but the format of the decimal column is a currency format. (With my German Locale it's #.##0,00 [$€-407];[ROT]-#.##0,00 [$€-407] )
Even if I manually format the column as 0,00 in Calc, after Data →Refresh Range is clicked, the currency symbol is there again. 

Expected Results:
The data is correctly imported with it's format (as 0,00).


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.4.2.2
Build ID: 4e471d8c02c9c90f512f7f9ead8875b57fcb1ec3
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: de-DE (de_DE.utf-8); UI-Language: en-US
Calc: threaded
Comment 1 Hans 2020-04-14 09:45:43 UTC
Created attachment 159552 [details]
Test Split Database with HSQLDB 2.3.2 and Calc and Writer files: Decimal wrongly formatted as currency
Comment 2 Julien Nabet 2020-04-14 10:36:32 UTC
On pc Debian x86-64 with LO Debian package, here what I tried:
- launch Base
- open a embedded HSQLDB file
- create a new table with Design
- field name : "test"
- field type : "decimal"
- Length : 4
- number of decimals : 2
- let default value empty by default
=> format example is disabled and displays "0"
In brief, I don't reproduce this.
Comment 3 Hans 2020-04-14 10:46:34 UTC
@ Julien: Yes, this is what I wrote: It's not happening with the embedded HSQLDB but with a  split database.
Comment 4 Julien Nabet 2020-04-14 11:19:55 UTC
Indeed, I read it too quickly.
Comment 5 Xisco Faulí 2021-11-23 11:08:30 UTC
Hello Hans,
Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 6 Hans 2021-11-23 18:03:09 UTC
The bug is still present in the recent version, I tested it with LibreOffice 7.2.2.2 .
Comment 7 Adam664 2023-05-31 17:52:45 UTC
The bug is still present for **split HSQLDB** database in 

Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: 7e3ddf1e5aae5e4e956495e3d86a8cbf6e251b5e
CPU threads: 1; OS: Linux 6.2; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded