Bug 134714 - VBA Macro: Range names don't work
Summary: VBA Macro: Range names don't work
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Macro-VBA
  Show dependency treegraph
 
Reported: 2020-07-10 11:22 UTC by Xisco Faulí
Modified: 2021-03-17 18:11 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
sample file (12.25 KB, application/vnd.ms-excel.sheet.macroEnabled.12)
2020-07-10 11:22 UTC, Xisco Faulí
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Xisco Faulí 2020-07-10 11:22:24 UTC
Created attachment 162878 [details]
sample file

Steps to reproduce:
1. Open attached document
2. Run checkRange macro

-> BASIC runtime error '1'. Instead, value of A3 should be pasted in A1

Reproduced in

Version: 7.1.0.0.alpha0+
Build ID: 12bfedfac3b141fe6c91b0e5ae5b3fb2ba817c48
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

and

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 1 Xisco Faulí 2020-07-10 11:23:00 UTC
@Eike, I thought you might be interested in this issue
Comment 2 himajin100000 2020-07-10 11:41:25 UTC
FYI:

Sub checkRange()
    Cells(1, 1) = Range("MOISANNEE").Value
End Sub

instead of 

Sub checkRange()
    Cells(1, 1) = Range("CRAM!MOISANNEE").Value
End Sub

works
Comment 4 Xisco Faulí 2020-07-10 16:05:46 UTC
moving to NEW based on comment 2