'Crosstalk' in LibreOffice spreadsheets.

[Giraffe]

I've a batch file that opens 4 spreadsheets at once. They should all be separate, but when I type in a cell in one there's no visible input. Looking at the others, the entry is in a cell in another spreadsheet!
I don't know how they became linked, but I did have a bit of trouble when I wanted to put a formula in a cell (not the affected one) and clicked on it and then went to a similar cell in another spreadsheet to copy the formula and mod. it.

Any ideas on how to 'de-link' them, please?

[Jonj1611]

Haven't got a clue mate in all honesty. Hopefully someone with a bit more knowledge will come along but in the mean time and just for laughs, god knows if it will work I asked ChatGPT, here was the answer :

1. Check for external data connections: Go to the Edit menu and select Links. If you see any external data sources listed, select them and click on the Break Link button to delete the connection.

2. Check for formula references: In each spreadsheet, go to the Edit menu and select Names. Look for any references to other spreadsheets in the Refers To column, and delete them if they are not needed.

3. Check for shared workbooks: If your spreadsheets are part of a shared workbook, this could be causing the issue. Try turning off sharing for each spreadsheet by going to the Tools menu and selecting Share Document.

4. Check for hidden links: Sometimes links between spreadsheets can be hidden. Go to the View menu and select Value Highlighting. Look for any formulas that reference other spreadsheets, and delete them if they are not needed.

5. Save each spreadsheet with a new name: Sometimes simply saving each spreadsheet with a new name can break any links between them.

God knows if any of that will help and if not like I said hopefully someone who does know what they are on about will help

[AGTDenton]

Can we see the command and flags being used to open the files?

I wonder if it's to do with instances. Possibly all opening up in a single instance instead of individually.

[Giraffe]

There's no mention of Links or Names in the Edit menu, but thanks for the suggestion.

I don't know what the flags are; the batch file is:

@echo off
cd "D:\Documents\AUTO\HOUSE\Elec and Gas bills\"
start /max GasUseage.ods
TIMEOUT /T 1 /NOBREAK
cd "D:\Documents\AUTO\HOUSE\Water\"
start /max WaterUseage.ods
TIMEOUT /T 1 /NOBREAK
cd "D:\Documents\AUTO\HOUSE\Elec and Gas bills\"
start /max ElectrcityMonthlyUseage.ods
TIMEOUT /T 1 /NOBREAK
cd "D:\Documents\AUTO\HOUSE\Water\"
start /max JLWM1414UseageRecord.ods
exit

[AGTDenton]

Well your command looks good. I don't have the issue you describe, however, mine are 4 test documents I just made.
When I start typing I have no issues.

Mine loads 4 separate windows instead of 1 window with four spreadsheets like I was half expecting, something I had an issue with Open Office back in the day.


If you were to manually load all four spreadsheets do you still see the same problem, similarly if you were to only open 1 spreadsheet do you experience the same problem?

Under "Sheet > External Links" do you have anything there in any of the spreadsheets linking to somewhere else?

[Giraffe]

Nothing under External Links for any of the four.
Sod's Law says that it didn't happen this time - I'll try again later, after a reboot.

[Giraffe]

Well, over the last few day the problem hasn't recurred - must have frightened it away.

[AGTDenton]

Well, over the last few day the problem hasn't recurred - must have frightened it away.

I like those ones. Though sometimes you do start questioning your own sanity.

[Jonj1611]

It was just a glitch in the Matrix, seems to have corrected itself

[Giraffe]

I don't question my sanity any more - never managed to get a sensible answer!