sometimes when i am using openoffice calc to solve some calculation i get ### in the cell.
2007-01-23 12:22:09 · 5 answers · asked by sadfwer 3 in Computers & Internet ➔ Software
The width of the column/cell is too small to properly display the value within the cell. Simply move the mouse to the horizontal column header near the top, go to the right edge separating the two column, click and drag to the desired width.
Or, highlight the entire column by clicking on the column header, right click for options and select 'column width' for manual/precise modifications to the column width.
2007-01-23 12:27:27 · answer #1 · answered by ♫ Life is a Highway ♫ 4 · 0⤊ 0⤋
It means hat the resutt of the formula is too wide for the cell width. You can either reduce the font size in that cell, widen the column width or wrap the cell content in your alignment settings.
I use openoffice sxc files for most everything I do. If you need more help, contact me with your question.
2007-01-23 12:26:23 · answer #2 · answered by Anonymous · 1⤊ 0⤋
The string “15/12/fifty 5” works advantageous with me. you may attempting getting into it into Calc as '15/12/fifty 5 and the starting up apostrophe will tell Calc and Excel to maintain the precise characters you've typed without doing any calculations.
2016-12-02 23:23:02 · answer #3 · answered by minogue 4 · 0⤊ 0⤋
666
2007-01-23 12:27:01 · answer #4 · answered by ? 4 · 0⤊ 2⤋
if its the same in MS Office, then theres not enough space in the box to show it adjust the width and you'll be fine
2007-01-23 12:27:25 · answer #5 · answered by Anonymous · 0⤊ 0⤋