#2199 closed Bug

_ExcelSheetAddNew() abends if specified sheet already exists — at Version 4

Reported by: Spiff59 Owned by:
Milestone: 3.3.9.5 Component: Standard UDFs
Version: 3.3.8.1 Severity: None
Keywords: Cc:

Description (last modified by water)

As the Excel UDF is being brushed up this seems to be the right moment to reopen and solve this ticket.

Change History (4)

comment:1 by anonymous, on May 14, 2012 at 6:14:56 PM

I suppose I could have made the @error = 2 test a single-line If/Then statement, if anyone cares...

comment:2 by trancexx, on May 19, 2012 at 2:23:32 PM

Resolution: Rejected
Status: newclosed

That function doesn't follow its specification regarding return values.
If you want to submit some code then either do it correctly or don't do it at all. I understand the desire to be useful but please don't do it by adding new bugs.

I'll close this as "Rejected", and I'm hoping you will report it again, only correctly next time. By correctly I mean with explanation of the bug, reproducer (where is it now?), and suggestions if you have any.

comment:3 by anonymous, on May 25, 2012 at 6:06:20 PM

Oh, the SetError() returns... shame on me.
Leaving it as rejected works for me.

comment:4 by water, on Sep 30, 2012 at 1:05:23 PM

Component: AutoItStandard UDFs
Description: modified (diff)
Resolution: Rejected
Status: closedreopened
Note: See TracTickets for help on using tickets.