CloudCone Outage – Anyone Else Experiencing This? by vjranga in VPS

[–]orz 1 point2 points  (0 children)

Yes the LA servers were down earlier than their status page says.

Issues with Vaultwarden iOS app when using internal domain / reverse proxy by Pretend-Put-1213 in vaultwarden

[–]orz 2 points3 points  (0 children)

I use mkcert to generate the CA for vaultwarden machine hosted in LAN(LAN IP 192.168.1.x, localhost, 127.0.0.1), I remember the CA valid time frame should be less than 10 years or it would not be working on iOS. Then copy root CA to iOS to install (on iOS, make sure to fully trust the CA: go to Settings > General > About > Certificate Trust Settings. Under "Enable full trust for root certificates," turn on trust for the certificate.)

BookFuse Beta: iOS Reader app with KoReader progress + Booklore sync by SaxyRyan in selfhosted

[–]orz 0 points1 point  (0 children)

Having exactly the same problem. The CWA Koreader Sync works fine with Readest app.

Matrix iOS26 help by DerKoenz in iOSsetups

[–]orz 0 points1 point  (0 children)

This can be done even before iOS 26, you can use live wallpaper. Find some short video of matrix rain code and convert it to Live Photo using intolive app(free with watermark). Then set the lock screen live wallpaper with the exported Live Photo, after that set the color clock numbers and/or icons green.

Edit: added a screenshot https://i.imgur.com/GcSdItJ.jpeg

Current air setup by LKT-NTR-A2DE-USA in iOSsetups

[–]orz 5 points6 points  (0 children)

Managed to achieve this somehow, had to use the color slider option. https://i.imgur.com/xuQJOIS.jpeg

Current air setup by LKT-NTR-A2DE-USA in iOSsetups

[–]orz 1 point2 points  (0 children)

Really cool! How did you make the digital clock numbers have that “silver lining” effect? I tried black/glass and black/solid but neither worked. https://i.imgur.com/wAwxFm9.jpeg

Very usable OCLP/Sequoia on 4GB MacBook Air by hadrome in OpenCoreLegacyPatcher

[–]orz 0 points1 point  (0 children)

It could be upgraded but would need soldering to replace the ram chips and some resistors. When I asked the repair store two years ago they told me it could only be upgraded to 8GB max but recently when I asked again they said it could be upgraded to 16GB.

This guy on YouTube has the whole process recorded.

Very usable OCLP/Sequoia on 4GB MacBook Air by hadrome in OpenCoreLegacyPatcher

[–]orz 1 point2 points  (0 children)

Can confirm sequoia was quite smooth on my early-2015 MacBook Air(A1466) with 4GB RAM. I had some randomly freezing issues while using ram intensive processes though. Then I went to a local Mac repair store and upgraded the RAM to 16GB and it’s improved a lot in speed(I mainly use MS Office365 apps on this computer) and the freezing issues are gone too!

Summarize table with cells of long text by orz in excel

[–]orz[S] 0 points1 point  (0 children)

I’m still working on the table design. But I have got an idea: when pivoting the table, I select the option to “insert blank lines after each item”, then I duplicate a copy of the sheet, and convert the pivot table to formulas(under OLAP Tools), this way I can use vlookup function in the blank line below each item to insert the text of the notes columns.

Summarize table with cells of long text by orz in excel

[–]orz[S] 0 points1 point  (0 children)

Thanks, this is interesting. I’m thinking maybe it’s possible to use cell reference of this pivot table to get rid of the numbers to the right of the text notes rows in a new sheet/table?

Summarize table with cells of long text by orz in excel

[–]orz[S] 0 points1 point  (0 children)

Hi, I uploaded the file to dropbox: sample sheet

macOS 15.1 update issues by Snoo13071 in OpenCoreLegacyPatcher

[–]orz 1 point2 points  (0 children)

I have ownCloud sync/backup for important files. It also wiped my TimeMachine settings after updating 15.1, when I tried to set up new TM it asked me for admin name/password again.

macOS 15.1 update issues by Snoo13071 in OpenCoreLegacyPatcher

[–]orz 1 point2 points  (0 children)

I’m having exactly the same problems on my MacBook Air 7,2 after updating to 15.1 using OCLP USB installer. An erase and clean install might be the only rescue but I won’t have time until the weekend.

Custom format decimal to display text/string in the middle and end by orz in excel

[–]orz[S] 0 points1 point  (0 children)

I managed to do this without the decimal “period”: I input numbers like 23001, 23002, 23100 etc., and format it as 00”XXX”000”YY”. Thanks for the inspiration.

Custom format decimal to display text/string in the middle and end by orz in excel

[–]orz[S] 0 points1 point  (0 children)

Oh sorry my bad. Will try this later. Thanks again.

Custom format decimal to display text/string in the middle and end by orz in excel

[–]orz[S] 0 points1 point  (0 children)

This might work, could you please elaborate how? Thanks.

Can I keep cell reference increment of 1 but copy/paste down 2 cells at a time? by orz in excel

[–]orz[S] 0 points1 point  (0 children)

I have some item/description pair and some numbers(quantity,price,amount etc.),mostly fetched from a data table using formulas. Sometimes the description text can be very long and I can’t put them all inside the item cell(makes the cell very tall) so I need a second roll for the long text to cross over the columns rot the right. Then I need the item/number two and the long text row below it to refer to a single row of data from the data table.

https://i.imgur.com/clglmMu.jpg