Yeah you are being a dick. Hope you will also have a little one one day and maybe then you will realise how absurd you having to correct their kids sounds like ;)

He's not a dick, the reality is that both parents and non-parents as friends do not understand that they have to actively give to a friendship. Not break-even, not take, give.

If you're not actively going out of your way for your friends then you're not a good friend. Sorry. I know life is hard right now and blah blah blah and we can do that for a while. But when it becomes an all the time thing, then you're not a good friend.

And having a kid is an all the time thing. So if you let that become an excuse for why you're not going out of your way for your friends, then you're going to lose all your friends. So, don't let that become an excuse.

Everyone expects a very convenient relationship. I come over, dump my kid on you and I just have to worry about me and my kid. Or, the inverse - you come over, your kid is nowhere to be found and I don't have to worry about anything.

Relationships don't work that way. I hold my goddamn coworkers to a higher standard of care. Stick your neck out for your friends. Be uncomfortable. Be tired. At least, sometimes. And just understand that will be repaid.

i have kids. I make damn sure they are behaving when visiting somewhere else.

So did McKinsey ;)

OMG

Small and efficient ICE engines are as proved a technology as it gets. If you end up buying a V6 engine now it is not because of how good or reliable the engine is, it is either nostalgia or status symbol. So, please don’t and be more mindful of your emissions.

Oh I soooo miss Fotolog, was a great concept

Me too! I was 16 when created my account there, man time flies!

As I consultant that works extensively in Excel, I understand your point. The lack of decent syntax highlighting, auto-indentation or “IDE mode” instead of the formula bar can be painful. Especially when working with models developed by others.

On the other hand, you can see it as a feature. It forces you to keep your formulas short, break them down in helper columns and overall make your logic cleaner. If you are writing a 4 line long formula, you are doing something wrong. Sytax highlighting would still surely help, but it is not a replacement for clean modelling.

Amateur user of Excel/Calc/Google sheets here. My worst is...

    =CONCATENATE(
        IF(A1<0;"-";"+");
        TEXT(INT(ABS(A1));"00") ;"d";   
        IF((ABS(A1) - INT(ABS(A1)) - INT( (ABS(A1) - INT(ABS(A1)))*60 )/60) * 3600 > 59.5;
            TEXT(INT((ABS(A1) - INT(ABS(A1)))*60)+1;"00");
            TEXT(INT((ABS(A1) - INT(ABS(A1)))*60);"00")
        );"m";
        IF((ABS(A1) - INT(ABS(A1)) - INT( (ABS(A1) - INT(ABS(A1)))*60 )/60) *   3600 > 59.5;
    TEXT(0;"00");
            TEXT(ROUND(    (ABS(A1)-INT(ABS(A1))-INT((ABS(A1)-  INT(ABS(A1)))*60)/60)*3600;0    );"00")
        );"s" 
    )

...which should take a value in cell A1 that is in the range [0,360) and return the value in angle notation (degrees, minutes and seconds). I especially wanted this function all in one cell to save loads of helper cells (the spreadsheet calculates the position of the moon, sun, planets and a physical ephemeris for each planet so a lot of angles to display).

It is a pain to apply, I use a text editor to search and replace the cell reference for each angle. I'd settle for the formula bar display of the formula not reformatting the line breaks.

In Excel you could use =LET(a; A1; ...) to define a variable 'a' local to the formula. You would have to change A1 in one place only.

I'm not sure this works with LibreOffice though. Probably not.

I feel you can do something with floor and trunc to get the remainder, then using round to get the sig figs correct. You can make it abs of it at the start, and then only add a negative at the start of the concat if it's negative.

I rapidly tried and I get something a bit shorter (about half the length), but my rounding ends up with imperfect precision and sometimes I get 10m60s rather than 11m0s due to it. Appropriate rounding at the appropriate points would fix that.

You could put that into a VBA formula, although it wouldn't be as fast unfortunately (as I learned when I tried simplifying excel formulae - which are _compiled_ whereas VBA I think is interpreted? - in any case, excel was like 50x faster for me).

I assume you have tried the '$' signs to see if they will help?

Thanks for reply. Yes, if it was just for Excel I'd make a user defined function that returned a text value. I wanted the formula to work the same on Libre/Open office and on Google sheets so I went for an actual spreadsheet formula. Actually, the ';' separator came from the LibreOffice version.

'$' signs for A1? I'd still need to search and replace for A1 each time I needed to convert an angle in a different cell but I take your point that I could move the output around more easily. Speed does not seem to be an issue (the rest of the spreadsheet has calls to trig functions by the score)

Not sure about the cross compatibility to Libre and Google, but in Excel at least, replace your cell references with INDIRECT() references. Then store the cell you want to calculate on in another cell…say A1 (literally just type C1 in A1). Then reference with INDIRECT(“&$A$1&”). Saves you the search and replace for A1. Also works great if you want to copy formulas across tons of columns and maintain the correct column header references as you can insert the INDIRECT reference into table notation.

If you prepend the column/row with a dollar, it is locked when you drag and extend.

e.g. $A1 locks the column, A$1 the row and $A$1 both

Can be pretty helpful if you put a constant somewhere.

Thanks for your reply. I am aware of the absolute cell reference notation and use it frequently when I have a set of constants (e.g. longitude, latitude, year, month, day, timezone &c) that are referenced in many formulas. However the situation in my post was the other way round sort of.

As a concrete example (just in case I've mis-understood the situation), I have the right ascension, declination and phase angle of Venus as decimal angles in cells G80, H80 and M80 and I want the output strings in cells F3, G3 and H3. I still need to search and replace the A1 cell reference in my original post for each of the formulas.

As the poster a couple levels above pointed out I could do this as a user defined function in VBA, but I wanted my daft spreadsheet to work on Libre/Open office and on Google sheets with little or no modification. Hence the chain of if statements and round() functions.

>I'd settle for the formula bar display of the formula not reformatting the line breaks.

I can't imagine how much time this one thing would have saved over my last 40 years of spreadsheeting.

Related: https://www.microsoft.com/en-us/garage/blog/2022/03/a-new-wa...

Wow that’s actually kind of cool.

In the old Excel with only cell grid references I would agree. However in "new Excel" with LET expressions and LAMBDA it is now possible to write legible and self-documenting code where the lack of decent editing support is becoming a problem.

Wish I could +1 this 100x. Break into small clean chunks that are easy to follow.

Trilium Notes might be what you are looking for. Very very pleasant

https://github.com/zadam/trilium

I really like Thunderbird and I use it as my primary personal email client. Just, where can I pay to speed up the development of this feature?

https://bugzilla.mozilla.org/show_bug.cgi?id=213945

I find a proper 3 pane view to be essential in 2021

I don't think they have a way for users to fund individual features, but you can help feature development in general by donating: https://give.thunderbird.net

Since the most recent comments indicate that they have it on the roadmap, I think that would also help the specific feature you care about.

Dumb question, but could you find an open source contributor who knows the codebase and commission them to implement it?

I've been looking for something like this for numerous projects. If I can't write the code myself, I'd love to pay someone who can, but I don't know where to look.

I completely agree. This is what I check every time there’s news about Thunderbird before I consider switching.

What are you using currently? I am limping along with Thunderbird myself but really miss three-pane view.

That already exists in thunderbird, what do you mean?

There is an extension for it -> https://addons.thunderbird.net/en-US/thunderbird/addon/gmail...

Not super great visually, but works ok

Cheap green electricity at less than 50 $/MWh should not be a problem, most PPAs are already getting signed at costs substantially lower than that.

Absorbing large amounts of CO2 happens every second since 2-3 centuries at this point, and is the main driver of ocean acidification and subsequent coral bleaching, loss of wildlife, etc. If the mentioned process could "recycle" the CO2 needed for lime production, then it could be a big win for a very hard to decarbonize sector.

What is still to be checked is how more expensive this lime will be, and how it will stack up compared with traditional limestone+carbon tax

Price can be justified, if the government puts carbon tax on cement companies who dump large quantities of CO2 in the atmosphere.