https://bugs.freedesktop.org/show_bug.cgi?id=58863
Rainer Bielefeld <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Severity|critical |major CC| |LibreOffice@bielefeldundbus | |s.de Summary|Calc - won't calculate |FILEOPEN .xlsx: "IF" |under specificic condition |condition not calculated Version|4.0.0.0.beta2 |4.0.0.0.alpha0+ Master Keywords| |regression Ever confirmed|0 |1 --- Comment #2 from Rainer Bielefeld <[email protected]> --- [Reproducible] with server installation of "4.1.0.0.alpha0+ (Build ID: e90807267808eb062b93d762c50c02113ca40db) TinderBox: Win-x86@6, Branch:master, Time: 2012-12-26_22:00:49 - ENGLISH UI / German Locale on German WIN7 Home Premium (64bit) with own separate User Profile: 0- Make sure that Calc menu 'Tools -> Cell contents - Auto Calculate = checked' 1. Open document, check WSSI.W47 with "=IF((V47<>0);V47;$wssi_1.F31)" It shows "140" (content of $wssi_1.F31), seems ok 2. Now insert several Values (0 ... 5) to V47 Expected: W47 always should show value in V47 except V47=0 Actual: Always shows "141", does not matter whether you modify contents of $wssi_1.F31 (with WSSI.W47=0) or V47<>0 You can heal that problem by a)saving document as .ods, close and reopen b) find & replace all ")" by ")" You also can reproduce with the much more simple new attachment "sample1.ods" 11. open document and save as "sample1.xlsx" OOXML 12. close, reopen 13. Modify Sheet1.C3 due to Step2: Bug: No reaction .xls and .ods are not affected Definitively a FILEOPEN problem, "sample1.xlsx" works fine with LibO 3.6.4.3 and with server-installation of Master "3.7.0alpha0+ – WIN7 Home Premium (64bit) ENGLISH UI [Build ID: b255de8]" (tinderbox: Win-x86@6-fast, pull time 2012-06-05 23:16:58) so Regresion Already [Reproducible] with parallel installation of "LOdev 4.0.0.0.beta2 - GERMAN UI / German Locale [Build ID: 4104d660979c57e1160b5135634f732918460a0)]" {tinderbox: @6, pull time 2012-12-20} on German WIN7 Home Premium (64bit) with separate /4 User Profile for Master Branch, so I think it's a MAB @Stephen Brindle: "Looks different" is not an appropriate description. May be in looked wrong in old version? Please be much more specific in bug reports as requested on <http://wiki.documentfoundation.org/BugReport_Details> If you want to report additonal problems related to your sample document please submit nes Bugs and refer the your att. here due to <https://wiki.documentfoundation.org/QA-FAQ#How_to_use_attached_sample_documents_for_multiple_Bug_Reports> -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
