Address translation helpers about hyperformula HOT 4 CLOSED

Ok, I think I get it now.

Basically sheet param is necessary to indicate where is the cell/sheet that requests the address so the returned address is either absolute or relative to that sheet. IMO this would be clearer with includeSheetName: boolean = false or absoluteSheetName: boolean = false.

Another question is how do we indicate that row or column should be absolute or relative?

from hyperformula.

Close, but not exactly. If we give engine to interpret C64, we don't know, whether this is in context of Sheet1 (the result would be: {sheet: 0, col: 2, row: 63}), or Sheet2 (the result would be: {sheet: 1, col: 2, row: 63}). So we need context, in which sheet we ask for that address. Of course, sheet is sometimes obvious -- when someone give us sheet explicit, like Sheet42!A1, but it's not always the case.

We can think of many different "formats" for addresses. But when we've worked on the engine, only two were really needed:

• totally absolute address (SimpleCellAddress type) -- this one has only numerical values, all always absolute.
• R0C0 format (CellAddress class). This one come up always with additional information, whether column/row is relative/absolute. The sheet is always absolute, because we didn't consider 3D references.

My suggestion is to wait, until we will really need some other formats than these two, because we can discuss many formats fora a long time, but that probably won't be productive :)

from hyperformula.

@wojciechczerniak Is there anything crucial left in this issue to be done in Dec19?

from hyperformula.

@bardek8 No. I think I understood it now correctly.

It would be helpful to extend the JSDoc to explain it better and override might not be the best name. I will ask if @scarletfog could take a look, having the context from @swistak35 should be easy to fill the gap if any.

from hyperformula.