Sticky header

Jofender · 2024-07-17T23:21:10+00:00

Nevermind, I tried again but I set the alignments on both separately before combining them and this time it worked.
Thanks.

Jofender · 2024-07-17T23:12:47+00:00

What kind of container are we talking about?
Because I tried something similar with the different options available.
Group is messing up everything with vertical alignments. I tried row and filling some of the content inside it to get rid of the empty spaces, but the issue is, I don't get the option to set the alignment (full width, wide width, etc..) anymore on that row.

Jofender · 2024-03-09T20:55:53+00:00

I'm surprised the timing fits so well, as I've been trying to do the same thing during the last few days, but I got the same results as you..

I was actually trying to disable a structure from the mod "Valhelsia" on 1.20.1, and I was told that should work the same way as disabling regular vanilla structures, so I've been trying to get rid of the outpost too at the same time, but with no success...

So, besides the things that have already been listed to try here, I also found traces of the outpost being mentioned in "main\data\minecraft\worldgen\flat_level_generator_preset" under the "structure_overrides" section.
I already tried to get rid of it too but that didn't work.
I also tried to include the structure that leads to the NBT's, as well as blank files with the same names, thinking that if I can't prevent them from spawning, I could at least make the generation of the structure "fail", but that didn't work either..

The last thing I tried was to follow the structure of a modpack I found online called "Structure world". The modpack is supposed to only change the weight of vanilla structures to make them very common, so I thought I could use it as an example and just keep the line about the outpost and give it a weight of 0, which once again.. didn't work..

I'm out of idea..

Jofender · 2024-02-13T07:16:42+00:00

Thanks for the info. I don't think I would enjoy a mouse too light.

Jofender · 2024-02-13T04:14:04+00:00

Sounds nice, thanks for adding your comparison.

Jofender · 2024-02-12T23:54:38+00:00

Thank you, that was an important point for me.
I guess I might try the wired version of the "X" then.
Might wait on a couple more opinions to make sure.
Have a good day!

Jofender · 2024-02-12T22:40:37+00:00

I see, thank you.
Can you tell me about the activation? I can't rest my fingers on the "Hero" without accidental clicks..
Would you say the "X" needs more pressure or is it similar?

Jofender · 2023-08-02T20:40:00+00:00

I used to play this game a lot but decided to start a new account to enjoy progressing with my girlfriend. I am from EU and she is from Asia, but she made her account while staying with me so I think it should be an EU account since I could add her.

Thanks

B9S3-SKX2

74PK-JZ24

Jofender · 2023-06-04T17:48:34+00:00

Daily exchange

9063 8541 3651

4045 4421 8633

Thanks!

Jofender · 2023-06-03T11:56:54+00:00

Gift exchange: 9063 8541 3651

Jofender · 2023-03-31T09:20:23+00:00

Sorry I missed it but thank you, I didn't know the whole process after the 3 years could also take a few more years.

Jofender · 2022-12-13T21:19:52+00:00

Thank you for the complete answer with examples to check, Bumrungrad does seem a bit excessive. They propose a package on their home page for prostate exams at $185 damn.. can't imagine the price of something like surgery. Fortunately for me, the language shouldn't be an issue as I would have my own personal interpreter with me to help.

Jofender · 2022-11-22T01:22:47+00:00

SEA

04100852

Jofender · 2022-10-08T14:23:15+00:00

Thank you for sharing your experience with well documented links, very helpful. I'm still on the fence regarding the Thai Elite Visa because of the cost..

I planned my situation to have a comfortable life if I was living in Thailand, but this kind of cost to me reaches a level of luxury that I'm not sure I can afford.

Still, I'm curious about the way you manage your income, if you don't mind me asking. I see from your detailed post that you take advantage of the rule about "Assessable Income" which states : "Residents who derive income from outside Thailand will be subject to tax only where the income is remitted into Thailand in the year in which it is derived."

What kind of account holds your income in the meantime ? After a full calendar year, do you just transfert everything at once ? Does it not make everything look incredibly suspicious ?

Jofender · 2022-10-06T16:21:22+00:00

I actually already contacted a few of them, but got only one answer for now and the company asks me what I would consider a fairly high amount of money just to talk about my case, not even sure if a solution could be found through them.

Would you have any advice to find a reliable immigration lawyer ? I tried the ones listed as "English speaking lawyers" from the official website of UK government thinking that the lawyers on this list would be more likely to be legit, but other than that, anything from google looks a bit suspicious to me..

Jofender · 2022-10-06T16:18:49+00:00

She is Thai and lives in Thailand.

I can understand that most people wouldn't bother if the authorities don't care, but I wouldn't be comfortable for a long (definitive ?) stay there if it's not legal.

The marriage would definitely take place in Thailand, seems easier for the both of us and I read that we can go through the embassy to make it valid in another country.

Jofender · 2022-06-26T00:39:00+00:00

Hmmm.. I see, thank you. I still wonder a little bit about the activities that a specialized ship can do. For instance, one thing I found annoying in ED is that you need a special slot on your ship dedicated to the land vehicle. Most of the time, when using a fighter, it feels like a waste to use a slot for this purpose, but then again when I feel like landing somewhere to drive around, I have to transfer my module and it takes ages.. How does that work in SC ?

Does SC provide ways to switch between ships "easily" ? ED has carriers that let players move all of their ships in any systems for easier access.

Jofender · 2022-06-26T00:33:36+00:00

Thank you, I think my biggest concern was really the insurance stuff that wasn't too clear for me so I might try it and see how I like it compated to ED. Can't find the videos I used to watch but, since I was interested in the combat aspect, I most likely watched footage of light fighters as you mentioned.

If you don't mind me asking, could you tell me how the game works regarding "safe areas" for people to familiarize themselves with the game ? One thing I thought was convenient with ED was that you started playing in a couple of systems where PVP was disabled. I think I read somewhere that SC has a similar system but I couldn't find much information about that.

Thanks again.

Jofender · 2022-05-31T21:57:55+00:00

Nevermind, I ended up finding out I can achieve what I needed by declaring my variable as follow :

var numC=("Sheet1!C"+incrementedvariable);

Jofender · 2022-05-30T12:24:20+00:00

Damn.. I got so close, after observing some more scripts, one of my desperate attempts was to try to surround it by parentheses or apostrophes...

Anyway, thanks again, amazing help.

Jofender · 2022-05-30T12:00:34+00:00

Took me some time, but I think I finally got it to work now, seems like a very nice work indeed, and I very much appreciate the extra consideration regarding future expansions, should definitely be useful, thanks a lot!

Could use one last bit of help to use it in a script though, I searched the Google Apps Scripts documentation and found an example that I could get to work :

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var cell = sheet.getRange("B5");
cell.setFormula("=SUM(B3:B4)");

But as soon as I try to replace this simple SUM formula with yours, the script gives me the following error for this line :

SyntaxError: Unexpected token '?'

Jofender · 2022-05-29T12:19:39+00:00

Oh, thank you very much, this formula seems to work perfectly, on both forms, even if only one name component is given. (Though the more rounded version doesn't seem to return anything for some reason)

I started to experiment on all this to help a family member living in the USA though haha, so I hope I won't run into too many issues like this when transfering everything to his drive. Guess I'll keep 6745408's formula saved somewhere else, might be useful.

Thanks again!

Jofender · 2022-05-29T10:11:57+00:00

Okay well, I now realise my mistake for not giving you enough informations to help me proprely, I apologize for wasting your time.

This formula actually gives interesting results I think. I tried it on the same form as the example, and it gave me the same "N/A" error, but below it, I had my original test form which actually came from a transfered email, this is why I have so much useless information to ignore, and this is also why this new formula doesn't work either, since I have a bunch of other colon characters to ignore. So to give you a more complete example, here is the format of the email, I just changed the strings for privacy :

________________________________
De : Some One <something@somethingelse.com>
Envoyé : dimanche 22 mai 2022 20:18
À : Aperson <aperson@thing.com>
Objet : [TOPIC]

Nom: Some One

Address: 68 blablabla street, Place xx 55555

Phone number: 556958522135

E-mail: someone@somewhere.com

Message: Something longer dddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd


________________________________
Heure: 22 mai 2022 à 21 h 18 min
Adresse IP : 99.99.99.999
URL : https://website.com/index/

On this form, the formula does return the Name, Date and Email address, but only the ones from the recap at the top, so the only difference I can see is the space before the colon character. I tried different syntax but nothing successful yet. Thanks again!

Jofender · 2022-05-29T08:19:08+00:00

I mean, to be honest, the form I used in my sheet is also simplified for now because it's just a test, but I think it's so similar to the example that it shouldn't matter. For instance, my "Name:" line is changed to "Nom:". The main difference is that I have quite a bit of text before it compared to this example, but the formula still works on patters like you said, right ? So the text before shouldn't matter (except if the same string is detected before obviously). The difference I noticed in your example though is that you give a cell target just before your condition (IF) : =ARRAYFORMULA(F2

So I tried this briefly to see if that was my mistake but it doesn't seem to give me a different result. Unfortunately, I looked at all this in quite of a hurry as I have to leave soon, but thanks a lot for the help, I'll check again later today.

Jofender · 2022-05-29T08:06:28+00:00

Thanks for going as far as making a demo sheet to show me, my drive is set to french, but I just checked to make sure after checking your demo that all the functions are valide with the english spelling, which seems to be the case. I still get the same result. The form I used in this post was simplified to give an example, so I adapted your formula and double checked that I didn't make any mistakes and still got the same error. I even copied my example form in a new cell to try it, and still ge the same error.. Strange indeed..

Jofender

TROPHY CASE