Skip to main content

SoftMaker's PlanMaker: cannot handle linked workbooks with SUMIF and Google Drive reckons the files are ZIP files.

I have tested PlanMaker with my now-standard test suite of two linked workbooks.

PlanMaker looks and feels highly compatible with Excel.  It has comparable menu structures, a choice of Excel 2003-like or Excel 2007-like interfaces.  It feels tight and secure, i.e. no risk of data being lost.

So it should have been an ideal candidate to solve the problems unsolved by LibreOffice and OpenOffice.

Sadly, no.  It seems that PlanMaker's deployment of XLSX does not extend to linked workbooks in functions SUMIF and SUMIFS.  PlanMaker thus cannot pass this most basic of hygiene factors.

Naturally, I put in a comment in PlanMaker's forum for PlanMaker Freeware in Sep2018 and received no useful replies.

And now I receive spam from PlanMaker.

One other thing that PlanMaker annoyingly does.  When it saves XLSX, it does something that makes Google Drive think it is a ZIP file.  Google Drive preview thus cannot open the file for preview ("Oops!  Something's gone wrong!  You can download the file instead...").  Given that PlanMaker doesn't intend to take ownership of the SUMIF issue, I decided there was no point in telling them about another elementary mistake that smells an awful lot like non-compliance with Microsoft's XLSX standards.

Comments

Post a Comment

Popular posts from this blog

Scanning & OCRring to PDF: Simple Scan, gimagereader and gscan2pdf v NAPS2 for Windows

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to scanning paper documents to PDF and digitising the scanned text via optical character recognition. Environment & required functionality The scan-and-OCR function needs to run on the following machines: The Linux Mint Xfce 18.3 laptop " Gandalf "; A Linux Mint Xfce 18.3 virtual machine " Gimli "; The Windows 10 laptop " Legolas ". In any modern office - whether at home or at work - some transactional documents and documents from public authorities still arrive by snail-mail. This requires the ability to scan all documents, optionally with the digitisation of scanned text (typically via optical character recognition). The hardware is an old HP OfficeJet Pro 276dw, connected to the LAN instead of directly to a workstation. Alternatives There are two strategies: To use the software pr...
Post a Comment
Read more

Adjusting screen brightness

The machine on which Linux Mint is installed an old Acer Aspire 5732Z (" Gandalf ") It has buttons to adjust the brightness of the screen's backlight.  When the user uses these buttons, Linux Mint correctly presented a fading-popup box (a slider bar) to denote relative brightness.  But Linux Mint did not actually adjust the brightness of the screen. It seems to be a known issue in the Linux Mint forums  and solved in multiple  stages by the Easy Tips Project . I followed the instructions on Easy Tips section 5.2  in Gandalf's admin account, then re-booted, then logged in using the user account, and the brightness adjustment function worked correctly. Easy Tips asks the user to discover the relevant property of the machine, then creates a file that contains a script of parameters that other programs in Linux Mint understand. This method worked for Gandalf, because Gandalf has an integrated Intel chipset. Useful commands at the Terminal ALT+T (or th...
Post a Comment
Read more

Keepass and KeepassX

The project is to build a Linux Mint machine to have the identical functionality and ergonomics as the existing Windows 10 machine. This stage relates to password manager, Keepass. Environment & required functionality A number of encrypted password vaults synchronise between three machines: The Linux Mint Xfce laptop " Gandalf "; The Windows 10 laptop " Legolas "; Another Windows 10 machine, name withheld to protect the guilty. The synchronisation agent is Google Drive in Windows 10, and grive2 in Linux Mint. Alternatives My original decision to use Keepass was in 2016 and was based on: Keepass is open-source; Keepass is locally stored, not stored in the cloud; Keepass does not automatically plug into the browser (a plugin permits this if ever necessary); higher security standards at the office, worth deploying at home; portability of the password vault via Google Drive, encrypted such that Google would not be able to slurp data from an o...
Post a Comment
Read more