Pull to refresh
16K+

Development for Office 365 *

Developing for Office 365 by Microsoft

4,38
Rating
Show first
Rating limit
Level of difficulty

Excel Life Hacks That 'Experts' Don't Know

Level of difficultyEasy
Reading time5 min
Reach and readers405

I watched my experienced finance colleague struggle with Excel for a whole hour. He's an Excel guru, has been working with it for 20 years. But when I saw how he was typing formulas, I couldn't help but show him a couple of simple tricks that blew his mind.

It was a problem of ignorance—ignorance of features that have been in Excel for years, saving hours of work, but which no one ever talks about.

That's why I'm writing this article, to gather the best life hacks and save precious seconds of your life.

Read more

Tutorial: how to port a project from Interop Word API to Open XML SDK

Reading time14 min
Reach and readers3.3K

With the .NET5 release further development of some projects was questionable due to the complexity of porting. One can abandon small outdated libraries or find a replacement. But it's hard to throw away Microsoft.Office.Interop.Word.dll. Microsoft doesn't plan to add compatibility with .NET Core/5+, so in this article we focus on creating Word files with Open XML SDK.

Read more

Analyzing the Code Quality of Microsoft's Open XML SDK

Reading time10 min
Reach and readers1.1K
image1.png

My first encounter with Open XML SDK took place when I was looking for a library that I could use to create some accounting documents in Word. After more than 7 years of working with Word API, I wanted to try something new and easier-to-use. That's how I learned that Microsoft offered an alternative solution. As tradition has it, before our team adopts any program or library, we check them with the PVS-Studio analyzer.
Read more →

Business processes. BPMN model extraction from the document. Part 1

Reading time5 min
Reach and readers4K
The modern projects on the optimization and the automation of many business processes, assume, as a rule, that the first step will be the analysis of the large amount of the client’s documents. The purpose of it is the modelling the business processes “as-is” in a very tight schedule. The list of the analyzed documents includes normative legal acts, industry standards, SCRUM user stories, regulations, technical specifications and other corporate documents.

The analyst for the project faces a rather time-consuming task which is at the same time a routine one as well. It doesn’t have many means of automation at present. According to the analysis of modern means of business process modelling, even such well-known applications on the market as Enterprise Architect, ARIS, Bizagi Modeler do not have any support mechanisms for business process model building in their text description.

This article is focused on the BPMN model extraction from the document.
Read more →