Bug 169278 - "Only double is supported as time for now!" when calling Application.OnTime with a time value
Summary: "Only double is supported as time for now!" when calling Application.OnTime w...
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Mike Kaganski
URL:
Whiteboard: target:26.2.0 target:25.8.4
Keywords:
Depends on:
Blocks:
 
Reported: 2025-11-05 18:17 UTC by Mike Kaganski
Modified: 2025-11-10 09:24 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2025-11-05 18:17:08 UTC
In a Calc document, create a VBA macro like

Option VBASupport 1

Sub OnTime_Test()
  Application.OnTime Now, "foo"
End Sub

Run it

=> Runtime error: "Only double is supported as time for now!"

Presumably a regression from 63e7a70ad1a6a8ec4190ab510f683d2fc9dea417.
Comment 1 Mike Kaganski 2025-11-08 12:25:09 UTC
https://gerrit.libreoffice.org/c/core/+/193625
Comment 2 Commit Notification 2025-11-08 21:49:42 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/11314c7387dcbb84c7ebcb3bae5c3cd6a83b6524

tdf#169278: handle css::bridge::oleautomation::Date in OnTime

It will be available in 26.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 3 Commit Notification 2025-11-09 09:21:43 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/c3eae64e6ee3f2d2d61f551db5a1a7316a543b6f

tdf#169278: improve unit test

It will be available in 26.2.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.
Comment 4 Commit Notification 2025-11-10 09:24:18 UTC
Mike Kaganski committed a patch related to this issue.
It has been pushed to "libreoffice-25-8":

https://git.libreoffice.org/core/commit/a3d06a7b83fce2bbd92b4ac401f35c8236ba453d

tdf#169278: handle css::bridge::oleautomation::Date in OnTime

It will be available in 25.8.4.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.