https://bugs.freedesktop.org/show_bug.cgi?id=73365
Priority: medium
Bug ID: 73365
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: VBA does not work when spreadsheet opens
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: bitp...@yahoo.com
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
VBA code Function used in spreadsheet cells does not execute when spreadsheet
opens. Cells indicate #NAME?. I stumbled on work around - if macro edit
window is opened so I am reading code code (making no code changes), and then
spreadsheet cell formula is edited (no change to formula), when I press enter
for the edited cell, then macro works. The cell edit will not update unless
teh code editor is opened.
Cell formula: =FT(J2)
VB Function:
Rem Attribute VBA_ModuleType=VBAModule
Option VBASupport 1
Function FT(x)
'
'
'
y = 0
Z = x
Delta = 16750
tax = 0.15
If Z > Delta Then
y = y + Delta * tax
ElseIf Z > 0 Then
y = y + Z * tax
End If
Z = Z - Delta
FT = y
End Function
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
