[Solved] Fill series with formulas without formating

Discuss the spreadsheet application

[Solved] Fill series with formulas without formating

Postby kilgor » Fri Apr 18, 2008 2:02 pm

Hi,

Using OO 2.3.0 Calc on 64 bit Fedora 8.

I want to fill a series (column) with formulas, but each row is coloured differently. Right now when filling the series, the formatting of the first row is also applied to the others messing up my custom colouring of the rows.

One way to avoid this problem is to apply the colouring after finishing the spread sheet, but that's not really a usable solution with an often edited document.

How do I avoid filling the series with formatting while still filling it with formulas? Or how do I fill a series with _only_ formulas.

Regards
Last edited by Hagar Delest on Tue Jun 10, 2008 3:42 pm, edited 2 times in total.
Reason: tagged the thread as Solved.
kilgor
 
Posts: 2
Joined: Fri Apr 18, 2008 1:45 pm

Re: fill series with formulas without formating

Postby kilgor » Fri Apr 18, 2008 2:06 pm

Nevermind, just got a solution from a co worker. You have to copy the formula and then paste special it, pasting only the formula.
kilgor
 
Posts: 2
Joined: Fri Apr 18, 2008 1:45 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 20 guests