Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |

Summary: | Define cells in formula that wont be addapted copying | ||
---|---|---|---|

Product: | Calc | Reporter: | Unknown <non-migrated> |

Component: | code | Assignee: | bettina.haberer |

Status: | CLOSED IRREPRODUCIBLE | QA Contact: | issues@sc <issues> |

Severity: | Trivial | ||

Priority: | P3 | CC: | issues |

Version: | 643C | ||

Target Milestone: | --- | ||

Hardware: | All | ||

OS: | Windows 2000 | ||

Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |

Developer Difficulty: | --- |

Description
Unknown
2002-12-26 07:03:38 UTC
this sounds like absolute references: place a $ sign before each cell refernce you don't want to be updated: =$A$1 in C5 and copy C5 to E3 => E3 has =$A$3 too. you can also have only 1 $, so the other is a dynamic refernce. There is also a toolbar option which you can find in the paste or insert category of the edit toolbar dialogue. Sorry, couldn't find that. But this shows that this function isn't really intuitive. Wouldn't it be easier to find, if one could change these references when entering the formula? Maybe with a popup menu when right-clicking on the selected cells while editing the formula or so. you should place the $ in front of column or row indices in your formula: cell A3: you enter a formula like (without quotation marks) "=SUM (B1:B10)". if you place a $ in front of B and 1 and 10 and you copy the formula from its original cell to another cell, B,1 and 10 are not adjusted. so "=SUM($B$1:$B$10)" remains this way. While editing a formula, you can alter the state of a reference: Move the cursor into a cell reference and press SHIFT+F4 (repeatedly). Hi Bettina, one4you That works like Daniel (dr) described. closed. |