Bug 117899 - changes parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE
Summary: changes parameters of conditional formatting "Formula is" if copy range from ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Conditional-Formatting
  Show dependency treegraph
 
Reported: 2018-05-30 13:04 UTC by Roman Kuznetsov
Modified: 2018-06-21 12:04 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example of CF with formula (Calc) (16.11 KB, application/octet-stream)
2018-05-30 13:05 UTC, Roman Kuznetsov
Details
example of result (Writer) (22.48 KB, application/octet-stream)
2018-05-30 13:06 UTC, Roman Kuznetsov
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Kuznetsov 2018-05-30 13:04:37 UTC
Description:
changes parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE

changes link to cell into field with formula

Steps to Reproduce:
1. create conditional formatting for range A3:E11 with Condition 1: Formula is - $E3="нет"
2. select range A2:E7 and copy it
3. open Writer document
4. paste (just use icon Paste or Ctrl+V) range in to document (it will be paste as OLE) -> color in range applies don't right
5. double click on pasted OLE object -> enter to edit mode
6. check condition -> it has become Condition 1: Formula is - $E5="нет" (there was 3 in Calc)

Actual Results:  
changes parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE

Expected Results:
parameters of conditional formatting "Formula is" if copy range from Calc and paste it to Writer as OLE remain unchanged


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36
Comment 1 Roman Kuznetsov 2018-05-30 13:05:29 UTC
Created attachment 142405 [details]
Example of CF with formula (Calc)
Comment 2 Roman Kuznetsov 2018-05-30 13:06:04 UTC
Created attachment 142406 [details]
example of result (Writer)
Comment 3 Buovjaga 2018-06-21 12:04:06 UTC
(In reply to kompilainenn from comment #0)
> 6. check condition -> it has become Condition 1: Formula is - $E5="нет"
> (there was 3 in Calc)

For me, editing the condition shows only the default (empty)

Arch Linux 64-bit
Version: 6.2.0.0.alpha0+
Build ID: 0929a98acca8ec4d86caa97d3090a39f89f35f90
CPU threads: 8; OS: Linux 4.17; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on June 20th 2018