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: 2961
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 70 times

sven-l
SoftMaker Team
SoftMaker Team
Posts: 7781
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) Downloaded 49 times

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

Re: Table lookup function returns #N/A

Post by sven-l » Wed Jan 24, 2018 5:20 pm

Please try again with the next service pack (should be available via auto update within the next few days).
Sven Leßmann
SoftMaker Software GmbH

Post Reply

Return to “PlanMaker 2018 for Windows”