https://bugs.documentfoundation.org/show_bug.cgi?id=101225
Bug ID: 101225
Summary: Function VALUE() only gives correct result in Function
Wizard pop-up
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:47.0) Gecko/20100101
Firefox/47.0
Build Identifier: LibreOffice 5.1.4.2
Source data is a substring calculated from the full string in an almost
adjacent location.
If the VALUE() function is applied to this substring from a subsequent cell
utilising the Function Wizard then the pop-up correctly interprets the
individual steps and displays the correct result. However, when the function
wizard formula is accepted it merely produces text of the formula in the field
NOT the anticipated result. Manually entering the formula has the same
incorrect result
Reproducible: Always
Steps to Reproduce:
1.create numerical content string say "10 20 30 40 50"
2.extract substrings into "splits" giving five new text strings "10", "20",
"30", "40", "50"
3.Create Formula either manually or with formula wizard to convert the text
string "10" to numerical value of 10
Actual Results:
ultra small spreadsheet attached together with two screen dumps demonstrating
that the wizard's input and output do not match what is inserted into the cell.
The wizard shows the correct result - what gets posted into the cell is a text
string of the formula - NOT a function formula
Expected Results:
Numerical value of a text string
[Information automatically included from LibreOffice]
Locale: en-GB - Physical location Sweden but account language is set to my
mother tongue
Module: StartModule
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
Reset User Profile?No
--
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
