Bug 104360 - formatting style off is going beserc
Summary: formatting style off is going beserc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.0.0.alpha0+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-12-02 17:11 UTC by Xavier Van Wijmeersch
Modified: 2016-12-05 11:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
screenshot of begaving of style misbegaving (47.03 KB, image/png)
2016-12-02 17:11 UTC, Xavier Van Wijmeersch 		Details
readings of electric counter (54.99 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-12-05 10:43 UTC, Xavier Van Wijmeersch 		Details
normal formatting style (42.02 KB, image/png)
2016-12-05 10:45 UTC, Xavier Van Wijmeersch 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Xavier Van Wijmeersch 2016-12-02 17:11:12 UTC 
Created attachment 129259 [details]
screenshot of begaving of style misbegaving

inserting data one day sum begave normal
in header of colums "dagmeter"
the other the fornating is going beserc

formula

="Dagmeter van "&TEXT(jul_aug.D7;"mmmm") &" tot "& TEXT(H8;"mmmm ") &jul_aug.D86+jul_aug.J86+sep_okt.D85+sep_okt.J85+nov_dec.D85+nov_dec.J85&" Kwh"


Version: 5.2.5.0.0+
Build ID: feacae8571d003c60960d852e835a17ef722265c
CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-5-2, Time: 2016-12-01_11:20:26
Locale: nl-BE (en_US.UTF-8); Calc: group

also in

Version: 5.4.0.alpha0+
Build ID: c5bc7820482c9dc69fcbd54d8c3a8c0ed27c8d30
CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-12-01_02:52:40
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 1 m_a_riosv 2016-12-03 16:09:39 UTC 
Please could you attach a sample file as short as possible.
Comment 2 Xavier Van Wijmeersch 2016-12-05 10:43:17 UTC 
Created attachment 129313 [details]
readings of electric counter

this is the file where it happens
one day the sum counting is ok and
when adding a new reading the next day its set more numbers after
the comma then the used formatting style
Comment 3 Xavier Van Wijmeersch 2016-12-05 10:45:22 UTC 
Created attachment 129314 [details]
normal formatting style
Comment 4 m_a_riosv 2016-12-05 11:40:56 UTC 
There are not format used for the value Kwh's sum on A1, normally it should have as many decimals like the number in the sum with more decimals, but can happens that the sum can result on a number with periodic decimals, what I think is your first case.
There is not a solution for that than format the number as text in the formula:
A1: ="Nachtmeter van "&TEXT(jul_aug.D7;"mmmm")&" tot "&TEXT(H8;"mmmm ")&TEXT(jul_aug.D41+jul_aug.J41+sep_okt.D40+sep_okt.J40+nov_dec.D40+nov_dec.J40;"#0,00")&" Kwh"
or rounding
A1: ="Nachtmeter van "&TEXT(jul_aug.D7;"mmmm")&" tot "&TEXT(H8;"mmmm ")&ROUND(jul_aug.D41+jul_aug.J41+sep_okt.D40+sep_okt.J40+nov_dec.D40+nov_dec.J40;2)&" Kwh"

Resolved as not a bug, please if you are not agree, reopen it.