Create complex calculations, worksheets and charts with ease: With the powerful spreadsheet application FreeOffice PlanMaker, you create simple timetables just as conveniently as you do the complete financial planning of your company.
Thanks to numerous design features, FreeOffice PlanMaker lets you create presentation-quality worksheets: You can not only insert pictures, drawings, text frames or impressive charts in 2D and 3D, but also choose from a large catalog of attractive cell styles that are compatible with Microsoft Excel 2016.
More than 350 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 handy tool to summarize and analyze your data quickly.
FreeOffice PlanMaker opens and saves all Microsoft Excel 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.
Files and printing
- Worksheets can be exchanged between any version of PlanMaker on any operating system with no loss of fidelity.
- Open and save XLSX files from Microsoft Excel faithfully to the original, including password-protected files
- Open XLS files faithfully, including password-protected ones
- 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 straight from the file dialog
Comprehensive calculation capabilities
- More than 350 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 not 1:00 but 25: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)
- Freeze rows and columns
- Syntax highlighting
- AutoComplete for cells
- Select and format multiple worksheets simultaneously
- Sheet, workbook and document protection with encryption
- With pivot tables you can display data in a targeted way according to your individual specifications, summarize them, sort them into categories, compare and evaluate them.
- 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 2016
- Conditional formatting like in Microsoft Excel 2016
- Borders, shading and filling patterns
- Rotate and merge cells
- Center across columns
- Headers and footers (split into left, center and right sections)
- Colored tabs for worksheets
- Choose the size of the worksheet tabs
Graphics and drawings
- Comprehensive drawing and image functions: Draw and design directly in your document with Excel-compatible AutoShapes
- Insert images in a range of file formats
- Change brightness, contrast and gamma of images directly in FreeOffice PlanMaker
- Fill drawings with colors, patterns, images and gradients
- Contour wrap
- Connector lines between objects
- Large symbols library for flowcharts and org charts
- TextArt feature for type effects
Presenting and visualizing data
- Powerful Excel-compatible chart module for impressive charts
- Insert more than 80 different types of charts, e.g. bar charts, histograms and pie charts
- Each chart element can be individually formatted with any fill pattern or color gradient desired.
- Impressive effects for charts: soft shadows, beveled edges, transparency, light sources etc.
- Charts can be rotated in 3D space.
- Fully Unicode-enabled, including Arabic
- FreeOffice PlanMaker for Windows is an OLE server and can insert its worksheets and charts in 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