Titles in Columns Example
Section 1
Section 1a
Content data
Content data
Section 2
Section 2a
Content data
Content data
HTML in Cells
Most HTML/CSS can be included in Flex table cells.
Formatted text (could be dynamic) Text with Bold, Underlined, Red
Images (could select different images based on scenario/logic)
Ordered List:
1. Coffee
2. Tea
3. Milk
Conditional Formatting, HyperLinks, lists, and many other possibilities UnOrdered List:
• Coffee
• Tea
• Milk
AnalysisPlace Sample Content -- Sunday Nov 19, 2023 2:51 PM
Image of Ranges
See Excel Worksheet: Image
This feature transfers the image (PNG) of the named range, just as it looks in Excel.
Name the cell or range of cells (starting with the prefix and ending with "_img"). Include any content in the range (conditional
formatting, sparklines, images, shapes, text boxes, smart art, dynamic items, etc.) The image (PNG) of all content in the range will be
transferred to your Word/Ppt document just the way it appears in Excel.
Some users choose to transfer images of tables instead of updating text within each cell. This may be easier than formatting tables in
Word/PowerPoint, however, it will significantly increase transfer size and will make the Word/PowerPoint file much larger.
Note: Currently, this is only compatible with Office for Windows. It is not yet compatible with Macs. In Office Online, it only transfers
content within the range (including conditional formatting), but not items added on top of the range (such as images). The same
image content can be transferred to Word/PPT by putting the content on charts, then submit the chart image (this works on Macs).
Image based on range containing a variety of formula-based elements
This example shows sparklines, conditional formatting, and a chart in a range. The source of the image below is a named range in
Excel.
Mac and Border Issue Fix
Original png image (missing border and other issues on Mac):
Fix applied (paste as linked picture)
AnalysisPlace Sample Content -- Sunday Nov 19, 2023 2:51 PM
Charts
See Excel Worksheet: Charts
The chart examples below have been linked to the table “r_CommonCharts”
Column Chart Combo - Clustered Column - Line
80
80
70
70
60
60
50
50
40
40
30
30
20
20
10
10
0
0
Category 1 Category 2 Category 3 Category 4 Category 1 Category 2 Category 3 Category 4
Series A Series B Series C Series A Series B Series C
Area Chart Combo - Stacked Area – Clustered
160 Column
140 80
120
100 60
80
40
60
40 20
20
0 0
Category 1 Category 2 Category 3 Category 4 Category 1 Category 2 Category 3 Category 4
Series A Series B Series C Series A Series B Series C
The chart example below with date based items has been linked to the table “r_DateCharts”
Line Chart
90
80
70
60
50
40
30
20
10
0
16/11/2023 17/11/2023 18/11/2023 19/11/2023
Series A Series B Series C
AnalysisPlace Sample Content -- Sunday Nov 19, 2023 2:51 PM
