 Hi, everyone. Thanks to come to this presentation. My name is Paulaj Zvargo, and I'm working for Allotropia. In this presentation, I would like to talk about some calc improvements in this year. I also want to introduce and show a little demo how accessibility sidebar has been improved in the last few months. So, let's get started. On this first slide, you can see a problem related to car comments. When we hide the column row or cell, the comment didn't disappear. Of course, this screenshot, the note should not disappear because there is no hidden row column or cell at all. This is the previous, how it looked like. And let's see the result. On the left side, you can see the result in an orderly office version where the comments didn't disappear when we filtered out the row. On the right side, you can see the result after sexing the issue and the comments are hidden. It's also working if you just hide the cell column or row or anything else. And the comments will also be hidden. Let's see the next one. On this slide, you can also see an improvement in the fix related to car comments. The goal was to show the author name and to create or modification date of the comment. It was quite complicated because during code review we decided to not change the visible comments. The reason is that the comment box often needs to be resized to fit the author and type metal. But permanently visible comments are really part of the document layout as they can be precisely resized and moved around. And we don't want to break the layout because the other alternative is to open the metadata to the comment content as a readable text like accept us, but this would only work only for new comments. The third option might be to have a dedicated sidebar view of comments and show the metadata there instead of in the document area. But that was a way out of the scope in this case of fix. So as you know we have two different status of the comments. So we only can show the author name and the creation or modification date of the comment in the temporary mode. In edit mode we cannot show that we only show the content of the comment. But if anyone has modified the comment or created a new comment or we import a document or ODS or OXM, it will show in temporary mode the original creator name and the date as well because these two format contains these datas. And also the export works as well. Let's see the next issue in this case. The cell validity didn't accept any formulas in the cell and we got an error message. So as you can see. So first of all we had to solve this problem. First of all we had to calculate the result from the formula, then we had to check that the result is valid for the cell and is acceptable after we set the validation for the cell. You can see on the left side it was wrong but on the right side you can see it's working now working with all kind of functions. In the example there is a today function and in the validation we do I don't know that it's seeable because it's very light but there is no error message there. Okay, the next fix was just a smaller issue in case of clock the hyperlink wasn't stand out well like in writer where the hyperlink has color and underline attribute as well but in clock the hyperlink no underline attribute only the color attribute. So I had to extend it and the result is maybe I guess it's seeable on the right side as there is an underline and of course it's not a direct format on the text but it's a already set attribute for the hyperlinks. Okay, the next one is related to VBA macros the export as fix format VBA function which as you can see on the left side of the screenshot didn't work earlier and we got an error message with basic runtime error the property or method not found this export as fix format function is used for the PDF export and now it works with worksheet and verbooks object as well the verbook VBA object you can export all the worksheets and the worksheet object you can choose which worksheet you want to export to PDF also there are attributes related to this VBA function like the type fine name, the quality of the PDF export or include document properties you can set that you want to export with that or without that also you can set that you want to ignore the print areas in the function attribute with true or false and also you can set that you want to open in the document after you exported or published into PDF which I think all the attributes except the ignore print areas is not working at the moment at all the others you can set and it's working also the import and export as well the next one on the left side you can see that the XL6 file with the SHA 384 encryption didn't work you can see on the left side in different versions there are different problems I mean the other versions the file was corrupted or opened with the encrypted data so you can just saw many stupid things there on the right side you can see how we can open this kind of encrypted file without any problems so in the password popup window popup you can type the password and it will open perfectly and also the import works as well ok, the next one it's related to writer for the smaller improvements in this case we have a hidden section between two paragraphs if we accidentally delete the hidden section between two other paragraphs in the file the hidden section will also be deleted without any notification maybe because we didn't remember that there was some kind of hidden section so in the earlier versions it was deleted but in the newer version we have a confirm dialog as you can see on the right side and you can choose you want to delete or not if you select that you don't want to delete the hidden section only the other selected paragraphs will be deleted but the hidden section will stay at the original place if you select yes, of course everything will be deleted also the hidden section the next one was UI improvements in this case the menus with sub menus was always enabled even if all the sub menus were enabled an example is for example the table menus in writer the table insert menu or the table delete menus menus are always active even if we cannot insert row or columns at all that's also true for a lot of other menu items in the library office the plan was if all the sub menus are disabled let's disable upper level menu as well also it was an accessibility program as well so accessibility tools should keep those menus which are not available so let's see how it looks like now I'm not sure but on the left side you can see in the order version there are three levels of the menus and all the sub menus are enabled but the upper levels are not disabled so in this context also all the second level should be disabled and because of that the top level menu should be also disabled on the right side you can see there is no option to select the first level but on the left side you can select all all these menus it's also important because I think we have a setting flag for that so we can hide all the disabled menus in the library office so if you set the true in the options all these menus will disappear as well this is another example and with the table insert and the table let's delete menus which are also unable now on the UI and also the sub menus as well let's move on to another part of this presentation and all through PI also works on the accessibility check sidebar and automatic accessibility as you can see in the meta a lot of issues have been closed so I will show a little demo or how it looks like now how it works, what we can complain about on the sidebar just some notes here the concept of accessible design and practice accessible development ensure both direct access and indirect access meaning compatibility with persons accessibility technology, for example computer screen readers and also the automatic accessibility check is also necessary for the PDF UI and PDF accessibility checkers as well just short notes and I will show it later that we have document level accessibility checks like document default language is not set or document title is not set on the document or we have missing alternative and description text checkers for objects and we have formatting related accessibility checkers hyperlink, simulated captions and a lot of others so in this conference of course there were other presentation about accessibility issue which you may could be important also to check that with I think microvicorn already talk in myai stejl as well and Semi will talk a bit later and he will also show some accessibility sidebar improvements so this is an example document you cannot see it now it's working I guess so this is an example document with a lot of accessibility issue as I mentioned there are document level accessibility issues there are two examples for that here for example the document default language is not set, we already have this kind of fixed button so if you click on the fixed button for example in case of document default language it will go to to these options directly to the options where you can set it and fix this issue so if I choose a language and click apply then this accessibility warning should disappear as you can see there is not anymore that's also true for the document title it's not set where you can set some kind of document title set that that warning will also disappear there were a lot of problems around updating these issues in the code base there were a bunch of fixes for updating properly because updating these warnings is related to the nodes inside the document so if something is modified in the content node we will also check the number of the accessibility issues on the sidebar you can also see some missing alternative and description text which is also important for the screen reading applications which will read for example if we have no name description of an image or any kind of object this screen reader application cannot read loudly so for that we have these kind of warnings for example pictures you can also fix these issues and directly the description windows will pop up and you can of course type something here and if you fix the issue it should also disappear and also the object will be selected in the document which is also useful and it's also true for any kind of shapes images and text frames as well because you can set then any kind of description or content so you can fix these issues but also if you type something into a description it will disappear after you fix the issue there are also some formatting problems in the document you can double click some kind of accessibility warnings and it will select the exact text in the document and you can remove the format in this case for example for the text formatting there is additional meaning which means we have direct format on the paragraphs and clear direct formatting it disappeared from the list so there are also two remaining warnings for this direct format in the document we also have another warnings for example avoid new lines to create space which is important because a lot of people put a lot of empty paragraphs into the document just to make some space extra space with that we can also jump into the document to clicking on the link on the accessibility sidebar we can just delete it also we have hyperlink related issues for example the hyperlink text is too short if you double click on that we also select the link in the document and we can delete that or the hyperlink text is the same as the link address we also have a warning for that so if you are clicking on that it will be selected and you can fix those issues also there are a lot of other accessibility warnings for example avoid footnotes in the document it is important because the screen readers cannot read these kind of things in the document us oh ok, tie so I just lost a lot of things here in the document and we have a lot of other warnings mostly there were problems as I mentioned around updating the issue or we didn't jump into a direct place into the document or just completely missed in the accessibility sidebar so I think nothing have lost just thanks to our customers to finding the work around accessibility issues and thanks for the questions 19 minutes or 30 minutes so if you have any questions do you have any questions thank you thank you