{"id":6142,"date":"2021-11-24T11:26:56","date_gmt":"2021-11-24T10:26:56","guid":{"rendered":"https:\/\/www.actonic.de\/excel-style-in-confluence-tabellen-filtern-spalten-ordnen-werte-berechnen\/"},"modified":"2023-03-29T11:53:04","modified_gmt":"2023-03-29T09:53:04","slug":"exce-style-in-confluence-filter-tables-organize-columns-calculate-values","status":"publish","type":"post","link":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/","title":{"rendered":"Excel style in Confluence: filter tables, organize columns, calculate values"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_raw_html]JTNDaHIlM0U=[\/vc_raw_html][vc_column_text]Let our tutorial demonstrate how efficiently and easily you can edit tables in Confluence.[\/vc_column_text][vc_video link=&#8221;https:\/\/www.youtube.com\/watch?v=os3Mj04G6hA&amp;ab_channel=Actonic&#8221; align=&#8221;center&#8221;][vc_raw_html]JTNDaHIlM0U=[\/vc_raw_html][vc_column_text]<\/p>\n<h3 id=\"Excel-in-Confluence?-Inline-Table-Editing-can-do-that:\" data-renderer-start-pos=\"1150\">Excel in Confluence? Inline Table Editing can do that:<\/h3>\n<p data-renderer-start-pos=\"1206\"><a class=\"sc-gGBfsJ ezSIMS\" title=\"https:\/\/marketplace.atlassian.com\/apps\/1217271\/inline-table-editing?hosting=datacenter&amp;tab=overview\" href=\"https:\/\/marketplace.atlassian.com\/apps\/1217271\/inline-table-editing?hosting=datacenter&amp;tab=overview\" data-renderer-mark=\"true\">Inline Table Editing<\/a> is a macro for Confluence that we have developed and are constantly optimizing. It was created to make table editing in the online workspace similar to our experience with Excel and co. Without the macro, editing tables is not very intuitive, and especially switching back and forth between edit and view mode takes up a lot of time.<\/p>\n<p data-renderer-start-pos=\"1562\">After all, it often happens that you have just edited a table and published the document, and you remember that you still wanted to change something in a certain cell. How do you proceed? Do you switch back to edit mode and wait for your complex and large table to fully load first? Or do you stay in view mode, click into the cell and make the desired change within a few seconds?<\/p>\n<p data-renderer-start-pos=\"1945\">With Inline Table Editing, you choose the faster and therefore more effective way.<\/p>\n<h3 id=\"Functions-like-Excel:-our-guide\" data-renderer-start-pos=\"2029\">Functions like Excel: our guide<\/h3>\n<p data-renderer-start-pos=\"2062\">To help you get the most out of your work with our macro, we want to give you a step-by-step guide.<\/p>\n<p data-renderer-start-pos=\"2163\"><strong data-renderer-mark=\"true\">Step 1: <\/strong>The first step is to go to any Confluence page and insert the Inline Table Editing macro. To do this, switch to edit mode and type the slash &#8220;\/&#8221;. Now you can enter the name of the macro and select it with one click.<\/p>\n<p>[\/vc_column_text][vc_single_image image=&#8221;6116&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]Of course, you can also insert the macro by searching for it in the directory.[\/vc_column_text][vc_single_image image=&#8221;6118&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 2: <\/strong>Now either create<span id=\"f75e921e-526f-4344-9665-1db1db3b0702\" data-renderer-mark=\"true\" data-mark-type=\"annotation\" data-mark-annotation-type=\"inlineComment\" data-id=\"f75e921e-526f-4344-9665-1db1db3b0702\"> a new table<\/span> directly in the Inline Table Editing macro, or insert an existing table.[\/vc_column_text][vc_single_image image=&#8221;6120&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<\/p>\n<p style=\"padding-left: 40px;\" data-renderer-start-pos=\"2595\"><strong data-renderer-mark=\"true\">Professional tip: <\/strong>You have probably already tried to copy tables from Excel to Confluence, but the formulas were not transferred. To successfully copy Excel tables with formulas, first navigate to &#8220;Formulas&#8221; in Excel and activate &#8220;Show formula&#8221;. Then copy and paste the contents into the &#8220;Inline Table Editing&#8221; macro. Your Excel data will be copied into the &#8220;Inline Table Editing&#8221; macro, keeping the text, numbers, and formulas intact.<\/p>\n<p data-renderer-start-pos=\"3036\"><strong data-renderer-mark=\"true\">Step 3: <\/strong>Click on &#8220;Publish&#8221; to enjoy the benefits of the tool \u2014 because the real magic is revealed <span id=\"97d6241a-d034-4f0e-99d1-e79fbae17dfc\" data-renderer-mark=\"true\" data-mark-type=\"annotation\" data-mark-annotation-type=\"inlineComment\" data-id=\"97d6241a-d034-4f0e-99d1-e79fbae17dfc\">in view m<\/span>ode.<\/p>\n<p>[\/vc_column_text][vc_single_image image=&#8221;6138&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 4:<\/strong> Now you can easily reorder columns by clicking and dragging them.[\/vc_column_text][vc_single_image image=&#8221;6122&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 5: <\/strong>Drag-and-drop multiple rows is also done in no time.[\/vc_column_text][vc_single_image image=&#8221;6140&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 6:<\/strong> Work with functions like in Excel? One of the easiest exercises for Inline Table Editing! Just click on the sum icon (1) of the editing panel and find a matching function, or navigate to the detailed documentation (2) to get to more than 300 other functions.[\/vc_column_text][vc_single_image image=&#8221;6124&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<\/p>\n<p style=\"padding-left: 40px;\"><strong data-renderer-mark=\"true\">Extra tip: <\/strong>Don&#8217;t forget to save the changes you have made. You do that by clicking the &#8220;save x changes&#8221; button that appears once you have made the first change.<\/p>\n<p>[\/vc_column_text][vc_single_image image=&#8221;6126&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 7: <\/strong>If you want to narrow down the table view, we have added numerous filter options for you.[\/vc_column_text][vc_single_image image=&#8221;6128&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<strong data-renderer-mark=\"true\">Step 8: <\/strong>After editing your table in view mode, you can export the result to CSV.[\/vc_column_text][vc_single_image image=&#8221;6130&#8243; img_size=&#8221;full&#8221; alignment=&#8221;center&#8221; onclick=&#8221;link_image&#8221;][vc_column_text]<\/p>\n<h3 id=\"Filters,-functions,-and-features\" data-renderer-start-pos=\"3930\">Filters, functions, and features<\/h3>\n<p data-renderer-start-pos=\"3964\">Inline Table Editing is the perfect addition for your productive work with Confluence tables. Above all, the constant updating of the tool ensures that you can always get the most out of your work performance.<\/p>\n<p data-renderer-start-pos=\"4175\"><strong data-renderer-mark=\"true\">The advantages of the macro<\/strong><\/p>\n<ul class=\"ak-ul\" data-indent-level=\"1\">\n<li>\n<p data-renderer-start-pos=\"4206\">Easily edit tables in view mode<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4241\">Extensive filtering options<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4272\">Autofill in all directions (like Excel)<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4315\">More than 300 built-in functions<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4351\">Grouped in:<\/p>\n<ul class=\"ak-ul\" data-indent-level=\"2\">\n<li>\n<p data-renderer-start-pos=\"4366\">Math and trigonometry<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4391\">Engineering<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4406\">Statistical<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4421\">Financial<\/p>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4434\">Logical<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p data-renderer-start-pos=\"4447\">Full compatibility with Microsoft Excel and Google Sheets<\/p>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p data-renderer-start-pos=\"4510\">By using this tool, it is possible for the first time to enrich Confluence tables with the familiar &#8220;<span id=\"82b65266-fca5-4edd-a8db-4a0da9333fd7\" data-renderer-mark=\"true\" data-mark-type=\"annotation\" data-mark-annotation-type=\"inlineComment\" data-id=\"82b65266-fca5-4edd-a8db-4a0da9333fd7\">Excel style&#8221;.<\/span><\/p>\n<p data-renderer-start-pos=\"4626\">Stop switching back and forth between different <span id=\"a17360b5-0e0b-4106-9387-cc13c12b5b0e\" data-renderer-mark=\"true\" data-mark-type=\"annotation\" data-mark-annotation-type=\"inlineComment\" data-id=\"a17360b5-0e0b-4106-9387-cc13c12b5b0e\">editing modes.<\/span> Now work really effectively and intuitively.<\/p>\n<p data-renderer-start-pos=\"4735\">With Inline Table Editing.<\/p>\n<p data-renderer-start-pos=\"4763\"><span id=\"7963033e-5b8e-4676-be3b-92ada97ef5f8\" data-renderer-mark=\"true\" data-mark-type=\"annotation\" data-mark-annotation-type=\"inlineComment\" data-id=\"7963033e-5b8e-4676-be3b-92ada97ef5f8\">Get the free trial version right now: You will be amazed!<\/span><\/p>\n<p>[\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>You are familiar with the problem: Tables in Confluence are not as intuitive to edit as you know it from Excel, for example. Small changes require many clicks, and you have to switch back and forth between modes. Use our solution, and you will save time and valuable resources. Read now!<\/p>\n","protected":false},"author":15,"featured_media":6134,"comment_status":"open","ping_status":"open","sticky":false,"template":"single_cta.php","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[242],"tags":[342,281,296],"class_list":["post-6142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles-atlassian-best-practises","tag-atlassian-best-practises","tag-confluence-en","tag-inline-table-editing-en"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.9 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel style in Confluence: filter tables, organize columns, calculate values - Actonic \u2013 Unfolding your potential<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel style in Confluence: filter tables, organize columns, calculate values\" \/>\n<meta property=\"og:description\" content=\"You are familiar with the problem: Tables in Confluence are not as intuitive to edit as you know it from Excel, for example. Small changes require many clicks, and you have to switch back and forth between modes. Use our solution, and you will save time and valuable resources. Read now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/\" \/>\n<meta property=\"og:site_name\" content=\"Actonic \u2013 Unfolding your potential\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-24T10:26:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-29T09:53:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"585\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Patricia Modispacher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patricia Modispacher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/\"},\"author\":{\"name\":\"Patricia Modispacher\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"headline\":\"Excel style in Confluence: filter tables, organize columns, calculate values\",\"datePublished\":\"2021-11-24T10:26:56+00:00\",\"dateModified\":\"2023-03-29T09:53:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/\"},\"wordCount\":868,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Inline-Table-Editing-Macro-article-EN.jpg\",\"keywords\":[\"Atlassian Best Practices\",\"Confluence\",\"Inline Table Editing\"],\"articleSection\":[\"Atlassian Best Practises\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/\",\"name\":\"Excel style in Confluence: filter tables, organize columns, calculate values - Actonic \u2013 Unfolding your potential\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Inline-Table-Editing-Macro-article-EN.jpg\",\"datePublished\":\"2021-11-24T10:26:56+00:00\",\"dateModified\":\"2023-03-29T09:53:04+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#primaryimage\",\"url\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Inline-Table-Editing-Macro-article-EN.jpg\",\"contentUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2021\\\/11\\\/Inline-Table-Editing-Macro-article-EN.jpg\",\"width\":1200,\"height\":585},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/actonic.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel style in Confluence: filter tables, organize columns, calculate values\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/\",\"name\":\"Actonic \u2013 Unfolding your potential\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/actonic.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\",\"name\":\"Patricia Modispacher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"caption\":\"Patricia Modispacher\"},\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/author\\\/patricia-modispacher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel style in Confluence: filter tables, organize columns, calculate values - Actonic \u2013 Unfolding your potential","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/","og_locale":"en_US","og_type":"article","og_title":"Excel style in Confluence: filter tables, organize columns, calculate values","og_description":"You are familiar with the problem: Tables in Confluence are not as intuitive to edit as you know it from Excel, for example. Small changes require many clicks, and you have to switch back and forth between modes. Use our solution, and you will save time and valuable resources. Read now!","og_url":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/","og_site_name":"Actonic \u2013 Unfolding your potential","article_published_time":"2021-11-24T10:26:56+00:00","article_modified_time":"2023-03-29T09:53:04+00:00","og_image":[{"width":1200,"height":585,"url":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","type":"image\/jpeg"}],"author":"Patricia Modispacher","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patricia Modispacher","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#article","isPartOf":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/"},"author":{"name":"Patricia Modispacher","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"headline":"Excel style in Confluence: filter tables, organize columns, calculate values","datePublished":"2021-11-24T10:26:56+00:00","dateModified":"2023-03-29T09:53:04+00:00","mainEntityOfPage":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/"},"wordCount":868,"commentCount":0,"image":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","keywords":["Atlassian Best Practices","Confluence","Inline Table Editing"],"articleSection":["Atlassian Best Practises"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/","url":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/","name":"Excel style in Confluence: filter tables, organize columns, calculate values - Actonic \u2013 Unfolding your potential","isPartOf":{"@id":"https:\/\/actonic.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#primaryimage"},"image":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","datePublished":"2021-11-24T10:26:56+00:00","dateModified":"2023-03-29T09:53:04+00:00","author":{"@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"breadcrumb":{"@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#primaryimage","url":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","contentUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","width":1200,"height":585},{"@type":"BreadcrumbList","@id":"https:\/\/actonic.de\/en\/exce-style-in-confluence-filter-tables-organize-columns-calculate-values\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/actonic.de\/en\/"},{"@type":"ListItem","position":2,"name":"Excel style in Confluence: filter tables, organize columns, calculate values"}]},{"@type":"WebSite","@id":"https:\/\/actonic.de\/en\/#website","url":"https:\/\/actonic.de\/en\/","name":"Actonic \u2013 Unfolding your potential","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/actonic.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808","name":"Patricia Modispacher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","caption":"Patricia Modispacher"},"url":"https:\/\/actonic.de\/en\/author\/patricia-modispacher\/"}]}},"jetpack_featured_media_url":"https:\/\/actonic.de\/wp-content\/uploads\/2021\/11\/Inline-Table-Editing-Macro-article-EN.jpg","_links":{"self":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/6142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/comments?post=6142"}],"version-history":[{"count":0,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/6142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media\/6134"}],"wp:attachment":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media?parent=6142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/categories?post=6142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/tags?post=6142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}