Pasting from Excel


  • Discourse touched me in a no-no place

    Continuing the discussion from State: For £20 I'll sue MilwaukeePC for allowing DFS to have another sale:

    @Weng said:

    Found out my employer discontinued HSA contribution matching. Not from my employer. But from my account statement.

    <img src="/uploads/default/14439/04618c9479c3c4de.png" width="652" height="161">

    Apparently everyone else noticed and got their whining out of the way during healthcare enrollment season. I truly work for the most despicable pile of shitfuckers on the planet. They killed 401K matching a few years ago.

    Discourse note: I copypasta'd that from Excel. It pasted the raw text PLUS an image of a table? Did we get a wooden table plugin!?

    Repro without fixing it (From my credit card this time, because it's far more amusing than my HSA)

    Date No. Description Debit Credit
    11/24/2014 7045 BRUNO S LANCASTER PA 17601 USA 8.73 Food
    11/24/2014 7045 ROBURRITOS - EAST YORK YORK PA 17403 USA 11.4 Food
    11/25/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 35.54 Booze
    11/28/2014 7045 BRUNO S LANCASTER PA 17601 USA 9.9 Food
    11/28/2014 7045 MEXITALY YORK PA 17402 USA 34.53 Food
    12/1/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 30 Booze
    12/1/2014 7045 WATERWAY BAR & GRILL YORK PA 17403 USA 16 Booze
    12/2/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 32.6 Booze
    12/5/2014 7045 QUICK SIX BEER MART IN YORK PA 17403 USA 12.32 Booze
    12/8/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 26 Booze
    12/9/2014 7045 TROEGS BREWERY HERSHEY PA 17033 USA 21.3 Booze
    12/9/2014 7045 ROBURRITOS - EAST YORK YORK PA 17403 USA 11.4 Food
    12/9/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 24.54 Booze
    12/10/2014 7045 BRUNO S LANCASTER PA 17601 USA 8.73 Food
    12/11/2014 7045 HOLY HOUND TAPROOM YORK PA 17401 USA 33.72 Booze
    12/12/2014 7045 QUICK SIX BEER MART IN YORK PA 17403 USA 16.74 Booze


  • sockdevs

    254
    S16
    Tokyo

    255
    S16
    Tokyo

    256
    S16
    Suzuka

    257
    PC4
    Bathurst

    258
    S16
    Brands Hatch

    259
    S16
    Brands Hatch

    260
    S16
    High Speed
    Ring

    261
    S16
    High Speed Ring


    That's from one of my Excel files… and it's a totally different result.


  • Discourse touched me in a no-no place

    I'm using Excel 2010, in case that matters. On Win7, in case it's a clipboard thing.



  • Excel 2013, Windows 8.1:

    Header 1	Header 2
    

    Row 1 CELL CELL
    Row 2 CELL CELL
    Row 3 CELL CELL
    Row 4 CELL CELL


  • sockdevs

    2013 here.


    Trying without a filtered table:

    GEARS
    1
    2
    3
    4
    5
    6
    Average

    2013-14
    8
    6
    8
    6
    12
    7
    7.83

    2014-15
    7
    10
    10
    11

    9.50


    Yeah… Discoursistent.



  • With the top left corner cell filled in:

    DISCOCELL Header 1 Header 2
    Row 1 CELL CELL
    Row 2 CELL CELL
    Row 3 CELL CELL
    Row 4 CELL CELL


  • Discourse touched me in a no-no place

    What browser are you pasting into? I'm on Chrome hasn't-been-restarted-in-weeks-so-not-up-to-date.


  • sockdevs

    Firefox 35.0.1


  • mod

    This is the same as the image-and-svg bugthing isn't it?

    http://what.thedailywtf.com/t/svg-upload-test/7869


  • Discourse touched me in a no-no place

    Looks like it. Stupid browser trying to be helpful



  • The Windows clipboard allows the data to be stored in multiple formats-- for example, when you copy from Excel you get the data in Excel's native format, HTML, CSV (possibly? I don't remember for sure), and as a final fallback, an image. Clients are supposed to pick the first format listed that they understand.

    For some idiotic reason, Chrome (and/or Discourse) is seems to be picking all of the formats it understands. You're supposed to pick just one.


  • Discourse touched me in a no-no place

    Interesting, I'd always wondered how that works, but have never had occasion to code clipboard interaction code.

    I expect it's Dicsores' fault, because this shit works just fine pasting into Gmail.

    Perhaps the biggest irony is that Dicsores actually supports HTML, which would be the most useful way to do this, and is for some reason ignoring that one.



  • @Weng said:

    Interesting, I'd always wondered how that works, but have never had occasion to code clipboard interaction code.

    One of the few things Windows actually did better than Mac Classic. Which (originally at least) only allowed one data type per clipboard item.

    BTW this is also a good illustration of the, "before you write software for a computer, maybe you should actually spend some time learning how computers actually fucking work" principle. For whoever coded up this wrongstrocity.


  • area_deu

    eggs spam ham
    1 2 9
    2 4 8
    3 6 7
    4 8 6
    5 10 5
    6 12 4
    7 14 3
    8 16 2

    Using LibreOffice Draw + Chromium on Linux produces the same results.
    Wow.


  • Discourse touched me in a no-no place

    @blakeyrat said:

    wrongstrocity

    This word. I need it. For reasons.


  • Discourse touched me in a no-no place

    @Weng said:

    Interesting, I'd always wondered how that works, but have never had occasion to code clipboard interaction code.

    I had reason to do that sorta stuff about 15-20 years ago on a hobby project I had going.



  • @dkf said:

    This word. I need it. For reasons.

    copyright trademark patent pending give me moneys



  • @aliceif said:

    Using LibreOffice Draw + Chromium on Linux produces the same results.

    I have seen this before, when pasting from LibreOffice into an email (using kmail). I also just did this in the Booty topic.


  • Winner of the 2016 Presidential Election

    Firefox and Draw / Inkscape did well on SVGs...

    <!-- 
    	body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }
    	 -->
    
    
    
    
    
    
    
    
    	broken
    	clipboard
    	test
    
    
    	1
    	2
    	3
    
    
    	4
    	5
    	6
    
    
    	7
    	8
    	9
    

    ... yeah, Calc + FF: broken

    Edit: FF + Draw

    Well, that's... passable



  • Bumping because this bug still exists.

    Copying and pasting the text "hello" from OneNote desktop client (not the Windows10 client, important difference), and I suppose from any other MS Office program, into Opera, pastes:

    0_1485622342855_upload-9ed64350-9169-49b5-aaa2-3f2d79aea6ba Hello

    (The image is corrupted! That's probably Office's fault though).

    According to: http://madebyevan.com/clipboard-test/, the clipboard event is producing 3 "items": text/plain, text/html and image/png, and NodeBB is grabbing both the image/png and text/plain (but not text/html :cry:).


  • Impossible Mission Players - A

    0_1485627728243_upload-53785afb-4982-4736-9c45-566ef690378a Back Yard
    Camera Diagram

    Legend

    Camera Arizona
    Viewing Direction Garage Arcadia Door Room

    Not Drawn to scale Family Room

    										Master Bath						Utility												Kitchen											Laundry								
    												 																																			
    		Master Bed Room																																													
    																																															
    									Closet				Bath			HVAC																															
    													 																															 	 		
    																																													 		
    																																															
    Closet																																															
    																																									Back Yard						
    																												Living Room																			
    																																														 	
    																																															
    		Joey's 								Maia's									Kayla's																												
    		Room								Room									Room																												
    

    Awe yeah! Win10 Chrome 55.numbers Office Excel 2016.

    Edit: Strangely enough, Excel doesn't provide the picture if I select the whole sheet...



  • @anonymous234 said in Pasting from Excel:

    (but not text/html ).

    I think that by default nodebb doesn't allow html. At least, there's a setting in the markdown plugin (is it possible to run nodebb without that?) to explicitly allow it, with a big warning about doing so.

    0_1485629728715_upload-f5525454-6f2d-4855-9b71-68dad01232cc

    So it probably avoids that. Maybe it could be smarter to take the html if that's allowed.


  • Winner of the 2016 Presidential Election

    @boomzilla said in Pasting from Excel:

    I think that by default nodebb doesn't allow html.

    Correct. @ben_lubar's sanitization plugin is the one doing the job of sanitizing instead of NodeBB, but the default is SANTIZE EVERYTHING OUT



  • @sloosecannon Yeah, that's what the markdown plugin does. I'm not sure what happens if you try to run nodebb without that, though. But I suspect the "avoid html" is basically hardcoded into the composer.



  • @boomzilla Or translate HTML to markdown, at least the basic tags like <i>

    Yes, I know that's hard, but hey, they picked Markdown as the markup language knowing fully well that literally >99.999% of the content out there is in HTML, so... ¯\_(ツ)_/¯



  • JIRA also fucks this up bigtime. If you're copypastaing from OneNote to a description/comment field in JIRA, it wants to upload the note as an attachment. :slight_frown:



  • @boomzilla said in Pasting from Excel:

    At least, there's a setting in the markdown plugin (is it possible to run nodebb without that?)

    Yes, you can run NodeBB without the default plugins. Without the Markdown plugin, it just puts whatever HTML you post on the page a la Community Server.



  • @Tsaukpaetra said in Pasting from Excel:

    Master Bath

    Is it for master bathing?


  • Impossible Mission Players - A

    @Maciejasjmj said in Pasting from Excel:

    @Tsaukpaetra said in Pasting from Excel:

    Master Bath

    Is it for master bathing?

    Well, I elided the "Slave Bath", but you caught me!



  • @Tsaukpaetra What's an Arizona room?


  • Impossible Mission Players - A

    @djls45 said in Pasting from Excel:

    @Tsaukpaetra What's an Arizona room?

    I have no idea. I think it's like a sunroom, but drier?

    Full disclosure: This wasn't my Excel doc. ;)



  • @Tsaukpaetra said in Pasting from Excel:

    This wasn't my Excel doc.

    And that isn't your porn folder?

    Oh no wait, that's mine.


  • mod

    @djls45 said in Pasting from Excel:

    @Tsaukpaetra What's an Arizona room?

    It's a semi-enclosed room, typically a porch that has been enclosed with walls and screens and had ceiling fans installed. They give you the feeling of being outdoors while keeping the bugs away and typically being a bit cooler than out in the direct sunlight. Some Arizona rooms can be completely closed up during cooler weather, turning the room into a cross between a greenhouse and a patio.



  • TIL that copying in Excel also grabs a screenshot of what you copied!


  • Impossible Mission - B

    @abarker said in Pasting from Excel:

    It's a semi-enclosed room, typically a porch that has been enclosed with walls and screens and had ceiling fans installed. They give you the feeling of being outdoors while keeping the bugs away and typically being a bit cooler than out in the direct sunlight. Some Arizona rooms can be completely closed up during cooler weather, turning the room into a cross between a greenhouse and a patio.

    My sister's place has one of those, except they're in Utah so it was designed with the opposite goal in mind: keep out the snow!


Log in to reply
 

Looks like your connection to What the Daily WTF? was lost, please wait while we try to reconnect.