g8 | ️ Go library for protecting your HTTP handlers | REST library

Make sure you open your file in binary mode.

You can do with inline js as :

So I think the programm is not waiting until the first function is finished

That's not what's happening. A non-async JavaScript function always runs to completion (unless the entire environment is terminated, like closing a web page).

The click event propagates ("bubbles") from child elements to their parent element to its parent element, etc. Since your pawns are child elements of the squares, after handling the click event on the pawn, the click event bubbles to the square and gets handled there.

There are a couple of things you'll need to do:

1. Prevent the event from bubbling by using event.stopPropagation(); on the event object in $$pawn_clicked

2. Have variables storing state information for your program so it knows whether it's expecting to get a click on a square. I think that you already have that in the $piece variable. So your click handler for squares should only do something when $piece is not the "no piece" value (looks like you're using undefined for that).

• Build your conditions:
  1. VAL1 is in include or VAL2 is less than 20
  2. Use .any() and .all() to broadcast your condition to the whole group
  3. Use | (or) operator to bring those two together
• Use groupby in conjunction with your conditions to get relevant groups
• Filter your dataframe with the selected groups from previous steps with .isin()

I'm not sure you need a loop.

This code will put the formulas in columns F, G etc. from row 8 down to the last row of data in column W.

I believe your goal and your current situation as follows.

• You want to retrieve the values from the cells "G7" and "G8" from 1st tab in the XLSX data converted from a PDF data.
  • You have already achieved this.
• You want to append the values to the columns "C" and "D" in the Spreadsheet every run of script.
  • For example, at 1st run, you want to put the retrieved values of "G7" and "G8" to the cells "C2" and "D2" of Spreadsheet. And, at 2nd run, you want to put the retrieved values of "G7" and "G8" to the cells "C3" and "D3" of Spreadsheet. You want to do this cycle.
• You have already been able to get and put values for Google Spreadsheet using Sheets API.

• In your script, the values retrieved from Spreadsheet are converted to the dataframe. I thought that in your situation, this might not be required.
• In this modification, I would like to propose the following flow.
  1. Retrieve the values from "G7" and "G8" from the XLSX data converted from PDF data.
  2. Retrieve the values from the columns "C" and "D" and retrieve the last row of the columns "C" and "D".
  3. Append the retrieved values to the columns "C" and "D" in Google Spreadsheet.

When above points are reflected to your script, it becomes as follows.

In this modified script, I modified below gc = gspread.authorize(credentials) in your script.

Your Fortran function func_and_constr calls many other subroutines g1(),g2(),...g67(). You need to have these subroutines, either as compiled code or the code for them.

The trick to charge all the dropdowns option was to add the following code in dash_table.DataTable() :

css=[{"selector": ".Select-menu-outer", "rule": "display: block !important"}],

My page still take a long time to charge but has all the labels inside my dropdowns !

Ok, thank you to @cactustictacs for his hints. He was right, the problem had something to do with the different API on the LG device. In all the emulated devices, I had API 30 (Android 11) and everything worked fine, whereas on the LG I have API 28 (Android Pie) and I overlooked that key difference. I created new emulated devices with API 28 and 29, and yes, I could reproduce the same issue on those devices as well.

Then, I could resolve the issue by simply observing a MutableLiveData variable from the main activity set to "true" every time the dialog is closed, in order to restore the full-screen view with the following code in the main activity: