https://bugs.documentfoundation.org/show_bug.cgi?id=173340
Bug ID: 173340
Summary: VBA sheet functions do not accept cell range objects
Product: LibreOffice
Version: 27.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
VBA sheet functions do not accept cell range objects
Steps to Reproduce:
1. Open sample Calc file.
This file contains Basic macros and applies "Option VbaSupport 1".
=GETARGTYPE(123, "ABC", A1, A2:A6)
``` basic
Option Explicit
Option VbaSupport 1
Function getArgType(ParamArray args)
Dim ret As String, ret_0 As String, tname as String, arg
ret = "-- Arguments type --"
For Each arg in args
tname = TypeName(arg)
Select Case tname
Case "Range"
ret_0 = tname & " : " & arg.CellRange.AbsoluteName
Case "Double", "String"
ret_0 = tname & " : " & arg
Case Else
ret_0 = tname
End Select
ret = ret & Chr(10) & ret_0
Next arg
getArgType = ret
End Function
```
Actual Results:
2. You can receive a single cell as a range object, but a range is received as
an array.
Expected Results:
2. Ranges can also be received as range objects.
Reproducible: Always
User Profile Reset: No
Additional Info:
It seems to have been changed to 2026-07-09 or 2026-07-10.
---
Reproducible in
[2026-08-27]
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: c49435178ea0e42d0a03bfec52e4990e88307f3b
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Reproducible in
[2026-07-10]
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: e6c5c62df58df57bf948f6cb86d6ba1e47a2d0d3
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
---
Not reproducible in
[2026-07-09]
Version: 27.2.0.0.alpha0+ (X86_64)
Build ID: 0522c17c2298e68fd8aa7e4bfd0c936210f2ef37
CPU threads: 2; OS: Linux 6.12; UI render: default; VCL: kf5 (cairo+xcb)
Locale: ja-JP (ja_JP.UTF-8); UI: en-US
Calc: threaded
Not reproducible in
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 10.0 Build 26200; UI render: default; VCL: win
Locale: ja-JP (ja_JP); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
