Hi Fajar, On Thu, Jan 12, 2006 at 13:02:45 +0700, Fajar Priyanto wrote:
> > >> So if it was a new sheet, you want all the cells to show 0's? > > > > yes! > > I don't know how to make it automatic, but, you can type 0 at cell A1, copy > it, and then click on the most upper left button on the sheet (the box > located at the left of A column, and at the top of row 1) to select all cell > in the sheet, and then paste (ctrl V). Not a good advice, as this grows your document to several megabytes, or even may let you run out of memory, depending on the amount of RAM installed in the machine and available swap space. If it doesn't have to be a 0 or other string, which aren't possible as display of empty cells, I suggest to create a cellstyle based on the Default style, choose a different background color, and use conditional formatting to assign the style if the cell value equals 0. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
