Description: I have spreadsheet in LO 7.4.3.2 that work well. I installed LO 7.5.1.2 and the calculation by a formula does not work anymore. I de-installed LO 7.5.1.2 and re installed LO 7.4.3.2 an example of a spreadsheet with the formula is attached Steps to Reproduce: 1.download the xls 2.open it in LO 7.4.3.2 and You will see that the formula works 3.open it in LO 7.5.1.2 and You will see that is does not work. Actual Results: the result is not visable in the field Expected Results: a right number after calculation Reproducible: Always User Profile Reset: Yes Additional Info: the formula is =SOM(D6-C6-E6)*24 where colomn C,D, E are hours/minutes = time where column with the result = number add an attachment
Created attachment 186098 [details] example example of an xls that works in LO 7.4.3.2 and does not work in LO 7.5.1.2
no repro in Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: b5c3a7502f7ff6ccf0f829c1f3a2ba50b8584c41 CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL threaded nor in Version: 7.5.0.3 (X86_64) / LibreOffice Community Build ID: c21113d003cd3efa8c53188764377a8272d9d6de CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL threaded
Created attachment 186102 [details] Screenshot in my 7.5.1.2 Worked in my 7.5.1.2: Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: fcbaee479e84c6cd81291587d2ee68cba099e129 CPU threads: 4; OS: Linux 6.1; UI render: default; VCL: kf5 (cairo+xcb) Locale: zh-TW (zh_TW.UTF-8); UI: zh-TW Calc: threaded
I would suggest going to the forum https://ask.libreoffice.org and you might find help in your own language too (see the sub-forums). If other users in the forum can replicate the problem and they also conclude that there is a bug, maybe then you will have more information to provide here in order to replicate the problem and/or confirm that there is really a bug.
Jim Raykowski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/48b7cf3182cc8fb0b728860f9cbb489390074101 tdf#154294 Fix customize notebook bar regression It will be available in 7.6.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Argh! I got the bug number wrong. The above patch is for bug 154296.
no repro with Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: dc50abb7f972c53fcca08d2ac3627e7848456520 CPU threads: 4; OS: Linux 5.19; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
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.
Version: 7.5.8.2 (X86_64) / LibreOffice Community Build ID: f718d63693263970429a68f568db6046aaa9df01 CPU threads: 20; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: nl-NL Calc: threaded