0.03 Showing as 0.3 in LO tables from Excel

General discussion related to LayOut

0.03 Showing as 0.3 in LO tables from Excel

Postby brettsichellodesign » Tue Aug 01, 2017 10:26 pm

Can anyone tell me why LO is changing my 0.03 value to 0.3 when I reference my excel spreadsheet?

See image attached:

0
User avatar
brettsichellodesign 
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby Dave R » Wed Aug 02, 2017 12:31 am

How are those cells formatted in the spreadsheet? It's odd that it shows as 0.3. with a decimal after the 3, too.
0
Inspecting mirrors is a job I could easily see myself doing.

If you are the smartest person in the room, you are in the wrong room.
User avatar
Dave R 
Global Moderator
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby brettsichellodesign » Wed Aug 02, 2017 12:51 am

I've been trying to figure it out and can't seem to find the issue. Maybe a bug?

I have attached details of formatting in excel. Though I have not imported the formatting into LO.

0
User avatar
brettsichellodesign 
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby Dave R » Wed Aug 02, 2017 12:58 am

Do you need that column to do any math? If not, how about converting the formatting to text in the spreadsheet. Maybe you could at least move on with the work. Could you share the spread sheet file so I can try inserting it into LO to see what I get? Send it by PM if you don't want to make it public.
0
Inspecting mirrors is a job I could easily see myself doing.

If you are the smartest person in the room, you are in the wrong room.
User avatar
Dave R 
Global Moderator
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby Charlie__V » Wed Aug 02, 2017 12:29 pm

brettsichellodesign wrote:I have attached details of formatting in excel. Though I have not imported the formatting into LO.


I see the Excel file has generous cell width compared to the cell width in LO table.
Maybe try expanding the whole LO table width and see if the decimal point issue in column "F" resolves itself?

Just a guess.

Charlie
0
Precision M1710/Win 7 Pro 64 bit/i-7 6920 Quad core 2.9 Ghz -3.8/16Gb ram/NVIDIA M5000M 8Gb

Charlie__V 
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby brettsichellodesign » Wed Aug 02, 2017 5:15 pm

I tried changing the cell formatting from number to text which did solve the problem. I could even keep the formula in the cell, but can't change the decimal places which is a bit annoying but I can probably solve that in a more complex formula.

Changing the table width in LO didn't appear to solve the problem, but maybe Dave can take a look and figure it out :)

I guess it's half solved at the moment.
0
User avatar
brettsichellodesign 
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby Dave R » Wed Aug 02, 2017 5:20 pm

Could you send me the spreadsheet file by PM so I can play with it and see what I get? I'll take a look when I get home from work.

Edit: Oops. Your PM came while I was posting this. Will look ASAP.
0
Inspecting mirrors is a job I could easily see myself doing.

If you are the smartest person in the room, you are in the wrong room.
User avatar
Dave R 
Global Moderator
 

Re: 0.03 Showing as 0.3 in LO tables from Excel

Postby brettsichellodesign » Thu Aug 10, 2017 10:40 pm

Just a heads up that Dave is working with the LO team to resolve the issue. However in the meantime I would suggest using the ROUNDUP and IFERROR functions in Excel. For example:

=IFERROR(ROUND(O11/5.678,2),"")

This has solved my issue in LO.
0
User avatar
brettsichellodesign 
 

SketchUcation One-Liner Adverts

by Ad Machine » 5 minutes ago



Ad Machine 
Robot
 



 

Return to LayOut Discussions

Who is online

Users browsing this forum: No registered users and 1 guest

Visit our sponsors: