https://bugs.documentfoundation.org/show_bug.cgi?id=104360
m.a.riosv <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |NOTABUG
--- Comment #4 from m.a.riosv <[email protected]> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
