{"id":3781,"date":"2016-07-18T03:00:01","date_gmt":"2016-07-17T19:00:01","guid":{"rendered":"http:\/\/www.finereport.com\/en\/?p=3781"},"modified":"2020-08-31T09:29:14","modified_gmt":"2020-08-31T01:29:14","slug":"set-cell-bulk-attribute","status":"publish","type":"post","link":"https:\/\/www.finereport.com\/en\/product-functions\/set-cell-bulk-attribute.html","title":{"rendered":"What is Cell Bulk Attribute setting?"},"content":{"rendered":"<p>As in excel, our Finereport business intelligence tool can also provide you to set cell bulk attributes. So let&#8217;s have a look at how to operate it in our <a title=\"FineReport BI and reporting tool report designer\" href=\"https:\/\/www.finereport.com\/en\/features\/report-designer\" target=\"_blank\" rel=\"noopener noreferrer\">report designer<\/a>.<br \/>\n<strong>1. Description<\/strong><br \/>\nIn excel, we can operate cells and set cell attributes through the bulk operation. FineReport designer also provides similar functions.<\/p>\n<p><strong>2. The bulk operation for continuous cells<\/strong><br \/>\nSelect a piece of continuous cells to set their styles and change background colors, as shown below:<br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201671318.png\" alt=\"\" \/><\/p>\n<p><strong>3. The bulk operation for non-continuous cells<\/strong><br \/>\nAs mentioned above, we directly select continuous cells. However, how to set attributes of non-continuous cells?<br \/>\nPress the Ctrl key and click the cell for the setting. Then, change its attributes, as shown below:<br \/>\n<img src=\"http:\/\/www.finereport.com\/en\/wp-content\/themes\/fanruan\/images\/201671319.png\" alt=\"\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>As in excel, our Finereport business intelligence tool can also provide you to set cell bulk attributes. So let&#8217;s have a look at how to operate it in our report designer. 1. Description In excel, we can operate cells and set cell attributes through the bulk operation. FineReport designer also provides similar functions. 2. The&#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":[1505,5588,5583,455,5587,1508,5589,5584,616,443,209,5591,5586,5590,1659,1155,613,5585],"_links":{"self":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3781"}],"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=3781"}],"version-history":[{"count":10,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3781\/revisions"}],"predecessor-version":[{"id":10614,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/posts\/3781\/revisions\/10614"}],"wp:attachment":[{"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/media?parent=3781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/categories?post=3781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/tags?post=3781"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.finereport.com\/en\/wp-json\/wp\/v2\/yst_prominent_words?post=3781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}