https://bugs.documentfoundation.org/show_bug.cgi?id=167378
Bug ID: 167378
Summary: Copying a Date cell from one sheet to another with a
macro doesn't work anymore with Version 25.2.4.3
Product: LibreOffice
Version: 25.2.4.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Up to my previously used version 24.8.7 I copied date cells with format
'YYYY-MM-DD' with the following code snippet:
Dim DataCellDate as Date
Worksheets("NeueFounds").Cells(IRow, 16).NumberFormat = "YYYY-MM-DD"
DataCellDate = Worksheets("NeueFounds").Cells(IRow, 16).Value
Worksheets("FoundCaches").Cells(IRow + 1, 11).NumberFormat = "YYYY-MM-DD"
Worksheets("FoundCaches").Cells(IRow + 1, 11).Value = DataCellDate
With version 25.2.4.3 this results in an empty cell
If I specify the variable DataCellDate as String the resulting cell has a date
with exchanged month and date. 2025-07-04 gets 2025-04-07
Steps to Reproduce:
Code snippet in the description
Actual Results:
resulting cell is empty
Expected Results:
Cell value should be a copy of the source cell
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.2.4.3 (X86_64) / LibreOffice Community
Build ID: 33e196637044ead23f5c3226cde09b47731f7e27
CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 26100); UI render:
Skia/Raster; VCL: win
Locale: en-GB (de_CH); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
