Summary: | EDITING: ** Expression is faulty ** selecting cells in table | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Xisco Faulí <xiscofauli> |
Component: | Writer | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | CC: | aron.budea, raal, serval2412, xiscofauli |
Priority: | medium | Keywords: | bibisected, bisected |
Version: | 5.2 all versions | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 122755 | ||
Attachments: | sample file |
Description
Xisco Faulí
2019-11-11 23:42:32 UTC
I can reproduce this bug in Version: 6.4.0.0.alpha1+ (x86) Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30 Locale: en-US (en_US); UI-Language: en-US Calc: threaded But, not it LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 Hi Xisco, Did have a look to your sample file and i found that your formula is wrong =suma(<E3:E6>) need to be =suma<E3:E6> idem for formula in Total Factura and then everything is working fine its a WFM Best Regards (In reply to Xavier Van Wijmeersch from comment #2) > Hi Xisco, > > Did have a look to your sample file and i found that your formula is wrong > =suma(<E3:E6>) need to be =suma<E3:E6> > idem for formula in Total Factura > > and then everything is working fine > > its a WFM > > Best Regards Hi Xavier, The formula might be wrong, but as said in the description, the sum is correct in 5.0.0.0.alpha1+ Started with 96412245dbfda9f4eee0a7ceeb0e7801ad33ea74 is the first bad commit commit 96412245dbfda9f4eee0a7ceeb0e7801ad33ea74 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Tue Nov 24 21:59:24 2015 -0800 source d667e3210b12c7ce3b3727e2a0e369a520fbaaa4 author Julien Nabet <serval2412@yahoo.fr> 2015-11-22 17:42:08 +0100 committer Mike Kaganski <mikekaganski@hotmail.com> 2015-11-24 22:03:10 +0000 commit d667e3210b12c7ce3b3727e2a0e369a520fbaaa4 (patch) tree dbceb51cdab2c9205e483a859a34f1a838cbc9e6 parent 994d80fd53bc264cef92017dba5cbab1241e5a5b (diff) tdf#61228: Wrong function names in Formula Writer are considered as SUM I know that Calc can use localized function but I just wonder if it's also true in Writer. I mean if you replace by "SUMA" by "SUM" in formula, it works. The quoted commit fixed a bugtracker where an unknown function was always considered as "SUM". If I try different languages from this page: https://help.libreoffice.org/Writer/Calculating_Cell_Totals_in_Tables/de I see "=sum" which is quoted for French and German, Portuguese but for Spanish I indeed see "=suma" but is it a doc bug or code bug? Repro 7.1+ This is not a bug, but fixed tdf#61228: before that fix, just *any garbage* as a function name (including, but not limited to, wrong spelling / expected localization of "sum") was ignored, and its argument was processed as sum. It was fixed, and all wrong formulas surfaced *correctly* and *expectedly*. This formula are wrong, and only worked previously because of that bug. |