Dec 18, 2025, 7:49:57 AM
|
Sweet Home 3D Forum » List all forums » » Forum: New versions » » » Thread: Sweet Home 3D 6.0 » » » » Post: Re: Sweet Home 3D 6.0 |
Print at Dec 18, 2025, 7:49:57 AM |
| Posted by hansmex at Sep 27, 2018, 4:36:27 PM |
|
Re: Sweet Home 3D 6.0 Emmanuel, Thanks to UbuntuBirdy I'm finally able to test beta 11 under Ubuntu. There's a few things I want to share. 1 - CSV export This feature works fine, but isn't perfect. When I tested an earlier version under Windows, I noted that values were exported as text, not as numbers. This hasn't changed in the beta 11. In an earlier message you wrote that the exported CSV is correctly interpreted by Excel and LibreOffice. Can you explain how you do that? Here's a spreadsheet that shows what happens when I import CSV in LibreOffice, and what you need to do to be able to use the exported data. Am I doing it the wrong way? a - The green colums show what is exported from SH3D. In row 17 you can see that the totals are 0, meaning that you can't use the exported values, because they are text. b - The pink columns show how we need to change the imported text: a column with the currency, than columns with numerical values. If you look at the formula, it's easy enough to extract the wanted numerical value from the text, but I think it's beyond the spreadsheet knowledge of most people. c - The yellow columns show what we really need: values. Currently we need TWO conversions: first step (pink) is separate text and values, second step (yellow) is Paste-Special to obtain pure values (without underlying formula). It also means that in the current situation we MUST keep the original until we have performed the second step, because when we delete the original info after the first step, all values will revert to zero. 2 - Multi-line text The possibility to have multi-line text is very welcome. I notice that changing the text orientation from left to center or right, the box around it moves. Ideally the box stays in the same spot, and only the text moves within the box. Also, it would be nice if the text interface window had the option "Part of base plan". I will do more testing in the coming days. Thank you once again for all the splendid work!! Hans ---------------------------------------- Hans new website - under constuction hansdirkse.info |
|
|
Current timezone is GMT Dec 18, 2025, 7:49:57 AM |