-
-
- Creating a Designer Application
- User Interface
- Pages and Navigation
- Database
- Print Process
- Email Process
- Excel Export
- Stylesheets
- Custom Actions
- Text Resource (Run-time) Editor
- Queries
-
- Sections
- Containers
- Textbox
- Checkbox
- Dropdown
- Radio Button
- Calendar
- File Upload
- Input Grids
- Slider
- Content
- Output Grid
- Charts
- Maps
- Gauges
- Action Button
- Show all articles ( 1 ) Collapse Articles
-
-
-
-
- GetDocumentStubs (Application-Level)
- GetRecordExtended (Application-Level)
- GetRecord (Application-Level)
- GetBatchResults (Application-Level)
- GetResult (Application-Level)
- CloseDedicatedSession (Application-Level)
- OpenDedicatedSession (Application-Level)
- SendEmail (Application-Level)
- GenerateDocument (Application-Level)
- MergeDocumentsExtended (Application-Level)
- MergeDocuments (Application-Level)
- DeleteUser (Site-Level)
- UpdateUser (Site-Level)
- CreateUser (Site-Level)
-
-
-
- Version 6.21
- Version 6.20
- Version 6.19
- Version 6.18
- Version 6.17
- Version 6.16
- Version 6.15
- Version 6.14
- Version 6.13
- Version 6.12
- Version 6.11
- Version 6.10
- Version 6.9
- Version 6.8
- Version 6.7
- Version 6.6
- Version 6.5
- Version 6.4
- Version 6.3
- Version 6.2
- Version 6.1
- Version 6.0
- Version 5.2
- Version 5.1
- Version 5.0
- Version 4.8
- Version 4.7
- Version 4.6
- Version 4.5
- Version 4.4
- Version 4.3
- Version 4.2
- Version 4.1
- Version 4.0
- Version 3.5
- Version 3.4
- Version 3.3
- Version 3.2
- Version 3.1
- Version 3.0
- Version 2.5
- Version 2.4
- Version 2.3
- Version 2.2
- Version 2.1
- Version 2.0
- Version 1.6
- Version 1.5
- Version 1.4
- Version 1.3
- Version 1.2
- Version 1.1
- Version 1.0
- Show all articles ( 38 ) Collapse Articles
-
SpreadsheetWEBImage
Created On
byadmin
You are here:
- KB Home
- Other Features
- Custom Worksheet Formulas
- SpreadsheetWEBImage
Works in Converted Applications only
The FieldName in this case is an image file. It will download the image and render it into the cell that has this equation by resizing the image. The developer of the excel file needs to keep the size of the cell large enough so that the image will be viewable when resized by SpreadsheetWEB.
=SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”)
If there is no data or file corresponding to the parameters of SpreadsheetWEBImage, the formula returns “=SpreadsheetWEBImage(#N/A)”. To avoid error message:
=IF(SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”)=”=SpreadsheetWEBImage(#N/A)”,””,SpreadsheetWEBImage(“862ce249-da29-499f-b2c3-9a5dadda8a97″,”1″,”attachment”))