Click here to Skip to main content
15,438,393 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:48
MemberDan Neely23-Nov-20 4:48 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 4:45
protectorNelek23-Nov-20 4:45 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:51
MemberDan Neely23-Nov-20 4:51 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 7:15
protectorNelek23-Nov-20 7:15 
GeneralRe: The joys of Excel Pin
g_p_l23-Nov-20 4:22
Memberg_p_l23-Nov-20 4:22 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 5:18
MemberDan Neely23-Nov-20 5:18 
GeneralRe: The joys of Excel Pin
Southmountain23-Nov-20 7:38
MemberSouthmountain23-Nov-20 7:38 
GeneralRe: The joys of Excel Pin
kmoorevs23-Nov-20 5:44
Memberkmoorevs23-Nov-20 5:44 
We do a lot of importing from spreadsheets. Last week a colleague helped a customer setup an import for a much smaller file that you are dealing with. (~7k rows and 20 columns) He had created a nice little pivot grid with subtotals and totals so we'd have something to compare to.

The import worked like a charm but checking the total against the pivot grid showed differences. Highlighting the column for the values we were after also did not match what was imported. It was off by a small amount...still enough for the customer and the colleague to think that something must be wrong with the import/software so they generated a support ticket.

It took way too long to figure out that around a dozen or so cells had numbers formatted as text which were not calculating in the pivot grid or in the automatic total in the toolbar. The import was actually correct!

This file in question is an exported report from another boh system. (not ours) When the customer was made aware of the problem, the first question was how to easily find and fix those cells. They weren't real happy with the answer I gave...scroll through the sheet and look for the cells that are left-aligned, click on them one at a time and convert to number. It's what I did and took around 5 minutes...really, it's not my problem...you don't have to fix it at all, just trust the import which was right all along! Of course the next question was related to why didn't the import just fix the file for them. WTF | :WTF: I can't win! Laugh | :laugh:
"Go forth into the source" - Neal Morse
"Hope is contagious"

GeneralRe: The joys of Excel Pin
Slacker00723-Nov-20 5:51
professionalSlacker00723-Nov-20 5:51 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 6:58
MemberDan Neely23-Nov-20 6:58 
GeneralRe: The joys of Excel Pin
Peter Adam23-Nov-20 6:37
professionalPeter Adam23-Nov-20 6:37 
GeneralRe: The joys of Excel Pin
Sander Rossel23-Nov-20 21:17
professionalSander Rossel23-Nov-20 21:17 
GeneralRe: The joys of Excel Pin
Dan Neely24-Nov-20 2:33
MemberDan Neely24-Nov-20 2:33 
GeneralWhat tools and services do you now consider part of your daily workflow? Pin
Chris Maunder23-Nov-20 3:31
cofounderChris Maunder23-Nov-20 3:31 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Jacquers23-Nov-20 3:44
MemberJacquers23-Nov-20 3:44 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Sandeep Mewara23-Nov-20 3:59
mveSandeep Mewara23-Nov-20 3:59 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
PIEBALDconsult23-Nov-20 4:16
professionalPIEBALDconsult23-Nov-20 4:16 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
OriginalGriff23-Nov-20 4:33
mveOriginalGriff23-Nov-20 4:33 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Nelek23-Nov-20 4:39
protectorNelek23-Nov-20 4:39 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Maximilien23-Nov-20 5:11
MemberMaximilien23-Nov-20 5:11 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Slacker00723-Nov-20 5:47
professionalSlacker00723-Nov-20 5:47 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Arthur V. Ratz23-Nov-20 6:16
professionalArthur V. Ratz23-Nov-20 6:16 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Gary R. Wheeler23-Nov-20 6:20
MemberGary R. Wheeler23-Nov-20 6:20 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Maximilien23-Nov-20 7:58
MemberMaximilien23-Nov-20 7:58 
GeneralRe: What tools and services do you now consider part of your daily workflow? Pin
Slacker00723-Nov-20 9:42
professionalSlacker00723-Nov-20 9:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

When building an application, when is the most important time to consider the User Experience?
They are the ones we write code for, right?
  Results   688 votes