Bug 128755 - Adding style to text results in a value error
Summary: Adding style to text results in a value error
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-12 18:39 UTC by Michel Le Bihan
Modified: 2019-11-12 21:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Michel Le Bihan 2019-11-12 18:39:43 UTC 
Description:
When I write the formula `=123+STYLE("my-style")` the value `123` appears in the cell and the style is applied. If I try to do the same for text, `="abc"+STYLE("my-style")` a value error (`#VALUE!`) is shown.

Steps to Reproduce:
1. Create a custom style or use one of the builtin styles
2. Write or paste the `="abc"+STYLE("my-style")` formula in a cell

Actual Results:
Saw the value error (`#VALUE!`)

Expected Results:
The cell should contain and display the text value with the specified style applied.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 m_a_riosv 2019-11-12 21:11:49 UTC 
+ it's not an string connector but for summing "abc" it's a text not a number.

It can be solved with:
"abc"&T(STYLE("my-style"))