{"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":"2025-04-17T15:16:53","modified_gmt":"2025-04-17T07:16:53","slug":"cell-extension","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/cell-extension.html","title":{"rendered":"What is Cell Extension and Why it Matters?"},"content":{"rendered":"<p>We will introduce Cell Extension of FineReport <a title=\"reporting tools\" href=\"\/en\/\" target=\"_blank\" rel=\"noopener\"><span style=\"color: blue;\">reporting tool<\/span><\/a> in this article.Extension literally implies a transformation from singularity to multiplicity.<\/p>\n<div id=\"toc_container\" class=\"toc_transparent no_bullets\"><p class=\"toc_title\">Contents<\/p><ul class=\"toc_list\"><li><a href=\"#1_Description_of_Cell_Extension\">1. Description of Cell Extension<\/a><\/li><li><a href=\"#2_Cell_Extension\">2. Cell Extension<\/a><ul><li><a href=\"#21_Vertical_Cell_Extension\">2.1. Vertical Cell Extension<\/a><\/li><li><a href=\"#22_Horizontal_Cell_Extension\">2.2 Horizontal Cell Extension<\/a><\/li><li><a href=\"#23_No_Cell_Extension\">2.3 No Cell Extension<\/a><\/li><\/ul><\/li><\/ul><\/div>\n<h2><span id=\"1_Description_of_Cell_Extension\">1. Description of Cell Extension<\/span><\/h2>\n<p>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<p>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<h2><span id=\"2_Cell_Extension\">2. Cell Extension<\/span><\/h2>\n<p>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<h3><span id=\"21_Vertical_Cell_Extension\"><strong>2.1. Vertical Cell Extension<\/strong><\/span><\/h3>\n<p>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 <a href=\"http:\/\/help.finereport.com\/doc-view-867.htm\" target=\"_blank\" rel=\"noopener\"><span style=\"color: blue;\">range(5)<\/span><\/a> and select Vertical as the extension direction in the right Cell attribute table &#8211; extension attribute:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201652401.png\" alt=\"\" \/><\/p>\n<h3><span id=\"22_Horizontal_Cell_Extension\"><strong>2.2 Horizontal Cell Extension<\/strong><\/span><\/h3>\n<p>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 <a href=\"http:\/\/help.finereport.com\/doc-view-867.htm\" target=\"_blank\" rel=\"noopener\"><span style=\"color: blue;\">range(5)<\/span><\/a> and select Horizontal as the extension direction in the right Cell attribute table &#8211; extension attribute:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201652402.png\" alt=\"\" \/><\/p>\n<h3><span id=\"23_No_Cell_Extension\"><strong>2.3 No Cell Extension<\/strong><\/span><\/h3>\n<p>For no extension of data in a cell as shown below, input in the cell formula <a href=\"http:\/\/help.finereport.com\/doc-view-867.htm\" target=\"_blank\" rel=\"noopener\"><span style=\"color: blue;\">range(5)<\/span><\/a> and use No Extension as the default extension direction in the right Cell attribute table &#8211; extension attribute:<\/p>\n<p><img class=\"aligncenter\" src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201652403.png\" alt=\"\" \/><\/p>\n<p><span style=\"color: red;\">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<p>For the address of online video in the section of Cell Extension, please refer to <span style=\"color: blue;\">[Cell Extension and Parent-Child Cell]<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We will introduce Cell Extension of FineReport reporting tool in this article.Extension literally implies a transformation from singularity to multiplicity. Contents1. Description of Cell Extension2. Cell Extension2.1. Vertical Cell Extension2.2 Horizontal Cell Extension2.3 No Cell Extension 1. Description of Cell Extension Before jumping to report design, the Chapter will provide a brief introduction to several&#8230;<\/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],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3448"}],"collection":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":8,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3448\/revisions"}],"predecessor-version":[{"id":19659,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3448\/revisions\/19659"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3448"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}