Bug 48199 - Use of dollar sign ($) to prevent changes to a field reference when copying doesn't work.
Summary: Use of dollar sign ($) to prevent changes to a field reference when copying d...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-02 08:00 UTC by Hughes
Modified: 2012-07-03 05:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Formula that fails (9.66 KB, image/jpeg)
2012-04-02 08:00 UTC, Hughes 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Hughes 2012-04-02 08:00:03 UTC 
Created attachment 59383 [details]
Formula that fails

I have a spreadsheet that I've been using for years in which I copy a formula from one cell to another to simplify the extension of my worksheet.  I have used the dollar sign to prevent specific cell references from being updated when I copy the formula.  It has worked in MS Excel and in OpenOffice Calc.  It no longer seems to work in LibreOffice.
Comment 1 sasha.libreoffice 2012-06-29 02:40:10 UTC 
Thanks for bugreport
I have tried this formula on 3.5.4 on Fedora 64 bit:
=AVERAGE($A$1:$A15)
And it works correctly. May be bug fixed?

If bug still exist, please, attach ods document that demonstrates this problem.
Comment 2 bfoman (inactive) 2012-07-03 05:52:59 UTC 
Checked with:
LO 3.5.4.2 
Build ID: own W7 debug build
Windows 7 Professional SP1 64 bit

Could not reproduce.
Please check if this bug is reproducible with the latest stable release and reopen if needed.