https://bugs.documentfoundation.org/show_bug.cgi?id=100130
--- Comment #6 from Spencer Graves <[email protected]> ---
Sorry: My description was incomplete: After you get it in two columns, split
the second column into pounds, shillings and pence using Data -> "Text to
columns" -> Separated by other = "/".
Note that some of the "numbers" are right adjusted, some left. Now "sum" the
pounds column": In LO5.1.2.2, cell B34 contains "=SUM(B14:B33)". That sum in
my version is 99, which is the sum of the numbers that display right adjusted.
The numbers that display left adjusted are apparently recognized as characters,
not numbers, and so do not enter into the sum. "+" gives a different answer:
Cell E17 contains "=E16+B17": E16 contains a number. B17 contains two
characters that look like a number. "+" adds them as numbers.
"=SUM(B14:B33)" treats B17 as character and does NOT include it in the sum.
Thanks, Spencer Graves
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
