Ask Your Question

New Calc spreadsheet opens with data already in it

asked 2015-06-03 00:46:02 +0100

MadmaHord gravatar image

updated 2015-08-26 19:14:22 +0100

Alex Kemp gravatar image

Hi everyone, this has got me and my colleague stumped. I'm using LibreOffice version on a Windows 7 PC. I've not used my LibreOffice since February, and I've just opened a new spreadsheet in Calc, and it already contains data. Specifically, it contains data that I entered into a spreadsheet back in February.

I long ago deleted the file that contained this data, but it's there in the new document, whether I open Calc from the Programs menu, or whether, with Calc already open, I go File > New > Spreadsheet (or Ctrl+N). The new file is headed "Untitled 1" (or "2" or whatever), but other than that contains the same data and Sheet Label as the old file.

I've tried uninstalling and reinstalling LibreOffice but it still happens, which makes me think that it's originating somewhere other than LibreOffice itself. Has anyone else ever come across this? I've had a search online but there's nothing that I can find.

Please let me know if my question is unclear; I'm happy to supply a screengrab if it helps.

Many thanks, Fran.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-06-03 03:26:20 +0100

m.a.riosv gravatar image

Maybe in February you saved that file as template?

edit flag offensive delete link more


And it became the default template. Try the link below for guidance to switch back to a blank template/file.

Previous Answer

Rugslug gravatar imageRugslug ( 2015-06-03 04:07:02 +0100 )edit

Thanks so much m.a.riosv and Rugslug, I had suspected it might be something like that, but as with the person in the Question you linked to, I don't remember setting any templates previously - I must have done it by mistake.

The solution to reset a blank SS as the default template worked great, and it was nice to see that it didn't only happen to me. :)

MadmaHord gravatar imageMadmaHord ( 2015-06-25 04:11:08 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-06-03 00:46:02 +0100

Seen: 106 times

Last updated: Jun 03 '15