Version: 1.3 (using KDE KDE 3.2.1) Installed from: SuSE RPMs OS: Linux I imported the file isdn.log. After import, long phone numbers , like +493034356192, are not displayed as text but as a scientific notation of this number (4,93034356E+11). I tried to change the column format by selecting the column and then changing by selecting Format->Cell format->Text with no result. First: text column of the import file should stay text Second: changes in the cell layout should affect all cells selected.
I have the same problem here. It seems that the kspread changes only the first cell. I have tried to change not only the text, but the type and color of the cell.
First: You are absolutely correct. Second: Yes, but it does. The problem is that the first step imports the values as floating point values. I will see if I can do anything about it.
Hi Inge, TIA. I really appreciate your efforts! Best Weert Am Mittwoch, 18. Mai 2005 21:22 schrieb Inge Wallin: [bugs.kde.org quoted mail]
This bug is still valid, but with some changes. I created a file (Using vi.) eleven lines in length and called it isdn.log. Each line consisting of the number 493034356192. When importing I chose to import it as a text file using the UTF-8 encoding. In the import dialog I confirmed that "text" was the assumed format. When imported into Kspread the cells had a format of "Generic" and contained the number "-2147483648" while "493034356192" was displayed in the formula field. I then manually converted the cell format to text. Resulting in "-2147483648" just left shifting. Converting another cell to text and manually writing in "493034356192" resulted in "493034356192" being written. All this in Kspread 1.5 Cheers Jo
The part of the from "493034356192" to "-2147483648" changed numeric value is a duplicate of bug 127599 while the text-formating problem is another issue. So, to have a textfile like; +493034356192,783246786894 and to choose Insert=>External Data=>from Textfile at least the first column (the +493034356192 value) is imported as numeric value rather then as the expected and in the "Inserting Text File" displayed Text-Format. The Cell-format is generic and _not_ as displayed "Text". But if the user choosedin the "Inserting Text File" dialog explicit the first column, changes the format from text to e.g. numeric and back to text and then imports, the column's format is text.
I can report the same error, but this time on the cell format "currency". It also works with the date format. That's really a bad bug. I have a lot of values in a table: the date in one column, the amount of currency in the next. Whenever I select en entire column in order to adjust the cell type, it has no effect. No matter which cell type I pick. Let's vote for this bug to rank it higher. :-)
Why is this not being worked on. This bug is a critical issue to make kspread really usable for financial calculations.
> Why is this not being worked on. Got a patch?
OK, scratch my comment and let's try again. > Why is this not being worked on. Because no one seemed to do care enough. Sooner or later, when there are enough developers which have enough time available, the bug will be fixed. But both resources are not there for KSpread (not as much as needed) so that's why. So we need patience, or if patience is not an option, you (or someone who reads this) could submit a patch to resolve the issue.
On 16.05.2007, Bram Schoenmakers wrote: [bugs.kde.org quoted mail] I agree only partially: - three years is far too long for a bug not to be fixed. - the bug should easy to be fixed since it's obvious and not a mysterious program crash. - I am not the only one who reported and voted for it. - it makes CVS import, an important feature, unusable. And I think that makes it worth mentioning -and- critizising. If you disagree with me, fine, but take it this way: if open source developers do not want users to give comments to their work - why do they release it? And another, personal aspect: I test the software, work with it, create sheets and then, after a lot of work I stumble over a simple and old bug, that forces me to change the software. I think, I may be a little bit angry.
SVN commit 696591 by nikolaus: Painting Content Format. The Style's content format now takes precedence over the one of Value. This fixes the issue, that you were not able to change the format after importing CSV values as text. Errors will always be centered now. BUGS: 87471, 137375 M +1 -1 Cell.cpp M +57 -20 ValueConverter.cpp M +8 -8 ValueConverter.h M +92 -54 ValueFormatter.cpp M +6 -6 ValueFormatter.h M +1 -1 dialogs/LayoutDialog.cpp M +29 -13 ui/CellView.cpp