Jump to content

Component: Data Sheet (Charts): Difference between revisions

From Flowcode Help

SteveT (talk | contribs)

4 user groups
6,427 edits
Created page with "{| style="width:50%" |- | width="20%" style="color:gray;" | Author | Steve Tandy |- | width="20%" style="color:gray;" | Version | 1.0 |- | width="20%" style="color:gra..."
 
m Text replacement - "width="90%" style="background-color:#D8C9D8; color:#4B008D;"" to "width="90%" class="mtx-class-macrohead""
 
(7 intermediate revisions by 2 users not shown)
Line 14: Line 14:
==Data Sheet component==
==Data Sheet component==
A component that accepts data that can then be viewed in a spreadsheet.
A component that accepts data that can then be viewed in a spreadsheet.
==Component Pack==
FREE


==Detailed description==
==Detailed description==


''No detailed description exists yet for this component''
''No detailed description exists yet for this component''


==Examples==
==Examples==


''<span style="color:red;">No additional examples</span>''
''<span style="color:red;">No additional examples</span>''
Line 25: Line 45:
==Downloadable macro reference==
==Downloadable macro reference==


{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
{| class="mtx-class-macrotable wikitable"
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''Clear'''
| width="90%" class="mtx-class-macrohead" | '''Clear'''
|-
|-
| colspan="2" | Resets the XY chart and removes all data points.&nbsp;
| colspan="2" | Resets the XY chart and removes all data points.&nbsp;
Line 38: Line 58:




{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
{| class="mtx-class-macrotable wikitable"
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''AddData'''
| width="90%" class="mtx-class-macrohead" | '''AddData'''
|-
|-
| colspan="2" | Add data to a spreadsheet.  Returns true if ok.&nbsp;
| colspan="2" | Add data to a spreadsheet.  Returns true if ok.&nbsp;
|-
|-
|-
|-
| width="10%" align="center" | [[File:]] -  
| width="10%" align="center" | [[File:Fc9-s16-icon.png]] - INT
| width="90%" | row
| width="90%" | row
|-
|-
| colspan="2" | row for the data (1 - 32767)&nbsp;
| colspan="2" | row for the data (1 - 32767)&nbsp;
|-
|-
| width="10%" align="center" | [[File:]] -  
| width="10%" align="center" | [[File:Fc9-s16-icon.png]] - INT
| width="90%" | column
| width="90%" | column
|-
|-
| colspan="2" | column for the data (1 - 255)&nbsp;
| colspan="2" | column for the data (1 - 255)&nbsp;
|-
|-
| width="10%" align="center" | [[File:]] -  
| width="10%" align="center" | [[File:Fc9-f32-icon.png]] - FLOAT
| width="90%" | data
| width="90%" | data
|-
|-
| colspan="2" | the value to store in the spreadsheet&nbsp;
| colspan="2" | the value to store in the spreadsheet&nbsp;
|-
|-
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:]] -  
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-bool-icon.png]] - BOOL
| width="90%" style="border-top: 2px solid #000;" | ''Return''
| width="90%" style="border-top: 2px solid #000;" | ''Return''
|}
|}




{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
{| class="mtx-class-macrotable wikitable"
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''GetData'''
| width="90%" class="mtx-class-macrohead" | '''GetData'''
|-
|-
| colspan="2" | Returns the data from a spreadsheet row-column reference.&nbsp;
| colspan="2" | Returns the data from a spreadsheet row-column reference.&nbsp;
|-
|-
|-
|-
| width="10%" align="center" | [[File:]] -  
| width="10%" align="center" | [[File:Fc9-s16-icon.png]] - INT
| width="90%" | row
| width="90%" | row
|-
|-
| colspan="2" | row for the data (1 - 32767)&nbsp;
| colspan="2" | row for the data (1 - 32767)&nbsp;
|-
|-
| width="10%" align="center" | [[File:]] -  
| width="10%" align="center" | [[File:Fc9-s16-icon.png]] - INT
| width="90%" | column
| width="90%" | column
|-
|-
| colspan="2" | column for the data (1 - 255)&nbsp;
| colspan="2" | column for the data (1 - 255)&nbsp;
|-
|-
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:]] -
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-f32-icon.png]] - FLOAT
| width="90%" style="border-top: 2px solid #000;" | ''Return''
|}
 
 
{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''RefreshChart'''
|-
| colspan="2" | Redraws the chart.&nbsp;
|-
|-
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID
| width="90%" style="border-top: 2px solid #000;" | ''Return''
|}
 
 
{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''GetData'''
|-
| colspan="2" | Gets a data point from the specified series.&nbsp;
|-
|-
| width="10%" align="center" | [[File:Fc9-u8-icon.png]] - BYTE
| width="90%" | Series
|-
| colspan="2" | Which series to add to (1-8)&nbsp;
|-
| width="10%" align="center" | [[File:]] -
| width="90%" | Index
|-
| colspan="2" | The data point index (1 - 32767)&nbsp;
|-
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:]] -
| width="90%" style="border-top: 2px solid #000;" | ''Return''
|}
 
 
{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
|-
| width="10%" align="center" style="background-color:#D8C9D8;" align="center" | [[File:Fc9-comp-macro.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''AddDataCXYY1'''
|-
| colspan="2" | Adds a data point to a bubble chart.&nbsp;
|-
|-
| width="10%" align="center" | [[File:Fc9-u8-icon.png]] - BYTE
| width="90%" | Series
|-
| colspan="2" | Which series to add to (1-8)&nbsp;
|-
| width="10%" align="center" | [[File:Fc9-string-icon.png]] - STRING
| width="90%" | Category
|-
| colspan="2" | &nbsp;
|-
| width="10%" align="center" | [[File:]] -
| width="90%" | Y
|-
| colspan="2" | Y coordinate&nbsp;
|-
| width="10%" align="center" | [[File:]] -
| width="90%" | X
|-
| colspan="2" | X coordinate&nbsp;
|-
| width="10%" align="center" | [[File:]] -
| width="90%" | Value
|-
| colspan="2" | The value of the data point&nbsp;
|-
| width="10%" align="center" style="border-top: 2px solid #000;" | [[File:Fc9-void-icon.png]] - VOID
| width="90%" style="border-top: 2px solid #000;" | ''Return''
| width="90%" style="border-top: 2px solid #000;" | ''Return''
|}
|}
Line 167: Line 113:
==Property reference==
==Property reference==


{| class="wikitable" style="width:60%; background-color:#FFFFFF;"
{| class="mtx-class-macrotable wikitable"
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" | [[File:Fc9-prop-icon.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-prop-icon.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''Properties'''  
| width="90%" class="mtx-class-macrohead" | '''Properties'''  
|-
|-
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" | [[File:Fc9-conn-icon.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-conn-icon.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''Connections'''  
| width="90%" class="mtx-class-macrohead" | '''Connections'''  
|-
|-
|-
|-
| width="10%" align="center" style="background-color:#D8C9D8;" | [[File:Fc9-conn-icon.png]]
| width="10%" align="center" class="mtx-class-macrohead" | [[File:Fc9-conn-icon.png]]
| width="90%" style="background-color:#D8C9D8; color:#4B008D;" | '''Simulations'''  
| width="90%" class="mtx-class-macrohead" | '''Simulations'''  
|-
|-
|}
|}

Latest revision as of 14:23, 13 July 2026

Author Steve Tandy
Version 1.0
Category Charts


Data Sheet component

A component that accepts data that can then be viewed in a spreadsheet.

Component Pack

FREE

Detailed description

No detailed description exists yet for this component

Examples

No additional examples

Downloadable macro reference

Clear
Resets the XY chart and removes all data points. 
- VOID Return


AddData
Add data to a spreadsheet. Returns true if ok. 
- INT row
row for the data (1 - 32767) 
- INT column
column for the data (1 - 255) 
- FLOAT data
the value to store in the spreadsheet 
- BOOL Return


GetData
Returns the data from a spreadsheet row-column reference. 
- INT row
row for the data (1 - 32767) 
- INT column
column for the data (1 - 255) 
- FLOAT Return



Property reference

Properties
Connections
Simulations
Retrieved from "https://www.flowcode.co.uk/wiki/index.php?title=Component:_Data_Sheet_(Charts)&oldid=46304"