Bug 166291 - Repeat: Formula to value doesn't work.
Summary: Repeat: Formula to value doesn't work.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
25.2.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-22 03:59 UTC by Don
Modified: 2025-04-22 17:36 UTC (History)
3 users (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 Don 2025-04-22 03:59:22 UTC 
Description:
Using the Edit \ Repeat option via the GUI or keyboard shortcut Ctrl+Shift+Y
Does not work for the Data \ Calculate \ Formula to Value option.

Steps to Reproduce:
1. Cell A1 enter 1
2. Cell A2 enter 2
3. Cell B1 enter =A1
4. Cell B2 enter =A2
5. Select Cell B1 note value is "=A1" from GUI menu choose Data\Calculate\Formula to Value.  Note cell value changes to "1"
6. Select Cell B2 note value is "=A2" from GUI menu choose Edit\Repeat: Formula to value.  Note cell value remains "=A2"  it SHOULD change to '2'

Actual Results:
The cell formula failed to change to it's value.

Expected Results:
The cell formula should change from '=A2' to '2'


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 4; OS: Windows 7 Service Pack 1 X86_64 (6.1 build 7601); UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-GB
Calc: threaded
Comment 1 mikhail.machine 2025-04-22 06:57:31 UTC 
Hello Don,

Thank you for reporting the bug. I can confirm that the bug is present in master.

Version: 25.2.2.2 (X86_64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 12; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded

and

Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a8ec21adf255b70bb6eeb0a1717190df303d8b26
CPU threads: 12; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Vulkan; VCL: win
Locale: en-US (en_FI); UI: en-US
Calc: threaded
Comment 2 m_a_riosv 2025-04-22 07:45:39 UTC 
Works for me with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 3a729a2b9716902097cc5ba35615b55882d98e9b
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded
Comment 3 meagan.eggert 2025-04-22 17:36:39 UTC 
Version 25.2.1.2
Build ID: d3abf4aee5fd705e4a92bba33a32f40bc4e56f49
CPU threads: 8; OS: Windows 11 x86_64
UI render: Skia/Raster; VCL: win
Locale: en-US; UI: en-US
Calc: threaded

Bug present. Was unable to confirm if the bug is present in master. Marking as NEW.