EVE Online Excel Add-in enhancement request

EVE Technology and Research Center Player Features & Ideas
1

The new EVE Online Excel Add-In is awesome (if you get it working in your version of ms excell). It lacks one more feature which is to work on Spill range reference.

You can already use built-in excel functions on spill ranges returned by EVE add-in. Like

=TRANSPOSE(EVEONLINE.SEARCHREGION())

(let’s suppose it is entered in cell A1)

but you can’t reference that spill range further, like that

=EVEONLINE.MARKET_ORDERS_STREAMING(A1#.id;44992)

(let’s suppose it would be entered in cell B1 and number 44992 is id for PLEX)

but instead you must copy-paste formula

=EVEONLINE.MARKET_ORDERS_STREAMING(A1.id;44992)
=EVEONLINE.MARKET_ORDERS_STREAMING(B1.id;44992)
.
.
.
=EVEONLINE.MARKET_ORDERS_STREAMING(DG1.id;44992)

in all the cells along row 2

the same goes for rest of those awesome EVEONLINE.* functions

2

I’ll look into how CELL# references look when they enter the customsfunctions, otherwise it’s possible to enter an array of ids like blueprintexplosion does.

1 Like
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.