 that we're using to get to people's problems, just our data, how to use give or off as issues, as well as wider scale issues as to kind of longer term problems that maybe we can do something about. So, you know, a lot of the traffic on the mailing list is just how do I use my work process, or how do I use that spreadsheet, how do I fix this equation, kind of general stuff like that. So, a year plus of suggestions and please help people on general topics. So, we try to find out what people are doing, and kind of where they look first in the menus for those problems. So, if they couldn't do something, we invest them, you know, what way are you using it in previous after, or previous after, how do you use, and where do you look first, and then try basically to prove the solution that is best for them in the first place that they load, so that the next person that comes along just finds them immediately. Where we work is that we fix those and then to make experimental builds with all those fixes in them. And to make them available to people internally that want to use our internal experimental repository of new products. If that works out okay, we're closely enough tuned to the internal IT department, and they generally take the builds that we provide experimentally, and if they pass muster, they turn it into the copper standard build, which is whatever it gets to use. It doesn't terribly go wrong with our effects. And then it becomes IT's problem to maintain that version. Because we're currently not in the process of maintaining the experimental builds that we make available. It's up to the internal IT department to take on responsibility for managing that. So, kind of stuff will be done today. We have just a very generic stuff that's hardly even really worth mentioning, but just it is there and it is a large percentage of our time. It's just fixing ordinary bugs, ordinary crashes, ordinary problems. And then a lot of work difference I can tell is that people have done stuff on previous versions of the spreadsheet where equations worked generally by chance, something changed, and those valid equations no longer give the same results as they used to. So as we work the equations into what they should be in all along, try to figure out what they're doing. So that's not really kind of anything that we can kind of put back into the product, but it does take a lot of time. The general stuff how to use the suite, and then general bug fixing. So the more highlight ones I've had in the last couple of months were terrible scrolling performance on the red six. It's not so obvious in the more modern versions, but it's more obvious under the older, unaccelerated X that we had on the internal machines of a particular group designed right out of it. Some issues where the dates were out by four years and crashes were pasted into the outline view in price. All these kind of general problems, which aren't as an immediately obvious to us before we deploy them. So it's just general crashes with general problems. That takes a lot of time. But outside of those then, these are the kind of features that were requested from internal people and the complaints they have about it. So this is what people are coming from Excel, and they have a huge number of sheets where normally to navigate to the sheet, you click left, you click right inside of the hidden area there, but you have a large number of sheets. What they want to do is right click on that area, go up and down the menu that shows you all the sheets. That's a bit of a difficult feature, but it actually was one of our LibreOffices easy hacks. And we implemented this because it was a request from internally. So it was a finance department. That's Calc Finance Department. These are people that are using virtual machines to test the desktop. The virtual machines come in by default. So it's a low resolution, the same kind of resolution you get on notebooks. And when they try and traverse across the menu, the menu placement used to be that it would place it. Whatever would give you the largest of the menu on the screen. So position the menu to the right of where you are. So you're on the five menu. The five menu won't fit here, won't fit there. So it positions the whole thing on the right here. So if you're trying to traverse across the menu bar by clicking right, your cursor will go from file to page preview, and then you can't actually go to the next entry there. So we just reworked all the menus so that when they're placed, they were placed into above or below if they can't fit. And then they just scroll the menu scrolls if it doesn't fit in place. The problem is on my notebook I can't go left and right to traverse the menu where we have to find out that the resolution isn't sufficient to allow it to fit in. And so we need to do something similar for the smaller dropdowns that we have on the list boxes, like the file list box and onwards like that. A lot of cases we would still place the menu to the right inside when we shoot places above or below. Next one then was a far more significant feature. Comments and margins. We've made this one available for everybody in 4.3. It was a big internal complaint site right there. It turns out that our busy execs communicate to each other in comments in document margins. They print them out and they read them and they're in the air. So they're under airplanes and they like to read comments and hand them to other important busy execs in the control. This one here is not so obvious here, but that's the PDF output of the final feature. So the solution here is that you shrink down the entire page by about to 75% of its original size. That's small enough to bring the margins, but not actually on the printable sheet paper to bring them inside the printable area and then you center the whole thing and you end up with something that is still readable, although smaller in size and your comment nodes appear inside. That gives you the addition here in the print menu. When you go down to print comments you can select from all of the traditional locations and then you can get this new place and margins once. There's a couple of problems still with excessive use of comments. If you have comments that are extremely long then you end up with a scrolling comment thing in the user interface which is not to be seen printed. So for the moment what just happens is that you get a little truncated tick at the bottom to let you know that your comment is truncated. We could possibly hook up the truncated comment thing with the other abilities here so that the comments are shown in the margins and they get little asterisks at the bottom of them at number one and then we go and fall back to place the comments at the end of page and the next page with the remaining half. We haven't implemented that yet because I've noted the execs that are involved in this process so far have complained about long comments. They just weren't comments. So you don't get long comments until somebody needs it. What executives do like their comments? Farmers have comments. They like to change all the size of the font used in all of the comments maybe just to shrink them down so that they do fit in a single page and then print them out that way. And again in the past we have selected every individual comment one at a time. Now you can select all comments and do it once we go. We've also changed the fall size of the current font. It used to be based on a 10-point UI font which is typically something which isn't really suitable for printing in a version of the default normal style which is pretty much the same as what mics have worked with. So you've got a better improved compatibility there with mics as well as straight out. Next more kind of intriguing one is inside in Impress where we're getting complaints that it's hard to navigate in Impress because when they're hitting a slide the slide moves around and once the slide moves around you have to use the scroll bars to re-center it again. So while it is still unclear to me what exactly are the steps and I've tried to follow it up a little bit what exactly are the steps that people are doing to make their slides shift into strange locations it's definitely much easier to give them one click solution like you do getting other products to re-center that slide and to size it up to make it in space so we have one click it's 4.3 as well just on the left side of your zoom area there and also as well we built in some extra stuff that isn't obvious so that when you're on one slide and you're off-center and you move to the next slide are you changing the zoom are you doing any number of things like that and it automatically centers the slide anyway so people have come into some kind of confused state that pretty much anything they do to change zoom or to change slide or to do whatever will do what they probably want to happen as well along with the phone links so they can phone them and they'll get the right effect as well more on slides over on the left-hand side select slides for which ones you copy which ones you delete the classic one here is that when you place your mouse over a slide it gets colored like that it's colored like that either the slide is selected or not selected so if you selected slides one, two and three and put your mouse over slide two are you selected slides one and three and just happen to have your mouse over slide two you get exactly the same visual effect you don't know which one if it's too selected or not you can't tell again we change this over here so that if it's unselected you just get a very very subtle invisible on the overhead shading for an unselected slide with mouse over and versus a selected slide with mouse over they probably can see that one there but there is a visual distinction between the two different cases and you can see the tone of which one your mouse is over but that is a much more priority effect than the actual effect being selected so now it's obvious that your select is not selected and it's certainly if your mouse is over or not it's a very high priority that when it's actually being selected and the most recent one I just finished it off last week maybe time stamps in calc control plus full colon and semi colon in excel will give you a short will give you time and date stamps long ones or short ones a tradition inside of calc clicking those gives you full date including year give you full date and time turns out that what people want to do they come from a background where they type in notes into their spreadsheets and they're along the say on datex customer lab and they just type in control plus for that date customer reported issue trunk product ship's trunk and they just do that and we're being told that what people are doing is they're still using that shortcut that they've got the muscle memory from excel the typing shortcut and then manually going back using the extra part the time stamp part all of it instead and also there's a fix there that they could just type and continue that have to actually type type some text then go back to the time stamp then go after the text again and continue it's just straight forward enough now you just do what you just type in the excel shortcuts and the right thing happens is like it's built in all sorts of complicated extra dates onto it basically what you expect to have happens all the ones template detection not traditionally the new xdg templates directory they'll automatically be detected in the office and they'll appear inside in your templates along with the ones that come from the traditional in the office location down below .config you'll get your standard you'll get templates in the standard location it will appear as well let's try a video which is very brave yeah ok watch this for a car crash in press this is important of me did this one up first so the both involves the object area for auto layouts in kind of weird what you're trying to do here is go into master view and remove the bullets from the outline view there go back to her normal view and have no bullets anymore so you see you got bullets here so I'm trying to get rid of those bullets so initially she's trying to apply the styles over there through those bullets but you can't do that because this is a preview of the outline styles you can't apply another style to the outline styles you can only edit here to update the styles there or update those styles to change here try to delete the whole outline area but that doesn't make sense you can't delete that because it doesn't have any effect you can't delete outline 1 to 7 which can't be done still trying to remove the bullets still won't work that makes no sense ok so she removed the bullets over there and that you would think would work but that doesn't work because what that does is it removes the current paragraph that was selected from the bullet style the bullet style has remained bulleted but the preview has been removed from the bullet level the style remains bulleted it says character stuff she'll go back to the master slide and find that the bullet is still missing which makes no sense the bullet is missing in the master view but every time she goes back to normal there's a bullet see there's no bullet there how come there's still bullets in the main slide and again trying to apply title subtitling loads to an outline style it doesn't make any sense so that's not great that's not great so the point there is that master view really really confuses people the master view of that outline of those bullet and outline paragraphs is an interface debate about the actual outline styles on the other side so if outlines 1 to 7 or 1 to 6 you can't just delete that whole box because that doesn't make any sense because again it's a preview of those styles so what I've done the changes I've made that whole area becomes read only now you can't select it and delete it because that doesn't make sense you don't allow what's nonsense to happen there is one case where you can delete things but that doesn't make sense is that there are like 9 outline levels that you can display the number of outline levels you leave in that preview is the same number of outline levels that would be shown as the preview in the actual normal view so 9 9 depth levels is too many so normally we set it to about 6 but if you want to actually increase it or decrease it you have to go to the next line in depth view so now that it's read only what you do right click on the last paragraph in that preview mode and it'll allow you to show another outline level or hide the current level and you can hide back up to 1 level or show all the way down to level 9 right click there and the actual button that you did use that made the preview lose its button by removing it from the depth at which it shows bullets continues to do that in normal view but in the master view it is deliberately selected to go and find what list level we're looking at and update the actual style and alignment so it just works it just clicks on the button to remove bullets and bullets are removed from the underlying style so it'll just work for now that's what's done but it's not done that we kind of get free personal requests about that there are my radar the master slides are still an issue nobody understands the leadership master slides, styles and layouts and I guess not, I don't even fully understand the leader of the sense of house presumably somebody had a vision for how they're all supposed to work together but I'm not convinced so one issue is like how do you bundle layouts into document templates how do you have nice layouts that you now have on the writing side and transmit them to other people for them to use and how can you make that part of the master view so when you're designing things in master view you can design layouts at the same time but first it all just works we can definitely at least improve the relationship between in master view improved the relationship what you saw back there was where we have one master view slide that shows the outline levels and you saw a lot of messing around at the subtitle and title styles that's because you're only seeing one preview it should look more like this where you have one preview on the right hand side where all the outline styles are above where you have for the title but then you have some kind of a dependent slide which shows you where the subtitles are and additionally for the notes so that when in that example she clicked on notes the cursor would automatically let's say a subtitle the cursor would automatically jump down to the dependent side and you can see that you can't apply a note style to something else you're clicking on notes the outline level X and you're actually transmitting directly the view to the thing that you've clicked on so that you can't you get a better relationship better overview of the relationship between your styles on the right hand side and the previews of those styles on the left and that should give you a place where you can directly edit a subtitle slide subtitle style because there is no place at the moment you can only edit the outlines and the title and not the subtitle if you like this it would give you a solution for that problem not particularly impossible and also I think we should get notes on there as well notes are a problem inside the note view you can apply styles you can use the actual style navigator and you can go to notes you can add bullets to notes but no words will ever appear in notes if you do that there is a small one inside the press you can right click on the graphic and change the graphic select and do graphic to replace the current one that's selected you can't do that in writer there's some code pointers in there for how to do it again it's fairly straightforward 10 plates we have 10 plates inside the writer and we have master documents but we can't have master document 10 plates we have a kind of a scenario it's outlining to me but it doesn't make sense to have master document 10 plates it doesn't have master documents that you can store inside your template manager and when you edit them you get the exact same effect as you do with templates you get a new document with the same content as a template that it came from but that it's not you have to save it as a new document in that point not updates inside the navigator and writer again you can promote and promote a chapter but there's no particular ability to select multiple headings and promote and demote them all at the same time they shouldn't be particularly hard people are not coming from Microsoft offices much anymore we're getting a lot of people that are migrating from keynotes and pages so there's features in keynotes that people miss and one of them is guidelines so there's a screenshot of what happens when you have one box text and another box title as you move them around the screen is blank and then when they come in alignment with the center lines they come aligned little yellow alignment bars appear they also appear if you have moved your object to the center of the page again you get these temporary little alignment arrows we do have the position and size information that's down below in our bottom bar in keynotes and pretty much everything now immediate information is right up there beside the mouse displayed as you move around at your eye point not down below we have a lot of good stuff that we keep in these status bars that are just far too far away from where people are looking we should try to move them up out of there and right onto the screen near the mouse indicators for autofit that text box there is not in the font size that is reported the font size of the report is much larger font size but that text box it takes the shrunk in order to fit inside the various space if you are a user you click on that it will tell you that the font size is 23 or something and you say it's too small you try to make it bigger you make it font size 25 it's two states the same size because it's just auto shrunk buy more and so on when you're entirely frustrated you try to make it smaller in a certain point it's so small that it is below the auto shrink cutoff point and then you can't figure out what font size you need in order to make it bigger and it makes no sense because what you have to do is have to make the box larger or turn off autofit and there is no visual indicator in our product it sends you that if you go to keynotes at least they give you a small little X to indicate that it's an autofit that's not a particularly great solution either just setting the word autofit to check box on the selective box will be the user solution there there are a few final thoughts on what's different about what I thought things were and so Excel does still work even when they're coming from when it comes to spreadsheets they want things to work they want the same results they want the same shortcuts they're fairly okay in writer people understand how writer works they want extra bits from it they want improvements in it but writer is something that they understand for people who are not happy with it it's impressed they don't get how master slides work you get master slides they don't really get a powerpoint works either but where people are coming from when it comes to presentations it's less and less powerpoint you get a lot more people coming from keynotes and keynotes are kind of important it comes in looking for product comparisons so there is good stuff you can bring from keynotes like the obvious indicator their master view they don't have all the solutions either in that sense but they do have some better stuff when it comes to the drawing stuff the guidelines, the grids issues like that special effects are easier things like that so impressively it drives people really crazy I think that the easiest way is to continue working on master view along the suggested lines there add new indicators to the selected objects all the stuff we have in the bottom status they are trying to migrate that up on the selected object itself and really number one one is that graphics I wrote this presentation in a developing version in the hope that I can get my graphics to disappear out of the presentation and they didn't disappear out of the presentation but we are still getting reports that graphics are disappearing so we need to make sure we find out why they are disappearing don't use graphics and presentations anymore definitely I think that's actually it and 27 is a tie any questions? ok, thank you