[Bug 443147] New: broken formula evaluation
https://bugzilla.novell.com/show_bug.cgi?id=443147 Summary: broken formula evaluation Product: openSUSE 11.1 Version: Beta4 Platform: i586 OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: OpenOffice.org AssignedTo: kyu@novell.com ReportedBy: loigu@volny.cz QAContact: qa@suse.de Found By: --- Created an attachment (id=250880) --> (https://bugzilla.novell.com/attachment.cgi?id=250880) simple error situation For any valid formula, oo calc 3.0.0.7 (build 9319) reports error 508. I'm attaching screenshot clearly showing what's the matter - what i have done is just open new document, enter three numbers, sum three cels. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=443147
Ken Yu
https://bugzilla.novell.com/show_bug.cgi?id=443147
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c1
Kohei Yoshida
https://bugzilla.novell.com/show_bug.cgi?id=443147
User loigu@volny.cz added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c2
Jiri Zouhar
There is an extra semicolon (;) at the end of the formula, which makes the formula expression invalid. Can you try again without the semicolon at the end?
No, I can't:) The reason is simple: oo3 won't let me to do this. If I delete the semicolon and hit <enter>, then it appends the semicolon again. So I can't insert '=SUM(A1:A3)' If you need to, I can create a screencast:) As I mentioned - the way I created this was: 1) insert 1 to A1 2) insert 2 to A2 3) insert 3 to A3 4) select B4 5) click on '=' symbol left of input box 6) select 'SUM' from formula list box 7) mark A1:A3 with mouse 8) hit <neter> and voila, B4 contains '=SUM(A1:A3);' It's some sort of autocompletition? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=443147
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c3
--- Comment #3 from Kohei Yoshida
https://bugzilla.novell.com/show_bug.cgi?id=443147
User loigu@volny.cz added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c4
--- Comment #4 from Jiri Zouhar
https://bugzilla.novell.com/show_bug.cgi?id=443147
User pflin@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c5
Fong Lin
https://bugzilla.novell.com/show_bug.cgi?id=443147
User loigu@volny.cz added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c6
Jiri Zouhar
I can not reproduce it with your instructions in Comment #4 in OOo 3.0.0.8. Would you have a try.
Today I upgraded to openSuse 11.1B5 (with OOo 3.0.0.8) and it works, no bug - you can close this :) Thanks for helping. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
https://bugzilla.novell.com/show_bug.cgi?id=443147
User pflin@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=443147#c7
Fong Lin
participants (1)
-
bugzilla_noreply@novell.com