"Overload" F9 (or shift+F9) in Excel spreadsheet with VBA function?

I wish this helpful for you http://blogs.msdn.com/vsofficedeveloper/pages/Excel-2007-Extension-Warning.aspx
That is a link basically describing that MS knows about the problem your describe and that it cannot be suppressed from within ASP.NET code. It must be suppressed/fixed on the client's registry.

To fix this issue And I just found a workaround. Instead of ctrl-shift-E, I tried ctrl-E, which is often a keyboard shortcut for center alignment. Instead of centering, it extends the array formula the way ctrl-shift-E used to.

help you fix your problem You may pass additional parameter to apply if you want. In this case you may pass the main df and your ubk handles/processes it as you want. I don't know exact purpose of your ubk, so I just modify ubk to accomplish what you describe for column test. It seems your logic is not efficient, but you may have your own reason to use it. So, it is up to you.
sample data:

In [301]: df
Out[301]:
   lowest_low   k_calc    d_cal
0        9.07  75.0000      NaN
1        9.07  79.7297      NaN
2        9.07  92.5675      NaN
3        9.07  66.2116  78.3772

def ubk (s, m_df):
    x = m_df['k_calc'].shift(1)[s.name]  
    if x <90 :
        return 1
    elif x >90:
        return 2

df['test'] = df.apply(ubk, axis=1, args=(df,))

Out[304]:
   lowest_low   k_calc    d_cal  test
0        9.07  75.0000      NaN   NaN
1        9.07  79.7297      NaN   1.0
2        9.07  92.5675      NaN   1.0
3        9.07  66.2116  78.3772   2.0

like below fixes the issue I am happy to update that I have achieved what I tried to achieve as follows:
Create a copy of the template spreadsheet, to serve solely as a design setting template. Copy the relevant template sheet from the design setting template Ss into the destination spreadsheet (while keeping it hidden). This is acomplished using copyTo of class Sheet. Copy format, conditional formatting and data validation from template sheet to destination sheet. This is acomplished using copyTo of class Range. Deleting the tempalte (hidden) sheet from the destination spreadsheet.

function restoreRangeSettings(e) {
// retrieves data validation, conditional formatting and formatting settings from template
  var editedSs = e.source;
  var editedRange = editedSs.getActiveRange();
  var editedSh = editedRange.getSheet().getName();

  var templateSs = SpreadsheetApp.openById('10zVclYTCEOEwskUID4vxSPxKR_tb3RaR76eG7TfxLUE');
  var templateSh = templateSs.getSheetByName(editedSh);
  var copiedSh = templateSh.copyTo(editedSs).hideSheet();
  var templateRange = editedSs.getSheetByName(copiedSh.getName()).getRange(editedRange.getA1Notation());

  templateRange.copyTo(editedRange, SpreadsheetApp.CopyPasteType.PASTE_FORMAT, false);
  templateRange.copyTo(editedRange, SpreadsheetApp.CopyPasteType.PASTE_CONDITIONAL_FORMATTING, false);
  templateRange.copyTo(editedRange, SpreadsheetApp.CopyPasteType.PASTE_DATA_VALIDATION, false);

  editedSs.deleteSheet(copiedSh);
}

around this issue Here are my Kotlin (Version 1.3.61) + Java(1.8.0_201) code that failed to compile: , From kotlin in action

setX(x: Int)

setX(x: Int)