Summary: | Simple Sum function is not working (sum of few cell should be simple and easy) | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Palmtree <rae3aton> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED DUPLICATE | ||
Severity: | normal | CC: | miguelangelrv |
Priority: | medium | ||
Version: | 7.2.1.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
Spreadsheet to demonstrate range failure
Screenshot with excel |
Description
Palmtree
2021-10-10 11:23:51 UTC
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 *** |