1,709 reputation
915
bio website metaed.blogspot.com
location Fort Worth, TX
age 52
visits member for 3 years, 1 month
seen Sep 27 at 3:14

--
Sometimes they fool you by walking upright.


Oct
24
awarded  Yearling
Jun
25
comment Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
@MattJohnson Yes, in fact I have "wrong" in quotes because I agree with you -- it is quite possibly an intentional design difference. But even a design can be wrong, and I think the more interesting question is how should it work, and why should it be different in New Sheets.
Jun
25
comment Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
This is a great answer. I've added date/time formatting to my test cases to expose the use of December 30, 1899. Now I want to look a lot more closely at how Sheets does time value conversion between sheets having different timezones, and how this has changed between Old and New Sheets.
Jun
25
comment Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
@MattJohnson Hope that the above gets you started. Now I am very curious whether Google got timezone conversion "wrong" in New Sheets.
Jun
25
comment Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
"Starting in March and April 2014, Google Sheets users creating new spreadsheets will be automatically directed to the new Sheets. All previously created spreadsheets will remain in the older version of Sheets for now. If you need to create a spreadsheet using the old Sheets, you can do so at g.co/oldsheets" —Check out the new Google Sheets
Jun
25
revised Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
added 186 characters in body
Jun
25
revised Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
add old sheets vs. new sheets
Jun
25
comment Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
@pnuts It is still reproducible in Old Sheets. But it is not reproducible in New Sheets. I will update the question to reflect.
Feb
24
comment How can I create a fixed column header in Google Spreadsheet like the first sheet?
@MichaelKrebs Thanks for the update. I have changed the answer to reflect changes in the app, and added information about the Android app as well.
Feb
24
revised How can I create a fixed column header in Google Spreadsheet like the first sheet?
updated to reflect changes in the app
Dec
6
awarded  Necromancer
Nov
26
awarded  Caucus
Nov
8
awarded  Enlightened
Nov
8
awarded  Nice Answer
Oct
30
awarded  Guru
Oct
24
awarded  Yearling
Aug
22
asked Why is my imported time 668 seconds ahead of the value in the original cell? Is this reproducible?
Aug
19
awarded  Tumbleweed
Aug
12
asked In Google Spreadsheet, finding what formulas reference a given value
Apr
12
awarded  Enlightened