{"id":2823,"date":"2020-12-10T12:06:09","date_gmt":"2020-12-10T12:06:09","guid":{"rendered":"https:\/\/spikes.be\/uncategorized\/fluid-framework-office-scripts\/"},"modified":"2020-12-10T12:06:10","modified_gmt":"2020-12-10T12:06:10","slug":"fluid-framework-office-scripts","status":"publish","type":"post","link":"https:\/\/spikes.be\/en\/blog-en\/fluid-framework-office-scripts\/","title":{"rendered":"Fluid Framework &#038; Office Scripts"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"2823\" class=\"elementor elementor-2823 elementor-2165\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f3ff8b7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f3ff8b7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7182d42\" data-id=\"7182d42\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-70a465e elementor-widget elementor-widget-text-editor\" data-id=\"70a465e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h4>What is the Fluid Framework actually, what does it entail, what can it be used for?<\/h4>\n<p>The Fluid Framework is an open-source collaboration technology for both Office and third-party applications. This collaboration technology is a collaboration platform with which updates to the content are implemented in almost real-time in the various applications that use the technology.<\/p>\n<p>This means that a colleague of yours can edit a table in a Teams conversation, at the same time\u00a0 you or another colleague has the same table open in Excel, regardless of the device with which you and your colleague are consuming this data.<\/p>\n<p><span data-contrast=\"auto\">Curious if this is available within your organization? Check <\/span><a href=\"https:\/\/fluid.microsoft.com\/\"><span data-contrast=\"none\">https:\/\/fluid.microsoft.com<\/span><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-medium\" src=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/blog\/wp-content\/uploads\/sites\/2\/2020\/05\/8-IMAGE_Fluid-Framework.gif\" alt=\"Fluid Framework\" width=\"900\" height=\"506\" \/><\/p>\n<p>Let&#8217;s be clear: the Fluid Framework is still under development, although the preview and recent announcements show that there is potential in it.<\/p>\n<p>We will see the first integrations in Microsoft 365, and more specifically in Outlook and Office.com.<\/p>\n<p>Because the Fluid Framework is open-source, existing components can be further developed to meet the specific needs of our customers, and it is possible to choose to develop components ourselves.<\/p>\n<p>Does Microsoft show what the future of the Office tools (Word, Excel, PowerPoint, ..) will look like?<\/p>\n<p>In this <a href=\"https:\/\/medium.com\/microsoft-design\/m365future-815cf30a8be\">blog<\/a> written by Microsoft Office&#8217;s design head, Jon Friedman, part of the vision and future is already explained, how the focus will be more and more on the content of an end user, instead of on the tool used for this content, is going to be. At Spikes, these developments are in any case closely monitored in order to advise our customers correctly.<\/p>\n<p><div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Imagining Collaboration with the Microsoft Fluid Framework\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/10hXCKbfXAM?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div><\/p>\n<h4><span class=\"TextRun SCXW164484802 BCX0\" lang=\"NL-BE\" style=\"font-size: 24px; font-weight: 500;\" xml:lang=\"NL-BE\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW164484802 BCX0\" data-ccp-parastyle=\"heading 1\">Office\u00a0<\/span><\/span><span class=\"TextRun SCXW164484802 BCX0\" lang=\"NL-BE\" style=\"font-size: 24px; font-weight: 500;\" xml:lang=\"NL-BE\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW164484802 BCX0\" data-ccp-parastyle=\"heading 1\">S<\/span><\/span><span class=\"TextRun SCXW164484802 BCX0\" lang=\"NL-BE\" style=\"font-size: 24px; font-weight: 500;\" xml:lang=\"NL-BE\" data-contrast=\"none\"><span class=\"NormalTextRun SCXW164484802 BCX0\" data-ccp-parastyle=\"heading 1\">cripts<\/span><\/span><\/h4>\n<p>The good old macros and VBA scripts in Excel, but not a good combination with the Office web client. Anyone who has saved an Excel in SharePoint that uses Macros has experienced it before: the web and Teams version does not work as expected, the file should be opened in the desktop app. This is a thing of the past with Office Scripts.<\/p>\n<p>Office Scripts could offer a solution for this. At the time of writing this feature is still in public preview, but can already be used. Although this should be activated by the administrator of the environment on which you work. If the Office Script button is not yet visible to you, this means that this feature is not yet activated on the environment.<\/p>\n<p>Office scripts for Excel Web offers the possibility to automate daily repetitive tasks. The actions performed in the worksheet can be recorded with the \u201cAction Reorder\u201d, which will create a script for you.<\/p>\n<p>Of course there is also the option to even write this script. The Code editor was provided for this. It does not use VBA, but TypeScript is used. Does this seem like something to you? Then be sure to check out the <a href=\"https:\/\/docs.microsoft.com\/en-us\/office\/dev\/scripts\/develop\/scripting-fundamentals\">scripting fundamentals<\/a> for Office Scripts.<\/p>\n<p>After your scripts have been created, they can be shared with other people within the organization so that they can also use them. You can go even further in this: the script you created can be called from a Power Automate Flow.<\/p>\n<p>This again opens a lot of perspectives for automation, for which no development is required.<\/p>\n<h6>Action Recoder:<\/h6>\n<p><img decoding=\"async\" class=\"alignnone wp-image-2169 size-full\" src=\"https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Action-recorder.png\" alt=\"Action Recoder\" width=\"357\" height=\"273\" srcset=\"https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Action-recorder.png 357w, https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Action-recorder-300x229.png 300w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><\/p>\n<h6>Code editor:<\/h6>\n<p><img decoding=\"async\" class=\"alignnone wp-image-2171 size-full\" src=\"https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Code-editor.png\" alt=\"Code editor\" width=\"1202\" height=\"658\" srcset=\"https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Code-editor.png 1202w, https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Code-editor-300x164.png 300w, https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Code-editor-1024x561.png 1024w, https:\/\/spikes.be\/wp-content\/uploads\/2020\/07\/Code-editor-768x420.png 768w\" sizes=\"(max-width: 1202px) 100vw, 1202px\" \/><\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/videoplayer\/embed\/RE4qdFF\" target=\"_blank\" rel=\"noopener noreferrer\">Office Scripts in Excel on the web<\/a><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e2febba elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e2febba\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b779290\" data-id=\"b779290\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d895a31 elementor-widget elementor-widget-author-box\" data-id=\"d895a31\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"author-box.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-author-box\">\n\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/rensoosterbos\/\" class=\"elementor-author-box__avatar\">\n\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/spikes.be\/wp-content\/uploads\/2019\/05\/Rens_Oosterbos.jpg\" alt=\"Picture of Rens Oosterbos\" loading=\"lazy\">\n\t\t\t\t<\/a>\n\t\t\t\n\t\t\t<div class=\"elementor-author-box__text\">\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.linkedin.com\/in\/rensoosterbos\/\">\n\t\t\t\t\t\t<h4 class=\"elementor-author-box__name\">\n\t\t\t\t\t\t\tRens Oosterbos\t\t\t\t\t\t<\/h4>\n\t\t\t\t\t<\/a>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-author-box__bio\">\n\t\t\t\t\t\t<p>Business Innovation Consultant<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>What is the Fluid Framework actually, what does it entail, what can it be used for? The Fluid Framework is an open-source collaboration technology for both Office and third-party applications. This collaboration technology is a collaboration platform with which updates to the content are implemented in almost real-time in the various applications that use the [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":2187,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[166],"tags":[94,261],"class_list":["post-2823","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-en","tag-teams","tag-office-365-en"],"acf":[],"_links":{"self":[{"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/posts\/2823","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/comments?post=2823"}],"version-history":[{"count":0,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/posts\/2823\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/media\/2187"}],"wp:attachment":[{"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/media?parent=2823"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/categories?post=2823"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/spikes.be\/en\/wp-json\/wp\/v2\/tags?post=2823"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}