[Bug 543434] New: Openoffice.org cannot compute SUM
http://bugzilla.novell.com/show_bug.cgi?id=543434 Summary: Openoffice.org cannot compute SUM Classification: openSUSE Product: openSUSE 11.2 Version: Milestone 8 Platform: Other OS/Version: Other Status: NEW Severity: Normal Priority: P5 - None Component: OpenOffice.org AssignedTo: bnc-team-ooo@forge.provo.novell.com ReportedBy: vpelcak@novell.com QAContact: kyu@novell.com CC: kendy@novell.com Found By: --- Created an attachment (id=320632) --> (http://bugzilla.novell.com/attachment.cgi?id=320632) Sheet with failed sum computing Hi. OpenOffice.org cannot count for me sum of numbers correctly. See red number in attachment. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=543434
User nopower@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c1
Noel Power
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c2
--- Comment #2 from Kohei Yoshida
http://bugzilla.novell.com/show_bug.cgi?id=543434
User vpelcak@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c3
--- Comment #3 from Vit Pelcak
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c4
--- Comment #4 from Kohei Yoshida
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c5
--- Comment #5 from Kohei Yoshida
http://bugzilla.novell.com/show_bug.cgi?id=543434
User vpelcak@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c8
--- Comment #8 from Vit Pelcak
http://bugzilla.novell.com/show_bug.cgi?id=543434
User vpelcak@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c9
--- Comment #9 from Vit Pelcak
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c10
--- Comment #10 from Kohei Yoshida
Another thing. If those cells cannot be computed to sum, why these can be computed with using +?
Is it the way it should be?
Yes. String it may be, that's how Excel behaves, and we follow that for interoperability reasons. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c11
--- Comment #11 from Kohei Yoshida
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c12
--- Comment #12 from Kohei Yoshida
Problem isn't fact that cells which are formatted as text aren't computed. Problem is that cells once filled in with numbers formatted as text cannot be formatted to numbers until manually edited. Workaround from comment #4 didn't work for me as I tried it with Jan.
You are free to file a FATE request to add a better UI for text to number conversion. That would be a nice enhancement. -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kyoshida@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c13
--- Comment #13 from Kohei Yoshida
(In reply to comment #9)
Another thing. If those cells cannot be computed to sum, why these can be computed with using +?
Is it the way it should be?
Yes. String it may be, ^^^^^^ I meant, Strange it may be. :-P
-- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.
http://bugzilla.novell.com/show_bug.cgi?id=543434
User kendy@novell.com added comment
http://bugzilla.novell.com/show_bug.cgi?id=543434#c14
--- Comment #14 from Jan Holesovsky
participants (1)
-
bugzilla_noreply@novell.com