When I attempt to enter a range for error bars (R11C11:R18C11), the range automatically changes itself (to R11C6:R18C6). When I reference the sheet’s name (‘sheet1’!R11C11:R18C11), it works, but i have problems copying.
You will need to provide greater detail in order for others to help you with why this may be occurring. What is your operating system, LO version, and file format? What is the nature of the data being use and the context for the R11-18C6 range?