Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenBuildings | AECOsim | Speedikon
  • Product Communities
  • Building
  • OpenBuildings | AECOsim | Speedikon
  • Cancel
OpenBuildings | AECOsim | Speedikon
OpenBuildings | AECOsim | Speedikon Wiki LibreOffice To DataGroup Link Error
    • Building Design - Wiki
    • +OpenBuildings Designer
    • +OpenBuildings Energy Simulator
    • +GenerativeComponents
    • OpenBuildings Station Designer
    • +OpenBuildings Speedikon
    • +OpenBuildings Speedikon + Bentley Speedikon V8i
    • +Bentley Facilities Space Planner CONNECT Edition
    • -AECOsim Building Designer
      • +Annotation - AECOsim Building Designer
      • +Architectural Design - AECOsim Building Designer
      • +ASM (Analytical Space Model)
      • +Configuration - AECOsim Building Designer
      • -DataGroup System - AECOsim Building Designer
        • "Excel has detected that 'MultiCategories.csv' is a SYLK file"
        • Add a new Catalog Instance to the Place Wall dialog
        • Changes to Settings in Schedule Properties in SS6
        • CONNECT Edition - Generating Furniture report by Room
        • DataGroup Catalog Type XML files and workspace schemas
        • DataGroup Discipline Sub-Groups in SS6
        • DataGroup Explorer is renamed Schedules
        • DataGroup System/Catalog definition errors
        • Definition Editor changes in CONNECT Edition
        • Door and Window custom DataGroup property value changes not retained
        • Editing DataGroup Properties From the Schedule in SS6
        • +Error Parsing MRU_Lookups.xml
        • How to add new material i.e property instance for glass in doors?
        • How to convert CAD Elements to BIM Objects with AECOsim Building Designer
        • How to Create a DataGroup Filter in SS6
        • How to use the "EnergySpaceType Description" DataGroup property
        • Improving DataGroup System load time when using MicroStation tools
        • In the Catalog Type Definition dialog where are these paths set? What dictates the system location verses the project/company?
        • LibreOffice To DataGroup Link Error
        • Loading only selected objects within Datagroup Explorer
        • Multiple In-Place Editing Through DataGroup Explorer Schedules in SS6
        • Object Classification descriptions in DataGroup Schedules
        • Place Custom Compound Cell Using The "Place User Defined" Tool
        • Quantification Report of Diffusers in AECOsim Building Designer
        • Where are the HVAC Airflow property values defined?
      • +Dataset and Content - AECOsim Building Designer
      • +Drawing Extraction - AECOsim Building Designer
      • +Drawing Views - AECOsim Building Designer
      • +Electrical Annotation and Design - AECOsim Building Designer
      • +Floors - AECOsim Building Designer
      • +Form Modeling - AECOsim Building Designer
      • +General - AECOsim Building Designer
      • +Grid Systems - AECOsim Building Designer
      • +HVAC Design - AECOsim Building Designer
      • +i-model - AECOsim Building Designer
      • +Import/Export - AECOsim Building Designer
      • +Installation - AECOsim Building Designer
      • +Modify - AECOsim Building Designer
      • +Platform Tools - AECOsim Building Designer
      • +Plumbing Design - AECOsim Building Designer
      • +Print/Plot - AECOsim Building Designer
      • +ProjectWise Integration - AECOsim Building Designer
      • +Settings/Attributes - AECOsim Building Designer
      • +Space Planner - AECOsim Building Designer
      • +Structural Design - AECOsim Building Designer
      • +Utilities - AECOsim Building Designer
      • +Workspace - AECOsim Building Designer
    • +iModel Plugin for Revit
    • +Social Distance Assessments
    • Working from home with OpenBuildings products
    • Working from home with Speedikon
    • +Special Interest Group (SIG) FAQs
    • +Structural Modeler_PS
    • +Configuration Explorer
    • +Legacy Products

     
     Questions about this article, topic, or product? Click here. 

    LibreOffice To DataGroup Link Error

      Product(s): AECOsim Building Designer
      Version(s): 08.11.09.866
      Environment: DataGroup System
      Area: DataGroup Explorer
      Subarea: N/A

    Problem

    We have tried to link LibreOffice Basic to the DataGroup Explorer, using the delivered dataset and got this result: The spreadsheet is opened as a CSV-file and not as an XLS file format.
     
    If I open the AECOsim XLS-file “BuildingDesigner.xls” with LibreOffice I get following error message:

    Solution

    Note: LibreOffice Basic is not certified to be used with AECOsim Building Designer so the following notes are offered as a possible solution. Some Microsoft Excel based functionality may not operate as designed when Excel is not present.

    The error message shows how “LibreOffice Basic” is called meaning it is not compatible to the VBA.
    The syntax of the VBA code is absolutely correct.  The used conditional code:

    #If VBA7 Then
    ‘..
    #Else
    ‘..
    #End If

    It is used with CONNECT Edition to recognize, which version of VBA is used. E.g. VBA 7 is used with AECOsim CONNECT Edition and supports 32 and 64 Bit, VBA 6 is used for 32 Bit only and used with MS V8i generation.

    The error message “If außerhalb einer Prozedur unzulässig” means “If outside of a procedure is invalid”.

    So LibreOffice Basic does not allow this conditional declaration and obviously is not completely compatible with VBA which is how it is required in AECOsim Building Designer or Microsoft Office.

    As a workaround, the conditional declaration could be avoided by creating 2 different VBA files for each case, but this is no guarantee that it will work correctly in all other areas.

    From the MSCE Readme, the VBA components are required as described in readme here:

    https://docs.bentley.com/LiveContent/web/pub.xql?c=t&action=home&pub=MicroStation%20ReadMe-v6&lang=en#docid=GUID-288FAFD8-1107-4FCB-9843-8BECC9099A06&addHistory=true&query=&scope=&tid=&filename=&resource=&inner_id=&toc=false&eventType=lcContent.loadDocGUID-288FAFD8-1107-4FCB-9843-8BECC9099A06

    Microsoft Visual Basic for Applications core
    Microsoft Visual Basic for Applications localized

    • CONNECT Edition
    • Import/Export
    • Excel
    • Datagroup System
    • OpenBuildings Designer
    • Share
    • History
    • More
    • Cancel
    • Gerard Torres Created by Gerard Torres
    • When: Tue, Oct 3 2017 5:51 PM
    • Marc Thomas Last revision by Bentley Colleague Marc Thomas
    • When: Fri, Sep 10 2021 7:31 AM
    • Revisions: 4
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies