LogoLogo
Version 1.48
Version 1.48
  • nedyx
  • Welcome to nedyx
  • 🚀Getting started
    • Preparation
    • Basic widget formatting
    • The first formula
    • More formulas
    • Combine several tables
    • Add a new page
    • Widget references across pages
    • Add a chart widget
    • Further adjustments
  • 🖊️Working with nedyx
    • Apps
    • Live and Edit mode
    • The Header bar
    • Pages
    • Widgets
      • Widget types
      • Adding widgets
      • Widget selection
      • Widget positioning
      • Style tab
      • Content tab
      • Table widget types
      • Cell styles
      • Chart content
      • Chart properties
      • Undo / redo
    • Databases
      • Connect to a database
      • Get external data
    • File management
  • 📖ClearLines Functions
    • General Aspects
      • Formula structure
      • The formula editor
      • Actions
      • Calculated widget properties
        • Content property
        • Cell styles property
        • Chart labels
        • Column widths and Row heights
        • Connection property
        • Editable property
        • MinY and MaxY properties
        • Style property
        • Tooltips
        • Visible property
      • Ranges
      • Widget references
      • Widget cell references
      • Menu widget synchronization
    • Action functions
      • ACTIONCOLUMN
      • ACTIONCONTENT
      • ACTIONROW
      • CLICK
    • Database functions
      • CALLURL
      • EXECUTE
      • GETDATA
      • GETDBCOLUMNNAMES
      • GETSTATEMENT
    • Date functions
      • CREATEDATE
      • DATE
      • DATETOTEXT
      • DAY
      • GETTIMEZONEOFFSET
      • HOUR
      • MILLISECOND
      • MINUTE
      • MONTH
      • SECOND
      • TODAY
      • WEEKDAY
      • YEAR
    • Import / export functions
      • DOWNLOAD
      • DELETEFILE
      • DOWNLOADFILE
      • EXCELCREATE
      • GETFILELIST
      • PDFCREATE
      • POSTMESSAGE
      • SCANCODE
      • SENDEMAIL
      • UPLOAD
      • UPLOADFILE
    • Logical functions
      • AND
      • IF
      • ISEMPTY
      • ISUSERACTION
      • LOOP
      • NOT
      • OR
    • Mathematical functions
      • ABS
      • EXP
      • LN
      • LOG
      • MAX
      • MIN
      • MOD
      • MROUND
      • NUMBER
      • PI
      • RAND
      • ROUND
      • SQRT
      • SUM
    • Navigation functions
      • CLOSE
      • GETURLPARAM
      • MESSAGE
      • OPEN
      • OPENWEBPAGE
      • QUESTION
    • Range functions
      • AGGREGATE
      • CELL
      • CELLREF
      • CLEAR
      • COLUMN
      • COLUMNS
      • COMBINE
      • CONVERT
      • COUNT
      • CSVTORANGE
      • CUMULATE
      • DIFF
      • EMPTY
      • FILTER
      • GETTYPE
      • INSERTRANGE
      • INTERSECTION
      • LOOKUP
      • RANGE
      • RANGETOCSV
      • RANGETOHIERARCHY
      • ROW
      • ROWS
      • SEQUENCE
      • SORT
      • TRANSPOSE
      • UNIQUE
      • VISIBLEHIERARCHY
    • Text functions
      • CHAR
      • CODE
      • CREATEMEMBER
      • FIND
      • HIDDENTEXT
      • HTMLTOJSONTEXT
      • LEFT
      • LEN
      • LOWER
      • MID
      • RIGHT
      • SUBSTITUTE
      • TEXT
      • TRIM
      • UPPER
    • User management functions
      • APPLIST
      • ADDUSER
      • APPSHARELIST
      • REMOVEUSER
      • SHAREAPP
      • UPDATEUSER
      • USERLIST
      • USERNAME
    • Widget functions
      • GETSELECTION
      • LOADWIDGETCONTENT
      • NAME
      • PAGE
      • SETSELECTION
      • STOREWIDGETCONTENT
      • UPDATE
  • 🔐Security
    • User Management
      • Workspaces
      • Workspace Roles
      • Adding Users to a Workspace
      • App Roles
      • Share an App with Other Users
      • Guest Access
      • Change Password
  • Appendix
    • Keyboard shortcuts
    • Error handling
    • Feature preview
    • Supported browsers
    • System requirements for on-premises installations
Powered by GitBook
On this page
  1. ClearLines Functions
  2. General Aspects

Widget cell references

PreviousWidget referencesNextMenu widget synchronization

As an extension to widget references, widget cell references are used in formula to retrieve the content of certain widget cells.

Syntax: #pageName.widgetName!A1:B2

with

  • #pageName.widgetName - Reference of the widget (see previous chapter)

  • A1 - starting cell of the cell range, with

    • A: column 1, B: column 2, ...

    • 1: row 1, 2: row 2, ...

  • B2 - ending cell of the cell range

Selecting cell references in the formula editor

While holding down the CTRL key, either a reference to a widget or to cells of a table widget can be inserted into the formula editor:

Remarks

  • Single cells can be referenced by a single click on an already selected widget reference (identified by a dotted frame).

  • Multiple cells can be referenced by drag & drop across multiple cells.

  • After clicking on a widget reference in the formula editor, the corresponding widget or widget cell(s) is marked by a dotted marching frame.

Examples

  • #table1!B3 - returns the cell content of column 2 and row 3, of the widget with name table1

  • #table1!E - returns the content of the whole column 5

  • #table1!3 - returns the content of the whole row 3

  • #table1!B3:D5 - returns the cell range between column 2, row 3 and column 4, row 5.

  • #H5 - returns the content of column 8, row 5 of the widget that executes the current formula.

  • #me!H5 - returns the same as the previous example

📖