public void testCDate() throws ParseException { Date date = new Date(); assertEquals(date, Vba.cDate(date)); assertNull(Vba.cDate(null)); // CInt rounds to the nearest even number try { assertEquals(DateFormat.getDateInstance().parse("Jan 12, 1952"), Vba.cDate("Jan 12, 1952")); assertEquals( DateFormat.getDateInstance().parse("October 19, 1962"), Vba.cDate("October 19, 1962")); assertEquals(DateFormat.getTimeInstance().parse("4:35:47 PM"), Vba.cDate("4:35:47 PM")); assertEquals( DateFormat.getDateTimeInstance().parse("October 19, 1962 4:35:47 PM"), Vba.cDate("October 19, 1962 4:35:47 PM")); } catch (ParseException e) { e.printStackTrace(); fail(); } try { Vba.cDate("Jan, 1952"); fail(); } catch (InvalidArgumentException e) { assertTrue(e.getMessage().indexOf("Jan, 1952") >= 0); } }
public void testInStrRev() { assertEquals(32, Vba.inStrRev("the quick brown fox jumps over the lazy dog", "the")); assertEquals(1, Vba.inStrRev("the quick brown fox jumps over the lazy dog", "the", 16)); try { Vba.inStrRev("the quick brown fox jumps over the lazy dog", "the", 0); fail(); } catch (InvalidArgumentException e) { assertTrue(e.getMessage().indexOf("-1 or a location") >= 0); } }
public void testInStr() { assertEquals(1, Vba.inStr("the quick brown fox jumps over the lazy dog", "the")); assertEquals(32, Vba.inStr(16, "the quick brown fox jumps over the lazy dog", "the")); assertEquals(0, Vba.inStr(16, "the quick brown fox jumps over the lazy dog", "cat")); assertEquals(0, Vba.inStr(1, "the quick brown fox jumps over the lazy dog", "cat")); assertEquals(0, Vba.inStr(1, "", "cat")); assertEquals(0, Vba.inStr(100, "short string", "str")); try { Vba.inStr(0, "the quick brown fox jumps over the lazy dog", "the"); fail(); } catch (InvalidArgumentException e) { assertTrue(e.getMessage().indexOf("-1 or a location") >= 0); } }