Description: I have published the bug on ask.libreoffice.org (including all details - I have received comments from the ask.libreoffice that it is a bug) for bug detail please refer to attached link ==> https://ask.libreoffice.org/t/possible-bug-lo-calc/65859 Steps to Reproduce: 1.Please refer to attached link https://ask.libreoffice.org/t/possible-bug-lo-calc/65859 Actual Results: Refer to attached link (sum of few cell should be simple and easy) people on the forum (ask.libreoffice.org) were able to reproduce the bug and confirm it is a bug should be reported and fixed Expected Results: it it is a basic and simple sum of few cell It is not working! Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: N/A
https://wiki.documentfoundation.org/QA/BugReport#Good_Reports
Created attachment 175621 [details] Spreadsheet to demonstrate range failure 1. Open LibreOffice Calc sheet untitled 1.xlsx with numbers in cells C3:G3 ($1.00 - $5.00) 2. Add the sum function to Cell B3 3. Can't define the range from G3 to C3 (only from G3 to D3) Note: Works if range is defined as C3:G3 Version: 7.2.0.3 (x64) / LibreOffice Community Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: threaded
Works if column B width is increased.
No issue. Version: 7.2.2.2 (x64) / LibreOffice Community Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
I have attached LibreOffice details Version: 7.2.1.2 (x64) / LibreOffice Community Build ID: 87b77fad49947c1441b67c559c339af8f3517e22 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-US Calc: CL
Created attachment 175654 [details] Screenshot with excel Trying again, no difference with excel. (Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20154) 32-bit )
Yes I have reproduce the same bug in Excel. Excel default column width is 10.86 (not sure what unit???) It seems wider than LO Cal default columns width of 2.2578 cm In Excel I have noticed no issue up to column width of 7 As soon as I reduce the columns width to 6 (or lesser), I am able to reproduce the same bug in excel. I thig Excel has similar limitation, and it is been manipulated by setting the default column width to higher value than LO Cal
Click top left corner of LO Cal (to highlight all sheet) Change all cell font size to 8 pt Problem solved
(In reply to Palmtree from comment #8) > Click top left corner of LO Cal (to highlight all sheet) > Change all cell font size to 8 pt > Problem solved Please don't do such thing, you are putting a direct formatting on the whole sheet, what it's really a bad idea. Instead, you can edit 'Default' cell style. Then you can save as a default template, so it is applied to every new spreadsheet. There is already a bug request. *** This bug has been marked as a duplicate of bug 42496 ***