I'd like to see a new formula that stitches together a region in excel into a variable string. For instance:
When stitched, it will produce "@Age=" & $B$7 & ",@Gender=" & $B$8 & ",@Weight=" & $B$9
An additional parameter could indicate if the stitching was for a cube cell address, Stored Procedure parameters, URL or JSON.1 vote
What if in a reflex report the CREFLEX formula created a named range for the resulting data and re-sized/defined it each calculation?
That would let you reference/slice the named range pretty effectively without breaking the formula or relying on offsets. Ie: =INDEX(returnedData,1,)
The function is already re-sizing the range by cell reference so it should be an easy implementation.
The Shift+F9 combination is already in use by a number of add-ins. A button (or custom-assignable key combination) would be helpful.2 votes
Similar to Excel's [F2] and [Shift]+[F3] formula edit functionality, I would like to be able to single-keystroke pop-up the Calumo Formulator for easy editing of Calumo formula's.2 votes
excel function that retrieve images or pdf from a DB . Then we can view images on the web when the excel file is published.
We can use it as a fax viewer.We use SSIS to store all the fax PDF into DB with a ref Name then can be viewed on web report. CALUMO.
Also can be used to store documentation, receipts and invoices.8 votes
- Don't see your idea?