Ask Your Question
0

Why in LibreOffice Calc, Unkown Frame is inserted?

asked 2017-02-07 09:39:01 +0200

Lewtwo gravatar image

updated 2017-02-07 09:55:25 +0200

Evgeny gravatar image

LibreOffice Calc is inserting an unknown Frame of some type over Cell A1 in ever spreadsheet. It is filled with meaningless text. I can edit or delete the text but I can NOT get rid of frame or even identify what it is supposed to be. I am getting VERY Flustrated --- I abhore Windows but I may have to return to Windows and Excel if I can not resolve this problem.

edit retag flag offensive close merge delete

Comments

1

Can you upload a sample file somewhere for us to look at? Such as http:\mediafire.com

robleyd gravatar imagerobleyd ( 2017-02-07 09:49:01 +0200 )edit

Maybe in some way your default template was changed or modified:

m.a.riosv gravatar imagem.a.riosv ( 2017-02-07 11:28:41 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-02-07 12:26:07 +0200

Lewtwo gravatar image

It was data from QuickBooks .. the spreadsheets are extracted from QB as I am trying to move the accounts from QB. I still do not know how to get rid of the stupid frame object but the excel function "ActiveWorkbook.DisplayDrawingObjects = xlHide" will cause it to be hidden (of course you have to run Exclel to do that). More information at this URL: https://msdn.microsoft.com/en-us/libr... Workbook.DisplayDrawingObjects Property

edit flag offensive delete link more

Comments

You have an option in Menu/Tools/Options/LibreOffice calc/View/Objects, but

m.a.riosv gravatar imagem.a.riosv ( 2017-02-07 23:35:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-02-07 09:39:01 +0200

Seen: 37 times

Last updated: Feb 07 '17