Re: OpenOffice
On Thu, 10 Feb 2011 09:52:36 -0500, WLS wrote:
Why would you expect one single cell copy to populate multiple cells?
You have to paste it into each individual cell.
Tested on oo 3.2.1 and a single cell copy will paste into multiple cells.
For example, what if you want to 44 cells in a row to have the sum of
the 10 cells below them, do you want to paste 44 times?
.
Relevant Pages
- Re: Copy column range of "single word" cells with spaces to a sing
... you may want to read David McRitchie's intro at: ... nastech wrote: ... For lots of cells, you may want to use a userdefined function: ... 060214 Copy column range of "single word" cells with spaces to a single cell ...
(microsoft.public.excel.misc) - Re: Custom function to search a string of text for certain values occu
... also str is a function in VBA, so poor choice as a variable. ... I have a list of values elsewhere, a range of cells called NF_Range. ... each test of the string against each of the values listed in NF_range ... of occurrence in the single cell the function points toward ...
(microsoft.public.excel.programming) - Re: Auto Filter does not work with embedded objects
... Format Object|Properties|Move and size with cells ... And make sure that each object is contained in a single cell. ... I filter on Column D, say Object D shows up with row 3 data. ...
(microsoft.public.excel.worksheet.functions) - RE: Wild Cards in Vlookup
... The solution will depend on data type in the cells. ... some has Multiple Phone Numbers in a Single Cell. ... is there any way to using wild Card in Vlookup fuction. ...
(microsoft.public.excel.worksheet.functions) - RE: Wild Cards in Vlookup
... its not working in 2 Cells ... "Shane Devenshire" wrote: ... some has Multiple Phone Numbers in a Single Cell. ... is there any way to using wild Card in Vlookup fuction. ...
(microsoft.public.excel.worksheet.functions) |
|
