Ask Your Question

Large red arrows in calc? [closed]

asked 2013-07-15 20:46:24 +0200

osnomad gravatar image

updated 2013-07-15 23:02:29 +0200

manj_k gravatar image

I have a spreadsheet that is displaying red arrows that are the same height as the cells and are comically large in the sheet. They seem to be indicating the alignment of the cells but I cannot figure out how to turn them off.

heres a pic:

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-03 23:46:13.102183

3 Answers

Sort by » oldest newest most voted

answered 2013-07-15 22:48:33 +0200

w_whalley gravatar image

The red arrows indicate that the cell's contents are too wide for the cell. You should be able to turn them off by selecting all cells (click on the empty box to the left of the column label "A"), then on the menu choose Format/Column/Optimal Width.

I don't know why your red arrows are so large. You might want to submit a bug report.

edit flag offensive delete link more

answered 2013-07-17 16:09:34 +0200

osnomad gravatar image

Setting the column width does remove the arrows so it appears that these are the overflow arrows but enlarged for whatever reason. I'm suspicious of the font. I haven't had a chance to work on it since submitting the question but I suspect this was an excel file that was using a font with a different version on the file creators machine. If I get back to it I'll try to post more info. Thanks.

edit flag offensive delete link more

answered 2013-07-15 22:15:57 +0200

m.a.riosv gravatar image

updated 2013-07-15 22:16:27 +0200

Please can you link a sample file with the minimum cells to see the issue?

Please what is your OS and your LibreOffice version?

edit flag offensive delete link more

Question Tools



Asked: 2013-07-15 20:46:24 +0200

Seen: 1,740 times

Last updated: Jul 17 '13