python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - fill

Python Plotly: avoid fill for NaN values

Any idea on how to achieve that ? Current issue on chart: Where I would like to avoid extra fillings... Code used: i = 'col' pos = df[i] >= 0 above = np.where(pos, df[i], np.nan) b...
test-img

plonfat

python

charts

plotly

fill

Votes: 0

Answers: 0

XLSX XML cell formatting works in LibreOffice but not MS Excel

I modified data tables xlsx export to generate tables with my custom styles. Primarily for the background colors. Mine is a mess, but it works. It generates the xlsx file and in LibreOffice it looks e...
test-img

Moeren

excel

xml

cell

xlsx

fill

Votes: 0

Answers: 1

Latest Answer

It seems excel always overwrites the second with patternType="gray125". I just keep <fill> <patternFill patternType="gray125"> <fgColor rgb="FFffffff&quo...
test-img

Moeren

Copy data from cell above in specific cell below

I have a table with years above and i want to copy it to specific cells below: I want in example to copy years in (H1; I1) to (H78; I78) by choosing H78 and use Ctrl+V as shortcut , etc... i dont wan...
test-img

Link

excel

vba

copy

paste

fill

Votes: 0

Answers: 1

Latest Answer

I think you're playing with fire here but this should work for you ... Private rngSelectedRange As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Application.CutCopyMode = ...
test-img

Skin

incorrect fill when plot is in stepline slyle

//@version=5 indicator(title="Weeks_OC", shorttitle="Weeks_OC", overlay=true) w_close = request.security(syminfo.tickerid, "W", close, barmerge.gaps_off, barmerge.looka...
test-img

Nik

plot

pine-script

fill

pine-script-v5

Votes: 0

Answers: 1

Latest Answer

I think you have Extended hours enabled. Please switch it to Regular Trading Hours. I think this is what you're looking for: //@version=5 indicator(title="Weeks_OC", shorttitle="Weeks_O...
test-img

Bjorn Mistiaen

Posts

Questions

Blogs

Jobs