{"id":3448,"date":"2016-06-18T03:00:08","date_gmt":"2016-06-17T19:00:08","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3448"},"modified":"2019-10-24T14:47:19","modified_gmt":"2019-10-24T06:47:19","slug":"cell-extension","status":"publish","type":"post","link":"https:\/\/frg.fineres.com\/en\/2016\/06\/18\/cell-extension\/","title":{"rendered":"Cell Extension"},"content":{"rendered":"

We will introduce Cell Extension of FineReport reporting tool<\/span><\/a> in this article.Extension literally implies a transformation from singularity to multiplicity.<\/p>\n

1. Description<\/h3>\n

Before jumping to report design, the Chapter will provide a brief introduction to several basic concepts about making a report of FineReport, in combination to Cell extension upon which a report of FineReport is relied.<\/p>\n

Extension literally implies a transformation from singularity to multiplicity, and accordingly, cell extension refers to a transformation from one cell to multiple cells when viewing template effect via the web, as shown below:<\/p>\n

2. Cell Extension<\/h3>\n

As known to anyone who has used Excel, a cell has only horizontal and vertical directions, which is the same case for a report cell of FineReport as an Excel-like report tool. Therefore, a report cell of FineReport can be scaled either horizontally or vertically, or resort to no extension.<\/p>\n

2.1. Vertical extension<\/strong><\/p>\n

For data in a cell to be displayed in a top-down manner, i.e., vertical extension (row extension from one row to multiple rows) as shown below, input in the cell formula range(5)<\/span><\/a> and select Vertical as the extension direction in the right Cell attribute table – extension attribute:<\/p>\n

\"\"<\/p>\n

2.2 Horizontal extension<\/strong><\/p>\n

For data in a cell to be displayed in a left-right manner, i.e., horizontal extension (column extension from one column to multiple columns) as shown below, input in the cell formula range(5)<\/span><\/a> and select Horizontal as the extension direction in the right Cell attribute table – extension attribute:<\/p>\n

\"\"<\/p>\n

2.3 No extension<\/strong><\/p>\n

For no extension of data in a cell as shown below, input in the cell formula range(5)<\/span><\/a> and use No Extension as the default extension direction in the right Cell attribute table – extension attribute:<\/p>\n

\"\"<\/p>\n

Note: The default extension direction is no extension for a cell containing formulas, and vertical extension for a cell containing data columns of a data set.<\/span><\/p>\n

For the address of online video in the section of Cell Extension, please refer to [Cell Extension and Parent-Child Cell]<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

We will introduce Cell Extension of FineReport reportin…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[111],"tags":[117],"_links":{"self":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3448"}],"collection":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":7,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3448\/revisions"}],"predecessor-version":[{"id":8467,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/posts\/3448\/revisions\/8467"}],"wp:attachment":[{"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/categories?post=3448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frg.fineres.com\/en\/wp-json\/wp\/v2\/tags?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}