Bug 116161

Summary: EDITING: Formula to value doesn't work on several selected sheets, only on the sheet where the cursor is.
Product: LibreOffice Reporter: m_a_riosv <miguelangelrv>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: kohei, raal
Priority: medium    
Version: 6.0.2.1 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 109324    
Attachments: File to reproduce the issue.

Description m_a_riosv 2018-03-03 15:08:00 UTC
Description:
Formula to value doesn't work on several selected sheets at once, only on the sheet where the cursor is.

Steps to Reproduce:
1.Open attached file
2.Goto to Sheet1.B1
3.Select both sheets
4.Menu/Data/Calculate/Formula to value

Actual Results:  
Only in sheet1.b1 the formula is transformed on their value.
in sheet2.b1 the formula remains.

Expected Results:
On both sheets b1 is transformed on their value.


Reproducible: Always


User Profile Reset: No



Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0
Comment 1 m_a_riosv 2018-03-03 15:08:47 UTC
Created attachment 140311 [details]
File to reproduce the issue.
Comment 2 Xavier Van Wijmeersch 2018-03-03 18:57:59 UTC
repro with

Version: 6.1.0.0.alpha0+
Build ID: 7c1f11985c0b42981cf8600840fb87521ce5ad33
CPU threads: 2; OS: Linux 4.14; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-02-28_15:15:24
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 3 raal 2018-03-04 07:05:35 UTC
I can confirm, but don't know if it's a bug. The feature was added in 4.4
https://wiki.documentfoundation.org/ReleaseNotes/4.4#Direct_conversion_of_formulas_into_static_values
Developer is Kohei Yoshida, adding him to cc.
Comment 4 Buovjaga 2018-03-13 15:00:50 UTC
I asked Kohei on IRC:
"I can't look, but without looking it may be a valid issue.  we have tons of features that are supposed to work on multiple sheets but only work on the first sheet due to laziness.
Luckily it's not super hard to get it working on multiple sheets.
Candidate for an easyhack, maybe."
Comment 5 QA Administrators 2019-03-16 03:56:24 UTC Comment hidden (obsolete)
Comment 6 m_a_riosv 2019-03-16 10:19:43 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2021-03-16 04:28:58 UTC Comment hidden (noise, obsolete)
Comment 8 Timur 2022-08-03 07:32:12 UTC
Repro 7.5+. META for multiple sheets would be better than META Calculate.