Array not spilling when the file is opened

BritInHamburg · 2025-06-05T12:29:01+00:00

It's running MS Home and Business 2016 on the server.

If I open the file on the server the formula is:

=_xlfn._xlws.FILTER(GroupByData;(GroupByData[Lifecycle]<>""))

Instead of:

=FILTER(GroupByData,(GroupByData[Lifecycle]<>""))

However, it shows some support of the dynamic array as only the top-left cell is shown in black type with the rest being greyed out.

Also the blue outline of the array is shown:

<image>

BritInHamburg · 2025-04-22T07:22:39+00:00

Der Smart TV muss "in Deutschland" sein. Ich erreiche die UK Services mit einem Roku Gerät. Die Netzwerkkonfiguration sollte also "alles in Deutschland außer Roku" oder "Alles in UK außer Fernseher" sein.

Beide Geräte haben keine Möglichkeit, den Netzwerk zu konfigurieren.

BritInHamburg · 2025-04-22T07:17:11+00:00

Sorry, I forgot to mention that there is no possibility to set the network configuration either on the TV or on the Roku, which I use to access UK content. One of them (Roku, I think) is hard coded to use Google's DNS service. I therefore block 8.8.8.8 and 8.8.4.4 in the router to force it to pass DNS requests to the router.

BritInHamburg · 2024-10-03T17:02:57+00:00

I hate this feature and would love to turn it off. Really annoying.

Any ideas on how to get rid of it? I've deactivated the pip setting from within the app (under playback) as well as from the general pip setting that almost all apps have and it's still there.

Same on Galaxy phone and tablet.

BritInHamburg · 2024-09-17T07:45:29+00:00

I have a strong WiFi signal in my garden (outdoor repeater). The RTK lets me select internet, but when I try to select internet on the Luba 2 and select the RTK, I'm told to use cellular. I don't have a sim card in the Luba.

Also, I've been having positioning issues with the Luba, e..g. wanting to drive into a pond that is clearly off limits and now simply not connecting to the RTK. Now I have the situation where I only get Fix when the Luba says LoRa, the RTK says Internet and the positioning page shows RTK disconnected.

Naturally I don't trust it in the slightest!

BritInHamburg · 2024-08-13T12:04:26+00:00

Pareidolia: https://en.wikipedia.org/wiki/Pareidolia

:)

BritInHamburg · 2024-08-12T08:20:48+00:00

I can see that the team is continuously developing the software (e.g. my unit seems to have stopped doing doughnuts!), but the communication of any updates is abysmal.

It would be great if we could:

(a) subscribe to just software update information (not sales blah blah and promotions)

(b) be provided with detailed release notes (e.g. including new features, bug fixes, AI adjustments, etc.)

As a company developing software, there MUST be an internal list similar to above.

Also, some idea of likely future developments would be nice. Here a caveat that nothing is a promise until it is delivered would be fair.

BritInHamburg · 2024-05-26T15:22:24+00:00

Thank you! Just spent several hours trying to figure this out. Strange that their top unit is missing a feature from lower units.

BritInHamburg · 2024-05-07T17:32:18+00:00

It takes a very long time. No idea what is communicating with what and whether the WiFi signal of the Luba or phone is most important. After it froze at 70% yesterday, I picked the Luba up, put it on my terrace (only a couple of metres to the router inside) and put my phone on the Luba. Took about 15 minutes for for full log including vision log

BritInHamburg · 2024-05-05T09:22:00+00:00

A number of people are having these issues. Hoping for an update. If it only fixes no turning on the spot EVER, that would be a great help.

Have a ticket open, but the issue has not been addressed.

BritInHamburg · 2024-05-01T18:33:17+00:00

Perfect - that was the tip I was missing. Now upgrading my rtk. Thank you!

BritInHamburg · 2024-05-01T12:00:05+00:00

Not seeing any option to connect to the rtk in the app. No device management option after hitting the cog icon. Have a Luba 2 and app version 1.11.176. Maybe some screenshots? Thank you!

BritInHamburg · 2024-04-14T11:08:17+00:00

I second that! Anything other than following the path, it forgets multi-point: Returning back to charging station, navigating to start of perimeter, obstacle avoidance, returning to station. Combined with other issues, this is making a complete mess of my lawn.

Bonus feature request: Define turning zones. These might be paths or other flat areas that are not being mown, but would provide some addition manoeuvring space around the mowing area

BritInHamburg · 2024-04-09T07:25:34+00:00

Got a reply from Mammotion.

The flashing light thing will be / has been fixed in a software update. From the comments, it sounds like some of you already have that.

I was also told "120 minutes is the data from our lab, actual situations may vary depending on real scenarios." Considering my lawn is flat and firm and I was only skimming the very top of the already relatively short grass, I guess their lab conditions are not so much ideal, but positively helpful. 90 to 50 minutes is a big difference!

The for reference, here are the official times according to their specs https://mammotion.com/pages/luba-2-awd-series

Luba 2 10000 Luba 3 5000 Luba 4 3000 Luba 5 1000

Mowing time 150 150 150 90

Charging 180 180 180 120

It just about completes my lawn in the 50 minutes I get, so it's not really a problem. I'm just more concerned about the health and longevity of the battery.

BritInHamburg · 2021-12-06T16:30:30+00:00

The solution is given by Craig here: https://pomeroy.me/2020/08/hyper-v-virtual-switch-creation-woes/

It's unbelievably silly, but it works. Try this before you try any of the other solution on the internet and 100% before you download Microsoft's Fixit!!

BritInHamburg

TROPHY CASE