![]() Now yes, I could develop all of that in Java, but why would I want to when OpenOffice offers me most of that functionality already, and all I have to do is program in a bit of logic. They can then publish it to a webpage, stick the calculated stats in a card template for easy printing, dragging in an appropriate picture while they're at it. The idea is that an end-user can open up the spreadsheet on the units page, enter the basic characteristics of the creature they want to convert, and the sheet calculates that creature's equivalent Dungeon Command stats and Powers automatically. More than likely my problem lies in a misunderstanding of the API, but for the life of me I can't see what I'm doing wrong. Redim aTmp(1 to uBound(aRows()) +1,1 To uBound(aRows(0)) +1) OFA=createUnoService(".FunctionAccess")ĬallWorksheetFunction=oFA.callFunction(sFunc, aArgs) Will handle different data types laterĮxplodedVLookup = "Error " & Err & ": " & Error$ + " At line : " + Erl PFullValue = pFullValue & argDelim & CStr(pStepValue) ' For now just dumping everything into a string. PStepValue = CallWorksheetFunction("VLOOKUP", Array(aSearchData(i), aRangeData, argIndex, argSortOrder)) ' Again, Villeroy, from the same thread. Thanks for helping me figure that one out! ORangeCells = oRangeSheet.getCellRangeByName(argRange)ĭataArrayToPlainArray(aRangeData) 'Uses Villeroy's function from. OSearchCells = oSearchSheet.getCellRangeByName(argSearchString) ' The error seems to originate hereĪSearchData = oSearchCells.getDataArray()ĪSearchData = split(pSearchValue, argDelim) The total is returned.įunction ExplodedVLookup(argSearchString, argDelim, argRange, argIndex, argSortOrder)ĭim oSearchSheet as Object, oSearchCells as Object, oRangeSheet as Object, oRangeCells as Objectĭim pSearchValue as Variant, pStepValue as Variant, pFullValue as Variant ' * running total of the values found at Index, summing numerical values and For each term successfully searched, the function keeps a ' * Search Terms, and then searches the first column of Range for each of these ' * Exploded Vertical Search parses the SearchString into a series of distinct ' MsgBox ExplodedVLookup("creatures.I9", " ", "bonuses.$B$2:$P$4", 6, 0) ' All of these work fine. ' MsgBox ExplodedVLookup("creatures.I9", " ", "bonuses.B2:P4", 6, 0)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |