Ask Your Question
0

spreadsheet opens in writer and not calc

asked 2018-03-27 14:18:31 +0100

thaxtedfox gravatar image

I'm importing a spreadsheet from a donations recording system to create the right format to send to the tax authorities in UK. It has worked for the past ten years. This time the spreadsheet will only open with Writer. I've tried "open with" etc. The supplier of the donations system has checked that there are no bugs in his system. The charity I'm doing this for needs the money!

edit retag flag offensive close merge delete

Comments

What is the file format and what is the file name extension? And did any or both change?

erAck gravatar imageerAck ( 2018-03-27 16:05:50 +0100 )edit

Read these guidelines and ask a good question. In particular, share the problem file.

gabix gravatar imagegabix ( 2018-03-27 16:10:12 +0100 )edit

erAck The imported spreadsheet is .xls and the format of the LibreOffice spreadsheet that I want to import it into is also .xls. when it tries to open with Writer it still has an .xls extension. I saw on this site similar problems occurred two or three years ago.

gabix Apologies if I've breached protocols. I've never had to use this site before

thaxtedfox gravatar imagethaxtedfox ( 2018-03-27 20:42:02 +0100 )edit

The matter is that you need help. Thus, help us help you. That is what those guidelines are about.

gabix gravatar imagegabix ( 2018-03-27 20:54:27 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-27 22:18:53 +0100

Try Sheet -> Insert Sheet from File -> Select file & click Open -> From (choose the relevant sheet here from the donations recording system's spreadsheet - you can try each one one at a time).

Then select New Sheet under Sheet.

You can move the sheets around once they are inserted instead of messing with the other options on the pop-up. Also, you can change the name of the sheet like normal instead of during insertion.

gabix, I do not think that fiscal donations would likely be a problem file in which someone is willing to share.

edit flag offensive delete link more

Comments

Thanks for your advice. I'll try that in conjunction with the developer of the donations recording system

thaxtedfox gravatar imagethaxtedfox ( 2018-03-28 10:34:15 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-27 14:18:31 +0100

Seen: 59 times

Last updated: Mar 27 '18