FreeOffice PlanMaker

FreeOffice PlanMaker for Windows, Mac and Linux

Create complex calculations, worksheets and charts with ease: With the powerful spreadsheet application FreeOffice PlanMaker, you can create simple timetables as conveniently as the complete financial planning of your company.

Thanks to numerous design features, FreeOffice PlanMaker lets you create presentation-quality worksheets: Not only can you insert pictures, drawings, text frames or impressive charts in 2D or 3D, but you can also choose from a large catalog of attractive cell styles that are compatible with Microsoft Excel 2019.

More than 430 calculation functions and a wide variety of analysis features help you get the most out of your data. As FreeOffice PlanMaker supports huge worksheets with up to 1 million rows and 16,384 columns, pivot tables are a useful tool for quickly summarizing and analyzing your data.

FreeOffice PlanMaker opens and saves all Microsoft Excel XLS and XLSX files seamlessly. You can also export your worksheets to PDF or print them exactly the way you want: tailored to fit on a specified number of pages, with a specific print range or with repeating headers.

Features

Files and printing

  • Worksheets can be losslessly exchanged between any version of PlanMaker on any operating system.
  • Open and save XLS and XLSX files from Microsoft Excel in an identical format to the original files, including password-protected files.
  • Open OpenDocument Calc in an identical format to the original files
  • Import and export assistant for text files and dBASE databases
  • Create PDF files directly in FreeOffice PlanMaker
  • PDFs with tags and bookmarks
  • Scale the printout so that it fits on a specified number of pages (five different scaling methods)
  • Print 2, 4, 8 or 16 pages on one sheet of paper (only in Windows)
  • Document preview directly in the file dialog

Extensive calculation capabilities

  • More than 430 calculation functions
  • Worksheets with 1 million rows and 16,384 columns
  • Calculation with complex numbers and array functions
  • Numbers can be formatted as currency units, with fixed decimal places and thousands separators, as percentages or fractions, as dates and times, etc.
  • Perpetual time format (20:00 + 5:00 is 25:00 and not 1:00) which also allows negative times
  • AutoSum, AutoProduct, etc.
  • AutoFill: intelligent filling of cell areas with values and rows of values
  • External references (calculations that access data in other files)

Editing worksheets

  • Freeze rows and columns
  • Syntax highlighting
  • AutoComplete for cells
  • Select and format multiple worksheets simultaneously
  • Sheet, workbook and document protection with encryption

Analyzing data

  • With pivot tables, you can display data in a targeted manner according to your individual specifications, summarize it, sort it into categories, compare and evaluate it.
  • Goal seeker
  • Create database ranges within worksheets
  • Data grouping (outline view)
  • Sort by up to 64 columns
  • AutoFilter and special filters
  • Database functions for totals, averages, variance, etc.

Creating attractive worksheets

  • Cell styles like in Microsoft Excel 2019
  • Conditional formatting like in Microsoft Excel 2019
  • Borders, shading and fill patterns
  • Rotate and merge cells
  • Center across columns
  • Headers and footers (split into left, center and right sections)
  • Colored tabs for worksheets
  • Set the size of the tabs in the worksheet register

Pictures and drawings

  • Comprehensive drawing and picture functions: Draw and design directly in the worksheet with Excel-compatible AutoShapes
  • Insert pictures in a range of file formats
  • Change brightness, contrast and gamma of pictures directly in FreeOffice PlanMaker
  • Fill drawings with colors, patterns, pictures and gradients
  • Contour wrap
  • Connector lines between objects
  • Large symbol library for flowcharts and organizational charts
  • TextArt feature for font effects

Presenting and visualizing data

  • Powerful Excel-compatible chart module for impressive charts
  • Insert more than 80 different types of charts, for example, bar charts, histograms and pie charts
  • Each chart element can be individually formatted with any fill pattern or color gradient.
  • Impressive effects on charts: soft shadows, beveled edges, transparencies, lighting sources, etc.
  • Charts can be rotated in 3D space.

Extras

  • Fully Unicode-enabled, including Arabic
  • FreeOffice PlanMaker for Windows is an OLE server and can insert its worksheets and charts into any other program.
  • You can zoom and scroll with your fingers on touchscreens.
  • Spell-check in 58 languages with Hunspell dictionaries.
  • Automatic hyphenation in 33 languages