https://bugs.freedesktop.org/show_bug.cgi?id=81003
Priority: medium
Bug ID: 81003
Assignee: [email protected]
Summary: Other: BASIC runtime error. '380' Incorrect property
value
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.2.5.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 102371
--> https://bugs.freedesktop.org/attachment.cgi?id=102371&action=edit
Very simple excel spreadsheet with VB macro
Problem description:
I get BASIC runtime error. '380' Incorrect property value when a simple
spreadsheet calls this function in an xls spreadsheet (using LO 4.2.5.2 on Win7
Home Prem)
Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Option Explicit
Global Const DAYS_PER_YEAR As Double = 365.25
Global Const MONTHS_PER_YEAR As Double = 12#
Public Function getCompound(initValue As Double, initDate As Date, finalDate As
Date, intRate As Double) As Double
Dim adjPeriod As Double
adjPeriod = (finalDate - initDate) / DAYS_PER_YEAR
getCompound = initValue * (1 + intRate) ^ adjPeriod
End Function
The macro works if I change VBASupport to 0 but the VBASupport line is added by
LO and it is impractical to expect users to change code every time they open a
Spreadsheet.
What is it actually objecting to?
The same spreadsheet works fine in OO 4.1.0 with Option VBASupport 1
Steps to reproduce:
Open attached spreaheet with LO Calc
Current behavior:
BASIC runtime error. '380' Incorrect property value
Expected behavior:
Correct execution of function as on Excel and OO calc 4.1
Operating System: Windows 7
Version: 4.2.5.2 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
