Table lookup function returns #N/A

Post your questions, bug reports and suggestions here for PlanMaker 2018 for Windows.

Moderator: SoftMaker Team

Post Reply
allenschmid
Posts: 4
Joined: Sat Jul 08, 2017 5:17 pm

Table lookup function returns #N/A

Post by allenschmid » Wed Jan 03, 2018 7:49 pm

I posted this problem for Planmaker 2016. Planmaker2018 appeared to have corrected it but the bug has returned. Sometimes it works and returns the table value, sometimes it returns #N/A. I was unable to get it to work today and had to use OpenOffice. Please correct this. I regret buying this since OpenOffice is free and works better.

martin-k
SoftMaker Team
SoftMaker Team
Posts: 2871
Joined: Fri Nov 21, 2003 4:57 pm
Location: Nürnberg, Germany
Contact:

Re: Table lookup function returns #N/A

Post by martin-k » Wed Jan 03, 2018 8:02 pm

Please provide a sample document that demonstrates the issue. We can then investigate if there is a bug in the software or a user error or a wrong setting somewhere.
Martin Kotulla
SoftMaker Software GmbH

allenschmid
Posts: 4
Joined: Sat Jul 08, 2017 5:17 pm

Re: Table lookup function returns #N/A

Post by allenschmid » Fri Jan 12, 2018 6:34 pm

I'm attaching a sample document. If it opens and is correct, close and reopen. It seems to be random.
payroll18.pmd
(52.5 KiB) Downloaded 5 times

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7367
Joined: Wed Apr 09, 2008 8:26 am
Location: Nuremberg
Contact:

Re: Table lookup function returns #N/A

Post by sven-l » Mon Jan 15, 2018 3:58 pm

I opened your sample file with several revisions of PlanMaker and used the 32bit and the 64bit versions. I was not able to see the bug. Is there a way to reliable reproduce that issue?
Sven Leßmann
SoftMaker Software GmbH

allenschmid
Posts: 4
Joined: Sat Jul 08, 2017 5:17 pm

Re: Table lookup function returns #N/A

Post by allenschmid » Thu Jan 18, 2018 3:49 am

There is no reliable way to make the bug show up. Seems to be about 50/50. I've attached the file saved in xl format. The about information is

PlanMaker Professional 2018 (920.1214) 64 bit.
Attachments
payroll18.xls
(28.5 KiB) Not downloaded yet

Post Reply

Return to “PlanMaker 2018 for Windows”