SoftMaker logo

What's new in SoftMaker Office 2018? – Part 3

Wednesday, 17 January 2018 08:00

Dear SoftMaker customers,

In the third part of our series we are talking about PlanMaker 2018, our powerful spreadsheet application. In particular, we will focus on a feature that at first glance doesn’t seem too new—“tables.” You’re probably wondering what’s so special about tables in a spreadsheet. This and much more can be found in the following article.

Enjoy!

Part 3: PlanMaker

A completely new world: tables (in tables)

First of all, the rather unfortunate term “tables” for the feature described below was not invented by us, but by the manufacturer of another well-known spreadsheet. To avoid creating even more confusion, we have decided to adopt the term for PlanMaker.

What’s this about? In simple terms, these tables are areas within worksheets which can be formatted with a single click, to which you can add data dynamically, and which can be referenced using a special syntax. How this works and how you can benefit from it is explained below.

Defining an area as a table

Defining an area as a table is quite simple. To do this, you only have to select one of the cells that lie within the range you want to convert into a table and then click Insert | Table. In the classic menus, this command can be found under Worksheet > New Table.

PlanMaker then uses the following dialog box to determine which area should be defined as a table:

In the screenshot above, look at the table behind the dialog box: Although only a single cell was selected, PlanMaker automatically recognized the source area for the table and suggested it. You can simply accept the suggestion or correct it first.

If you are satisfied with the selected area, confirm by clicking “Insert.” You’ll then see by the appearance of the area that it has now been formatted as a table:

Now, what happened? In addition to the automatic formatting with a table style—which you can recognize by the blue and white banded rows in the figure above—this area now offers the following options:

Automatic AutoFilter: The first line of the newly created table now contains an AutoFilter. This works in the same way as an “ordinary” AutoFilter in the worksheet, but filters only those values that are inside the table. It does not affect the cells below the table. As an added bonus, you are no longer limited to one AutoFilter per worksheet, since every table now has one of its own.

Dynamic referencing: The contents of tables can be referenced using a special syntax that makes it much easier to add data dynamically.

For example: Let’s say you want to calculate the average of the column “2016” in the table shown above. You can easily do this by entering “=AVERAGE(Table1[2016])” in any cell.

At this point you might wonder what advantage this syntax has over the entry “=AVERAGE(D2: D11),” which would give you the same result. This is where the dynamics mentioned above come into play. If additional values are added to the table, they are automatically included in the calculation:

In this way, you can be sure that the average of the entire column “2016” of the table is always calculated, regardless of how many cells the column contains.

How to add new values to a table? That's quite simple, too – you have three different options:

  • You can either select the bottom right cell of the table and hit the Tab key,
  • or you can enlarge the table area by dragging the little triangle on the bottom right corner of the table,
  • or you just enter a value in a cell located directly to the right or below the table.

If you prefer working with dialogs, you can also extend the table via Table | Range (with classic menus: Worksheet > Table > Table Range).

Dynamic cell references are also extremely useful for tables that act as a source for pivot tables. If new values are added to the source table, they are also included in the pivot table after selecting “Update pivot tables.”

The new syntax for addressing table contents offers you numerous other options, such as addressing several columns of a table, addressing certain rows, and so on. However, listing all these possibilities here would go beyond the scope of this article. Those interested can find a detailed description in the “Tables in tables” section of our PlanMaker manual.

Special formatting options: As you’ve already seen, a table style was automatically applied to the area marked as a table. But this is not the only style you can apply to your table. Numerous other styles are available in the context-sensitive ribbon “Table.” To activate the corresponding ribbon tab, select any cell of your table; then the catalog of further table templates appears under Table | Table styles:

If you are using the classic user interface, you can find this template catalog under Worksheet > Table > Table settings in the “Style” tab.

As you see in the screenshot above, the tables offer you some other formatting options besides the templates, such as highlighting the first or last column or the automatic variegated “bands” of the rows or columns.

The options Header row and Total row represent special features: besides formatting options, both elements also offer special technical features:

The header row provides the controls for the AutoFilters mentioned above. You can filter and sort the contents of the table using the little arrows on the right of each cell:

The total row contains control elements in each cell as well. However, these are used to calculate key figures from the content above. For example, the average of the data above can be calculated in the total row with a single click:

Incidentally, you can also change the contents and formatting of tables using conventional methods. For example, if you want to highlight a cell, you can easily change its font color. You can also use the usual formula syntax within a table.

New cell styles

You might know how to work with cell styles from older versions of PlanMaker. Thanks to numerous new styles that you can apply from an attractive catalog, this is easier than ever before—and you'll always be compatible with Microsoft Excel 2016. You’ll find the catalog under Home | Cell styles:

When using the classic interface with menus and toolbars, you’ll find these styles in a classic drop-down menu on the Format toolbar.

Set the size of the tabs in the worksheet tab

In response to many requests from customers, we have added a handy little feature that makes working with multiple worksheets more convenient: the size of the tabs in the worksheet register can now be set by the user. If the tabs are too small for you, you can enlarge them in the settings in the “View” tab:

The worksheet tabs then appear in the specified size:

Font sizes between 4 and 48 are permitted.

We hope to have provided you with a sneak peek at some of the most important new features of PlanMaker 2018.

Thank you for your comments on our last blog post. Please feel free to share your impressions and experiences with us once again.

Have fun trying out the new SoftMaker Office!

The free 30-day trial version is available here.

 

21 comments

  • SoftMaker posted by SoftMaker
    Friday, 27 April 2018 12:23

    Igor: PlanMaker isn't capable of executing Excel macros embedded in XLSM files. However, you can use our own scripting language BasicMaker to automate PlanMaker. It offers a variety of VBA-like macros. To find out more, you might want to check the BasicMaker manual: http://www.softmaker.net/down/bm2018manual_en.pdf

  • SoftMaker posted by SoftMaker
    Friday, 27 April 2018 11:14

    inlabe@orava.sk: As a non-commercial user, you and the members of your family may use one license on up to five computers at the same time, as long as these computers belong to the same household.

    For details regarding the commercial use, please go to http://www.softmaker.com/en/softmaker-office-windows and scroll to the section "Scope of license". Here you will find a detailed description of our licensing terms.

  • inlabe@orava.sk posted by inlabe@orava.sk
    Friday, 27 April 2018 09:07

    How much instalation are you offering?

  • Igor posted by Igor
    Thursday, 26 April 2018 07:52

    please tell me if Planmaker understands macros from Microsoft Excel.

  • SoftMaker posted by SoftMaker
    Tuesday, 23 January 2018 08:29

    Jerry Zhang: You can control the menus of the classic user interface with keyboard accelerators. The ribbon user interface doesn't support keyboard accelerators yet. However, you can of course use the "typical" shortcuts like Ctrl+C for copying and similar or define custom shortcuts—also when working with the ribbon user interface. Keyboard accelerators for the ribbon interface are on our to-do list for future versions though.

  • SoftMaker posted by SoftMaker
    Monday, 22 January 2018 16:21

    olstor@gmail.com: A Norwegian translation is on our wishlist for future versions. However, please note that we cannnot provide you with a timeframe yet.

  • SoftMaker posted by SoftMaker
    Monday, 22 January 2018 10:57

    Folke Stenman: Thanks for your comment. An enhanced goal seeker is already on our wishlist for future versions of PlanMaker. However, please note that we can't provide you with a timeframe for that yet.

  • SoftMaker posted by SoftMaker
    Monday, 22 January 2018 10:28

    Mike Day: By default, tables get the name "Table[x]" with "[x]" replaced with a serial number, e.g. "Table1". With this name, you can adress them using the syntax mentioned in the article above. To rename a table, please invoke "Table | Properties" and go to the tab "Properties". When working with the classic interface, you can find these options under "Worksheet > Table > Table settings".

  • SoftMaker posted by SoftMaker
    Monday, 22 January 2018 08:34

    Dan Shelby: Thanks for your comment. Of course, inserting rows by pressing Ctrl and "+" is possible in PlanMaker, too.

  • ANTON posted by ANTON
    Saturday, 20 January 2018 09:56

    Congratulations on the new version of the SOFTMAKER OFFICE,
    I would like to ask if PLAN MAKER DEFIRE can read Visual Studio or not?

  • Jerry Zhang posted by Jerry Zhang
    Saturday, 20 January 2018 07:39

    Does planmaker 2018 for Linux have keyboard shortcut for menu like in excel? The keyboard shortcut is important as it improves the speed and workflow efficiency.

  • olstor@gmail.com posted by olstor@gmail.com
    Friday, 19 January 2018 23:50

    when do Office came i Norwegian? Are we so important as country?

  • Jim posted by Jim
    Friday, 19 January 2018 22:47

    Still need to include a subtotal wizard similar to open office.

  • Folke Stenman posted by Folke Stenman
    Friday, 19 January 2018 21:23

    Are you going to include an optimization module anytime soon? That would be tremendous!

  • Chris Sleightholme posted by Chris Sleightholme
    Friday, 19 January 2018 20:22

    Wonderful feature, very well explained.
    Thank you.

  • aroetting@yahoo.com posted by aroetting@yahoo.com
    Friday, 19 January 2018 20:06

    Great value.

  • Mike Day posted by Mike Day
    Friday, 19 January 2018 19:47

    I can see no mention of naming the table. If that feature is not supported how do you reference a cell within the table from elsewhere in the spreadsheet?

  • Eva Gustafsson posted by Eva Gustafsson
    Friday, 19 January 2018 18:21

    Wow, imagine I only this week bought a quite expensive book in my native language (Swedish) to get a better knowledge about the other well known software. The main reason I bought it was to learn just this table thing. But I did not get much help from the book. Your explanation is much clearer. Thanks!

  • Samuel S. Howard posted by Samuel S. Howard
    Friday, 19 January 2018 18:04

    I think it will be a gigantic seller. I need to upgrade to "Softmaker 2018." I have 2016. But, with these additions, I know its time . If you have a "Trial Period" as you have in the past, I like to try.

  • R Townley posted by R Townley
    Friday, 19 January 2018 17:03

    Already upgraded to 2018 but haven't explored new features yet. Articles like this are very helpful. As Oliver Twist said, "Please sir, some more...."

  • Dan Shelby posted by Dan Shelby
    Friday, 19 January 2018 16:57

    If PlanMaker is 'always going to be compatible with Excel' than why is it necessary in PlanMaker to click on 'insert and row' to add a row between lines where in Excel all you have to do is press 'ctrl and +'?

    the words below are' I'm not a robot'

Leave a comment