Bug 164051 - [EDITING] Formula to Value changes only the active cell of a dispersed cells selection
Summary: [EDITING] Formula to Value changes only the active cell of a dispersed cells ...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.7.2 release
Hardware: x86-64 (AMD64) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-11-25 23:46 UTC by LeroyG
Modified: 2024-11-26 12:54 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 LeroyG 2024-11-25 23:46:37 UTC 
Description:
Description as in summary.

Steps to Reproduce:
1. Select two or more cells/ranges non contiguous (e.g., A1, A3) with formulas (e.g., =1+1)
2. Choose menu Data - Calculate - Formula to Value

Actual Results:
Only the active cell gets the value. Other cells remain with their formulas.

Expected Results:
All selected cell gets their value.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded

Maybe related to tdf#=116161
Comment 1 m_a_riosv 2024-11-26 05:58:57 UTC 
Hi @LeroyG, If I'm not wrong it works so by design, so better I think a request for enhancement.

I have already filled a similar request, to get it working for several sheets selected.
https://bugs.documentfoundation.org/show_bug.cgi?id=116161
Comment 2 LeroyG 2024-11-26 11:44:39 UTC 
Reproducible with:

Versión: 6.4.7.2 (x64)
Id. de compilación: 639b8ac485750d5696d7590a72ef1b496725cfb5
Subprocs. CPU: 4; SO: Windows 10.0 Build 17763; Repres. IU: predet.; VCL: win; 
Configuración regional: es-AR (es_AR); Idioma de IU: es-ES
Calc: threaded

Changed Importance to enhancement.
Comment 3 LeroyG 2024-11-26 12:54:53 UTC 
Enhancement or bug, not sure.

A. If do you select A1:A2, A1:A2 formulas are converted to values.

B. If do you select A1:A2 and A4, being A1 the active cell, only A1 formula is converted to value, not other formula cells.
To be a bit consistent with A, at least A1:A2 must be converted to values.